Difference between revisions of "Manuals/calci/ALL"
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
===Other Functions=== | ===Other Functions=== | ||
| + | *[[Manuals/calci/ABC | ABC ]] | ||
| + | *[[Manuals/calci/ABS | ABS ]] | ||
| + | *[[Manuals/calci/ACCRINT | ACCRINT ]] | ||
| + | *[[Manuals/calci/ACOS | ACOS ]] | ||
| + | *[[Manuals/calci/ACOSH | ACOSH ]] | ||
| + | *[[Manuals/calci/ADDRESS | ADDRESS ]] | ||
| + | *[[Manuals/calci/AMORDEGRC | AMORDEGRC ]] | ||
| + | *[[Manuals/calci/AMORLINC | AMORLINC ]] | ||
| + | *[[Manuals/calci/AND | AND ]] | ||
| + | *[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR ]] | ||
| + | *[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION ]] | ||
| + | *[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION ]] | ||
| + | *[[Manuals/calci/AREAS | AREAS ]] | ||
| + | *[[Manuals/calci/ASIN | ASIN ]] | ||
| + | *[[Manuals/calci/ASINH | ASINH ]] | ||
| + | *[[Manuals/calci/ATAN | ATAN ]] | ||
| + | *[[Manuals/calci/ATAN2 | ATAN2 ]] | ||
| + | *[[Manuals/calci/ATANH | ATANH ]] | ||
| + | *[[Manuals/calci/AVEDEV | AVEDEV ]] | ||
| + | *[[Manuals/calci/AVERAGE | AVERAGE ]] | ||
| + | *[[Manuals/calci/AVERAGEA | AVERAGEA ]] | ||
| + | *[[Manuals/calci/BERNOULLI | BERNOULLI ]] | ||
| + | *[[Manuals/calci/BESSELI | BESSELI ]] | ||
| + | *[[Manuals/calci/BESSELJ | BESSELJ ]] | ||
| + | *[[Manuals/calci/BESSELK | BESSELK ]] | ||
| + | *[[Manuals/calci/BESSELY | BESSELY ]] | ||
| + | *[[Manuals/calci/BETADIST | BETADIST ]] | ||
| + | *[[Manuals/calci/BETAINV | BETAINV ]] | ||
*[[Manuals/calci/BIN2DEC | BIN2DEC ]] | *[[Manuals/calci/BIN2DEC | BIN2DEC ]] | ||
*[[Manuals/calci/BIN2HEX | BIN2HEX ]] | *[[Manuals/calci/BIN2HEX | BIN2HEX ]] | ||
*[[Manuals/calci/BIN2OCT | BIN2OCT ]] | *[[Manuals/calci/BIN2OCT | BIN2OCT ]] | ||
| + | *[[Manuals/calci/BINOMDIST | BINOMDIST ]] | ||
| + | *[[Manuals/calci/BINOMIAL | BINOMIAL ]] | ||
| + | *[[Manuals/calci/calci_sum | calci_sum ]] | ||
| + | *[[Manuals/calci/CEILING | CEILING ]] | ||
| + | *[[Manuals/calci/CELL | CELL ]] | ||
| + | *[[Manuals/calci/CHAR | CHAR ]] | ||
| + | *[[Manuals/calci/CHIDIST | CHIDIST ]] | ||
| + | *[[Manuals/calci/CHIINV | CHIINV ]] | ||
| + | *[[Manuals/calci/CHINV | CHINV ]] | ||
| + | *[[Manuals/calci/CHITEST | CHITEST ]] | ||
| + | *[[Manuals/calci/CHOOSE | CHOOSE ]] | ||
| + | *[[Manuals/calci/CIRCLE | CIRCLE ]] | ||
| + | *[[Manuals/calci/CLEAN | CLEAN ]] | ||
| + | *[[Manuals/calci/CODE | CODE ]] | ||
| + | *[[Manuals/calci/COLUMN | COLUMN ]] | ||
| + | *[[Manuals/calci/COLUMNS | COLUMNS ]] | ||
| + | *[[Manuals/calci/COMBIN | COMBIN ]] | ||
| + | *[[Manuals/calci/COMPLEX | COMPLEX ]] | ||
| + | *[[Manuals/calci/CONCATENATE | CONCATENATE ]] | ||
| + | *[[Manuals/calci/CONE | CONE ]] | ||
| + | *[[Manuals/calci/CONFIDENCE | CONFIDENCE ]] | ||
| + | *[[Manuals/calci/CONVERT | CONVERT ]] | ||
| + | *[[Manuals/calci/CORREL | CORREL ]] | ||
| + | *[[Manuals/calci/CORRELATION | CORRELATION ]] | ||
| + | *[[Manuals/calci/COS | COS ]] | ||
| + | *[[Manuals/calci/COSEC | COSEC ]] | ||
| + | *[[Manuals/calci/COSH | COSH ]] | ||
| + | *[[Manuals/calci/COTAN | COTAN ]] | ||
| + | *[[Manuals/calci/COTH | COTH ]] | ||
| + | *[[Manuals/calci/COUNT | COUNT ]] | ||
| + | *[[Manuals/calci/COUNTA | COUNTA ]] | ||
| + | *[[Manuals/calci/COUNTBLANK | COUNTBLANK ]] | ||
| + | *[[Manuals/calci/COUNTIF | COUNTIF ]] | ||
| + | *[[Manuals/calci/COUPDAYBS | COUPDAYBS ]] | ||
| + | *[[Manuals/calci/COUPDAYS | COUPDAYS ]] | ||
| + | *[[Manuals/calci/COUPDAYSNC | COUPDAYSNC ]] | ||
| + | *[[Manuals/calci/COUPNUM | COUPNUM ]] | ||
| + | *[[Manuals/calci/COVAR | COVAR ]] | ||
| + | *[[Manuals/calci/COVARIANCE | COVARIANCE ]] | ||
| + | *[[Manuals/calci/CRITBINOM | CRITBINOM ]] | ||
| + | *[[Manuals/calci/CYLINDER | CYLINDER ]] | ||
| + | *[[Manuals/calci/DATE | DATE ]] | ||
| + | *[[Manuals/calci/date1 | date1 ]] | ||
| + | *[[Manuals/calci/datevalue | datevalue ]] | ||
| + | *[[Manuals/calci/DAVERAGE | DAVERAGE ]] | ||
| + | *[[Manuals/calci/DAY | DAY ]] | ||
| + | *[[Manuals/calci/DAYS360 | DAYS360 ]] | ||
| + | *[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN ]] | ||
| + | *[[Manuals/calci/DCOS | DCOS ]] | ||
| + | *[[Manuals/calci/DCOSEC | DCOSEC ]] | ||
| + | *[[Manuals/calci/DCOTAN | DCOTAN ]] | ||
| + | *[[Manuals/calci/DCOUNT | DCOUNT ]] | ||
| + | *[[Manuals/calci/DCOUNTA | DCOUNTA ]] | ||
| + | *[[Manuals/calci/DDB | DDB ]] | ||
*[[Manuals/calci/DEC2BIN | DEC2BIN ]] | *[[Manuals/calci/DEC2BIN | DEC2BIN ]] | ||
*[[Manuals/calci/DEC2HEX | DEC2HEX ]] | *[[Manuals/calci/DEC2HEX | DEC2HEX ]] | ||
*[[Manuals/calci/DEC2OCT | DEC2OCT ]] | *[[Manuals/calci/DEC2OCT | DEC2OCT ]] | ||
| + | *[[Manuals/calci/DEGREES | DEGREES ]] | ||
*[[Manuals/calci/DELTA | DELTA ]] | *[[Manuals/calci/DELTA | DELTA ]] | ||
| + | *[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS ]] | ||
| + | *[[Manuals/calci/DEVSQ | DEVSQ ]] | ||
*[[Manuals/calci/DGET | DGET ]] | *[[Manuals/calci/DGET | DGET ]] | ||
| + | *[[Manuals/calci/DISC | DISC ]] | ||
*[[Manuals/calci/DISCRETE | DISCRETE ]] | *[[Manuals/calci/DISCRETE | DISCRETE ]] | ||
*[[Manuals/calci/DISTANCE | DISTANCE ]] | *[[Manuals/calci/DISTANCE | DISTANCE ]] | ||
*[[Manuals/calci/DMAX | DMAX ]] | *[[Manuals/calci/DMAX | DMAX ]] | ||
*[[Manuals/calci/DMIN | DMIN ]] | *[[Manuals/calci/DMIN | DMIN ]] | ||
| + | *[[Manuals/calci/DOLLAR | DOLLAR ]] | ||
| + | *[[Manuals/calci/DOLLARDE | DOLLARDE ]] | ||
| + | *[[Manuals/calci/DOLLARFR | DOLLARFR ]] | ||
*[[Manuals/calci/DPRODUCT | DPRODUCT ]] | *[[Manuals/calci/DPRODUCT | DPRODUCT ]] | ||
| + | *[[Manuals/calci/DSEC | DSEC ]] | ||
| + | *[[Manuals/calci/DSIN | DSIN ]] | ||
| + | *[[Manuals/calci/DSTDEV | DSTDEV ]] | ||
| + | *[[Manuals/calci/DSTDEVP | DSTDEVP ]] | ||
*[[Manuals/calci/DSUM | DSUM ]] | *[[Manuals/calci/DSUM | DSUM ]] | ||
| + | *[[Manuals/calci/DTAN | DTAN ]] | ||
*[[Manuals/calci/DURATION | DURATION ]] | *[[Manuals/calci/DURATION | DURATION ]] | ||
| + | *[[Manuals/calci/DVAR | DVAR ]] | ||
| + | *[[Manuals/calci/DVARP | DVARP ]] | ||
| + | *[[Manuals/calci/EDATE | EDATE ]] | ||
| + | *[[Manuals/calci/EFFECT | EFFECT ]] | ||
| + | *[[Manuals/calci/ELLIPSE | ELLIPSE ]] | ||
| + | *[[Manuals/calci/EOMONTH | EOMONTH ]] | ||
| + | *[[Manuals/calci/ERF | ERF ]] | ||
| + | *[[Manuals/calci/ERFC | ERFC ]] | ||
| + | *[[Manuals/calci/EUROCONVERT | EUROCONVERT ]] | ||
*[[Manuals/calci/EVEN | EVEN ]] | *[[Manuals/calci/EVEN | EVEN ]] | ||
| + | *[[Manuals/calci/EXACT | EXACT ]] | ||
| + | *[[Manuals/calci/EXP | EXP ]] | ||
| + | *[[Manuals/calci/EXPONDIST | EXPONDIST ]] | ||
| + | *[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING ]] | ||
| + | *[[Manuals/calci/FACT | FACT ]] | ||
| + | *[[Manuals/calci/FACTDOUBLE | FACTDOUBLE ]] | ||
| + | *[[Manuals/calci/FDIST | FDIST ]] | ||
| + | *[[Manuals/calci/FIBONNACI | FIBONNACI ]] | ||
| + | *[[Manuals/calci/FIND | FIND ]] | ||
| + | *[[Manuals/calci/FINV | FINV ]] | ||
| + | *[[Manuals/calci/FISHER | FISHER ]] | ||
| + | *[[Manuals/calci/FISHERINV | FISHERINV ]] | ||
*[[Manuals/calci/FIXED | FIXED ]] | *[[Manuals/calci/FIXED | FIXED ]] | ||
| + | *[[Manuals/calci/FLOOR | FLOOR ]] | ||
| + | *[[Manuals/calci/FORECAST | FORECAST ]] | ||
| + | *[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS ]] | ||
| + | *[[Manuals/calci/FREQUENCY | FREQUENCY ]] | ||
| + | *[[Manuals/calci/FTEST | FTEST ]] | ||
| + | *[[Manuals/calci/FTESTANALYSIS | FTESTANALYSIS ]] | ||
| + | *[[Manuals/calci/GAMMADIST | GAMMADIST ]] | ||
| + | *[[Manuals/calci/GAMMAINV | GAMMAINV ]] | ||
| + | *[[Manuals/calci/GAMMALN | GAMMALN ]] | ||
*[[Manuals/calci/GCD | GCD ]] | *[[Manuals/calci/GCD | GCD ]] | ||
| + | *[[Manuals/calci/GEOMEAN | GEOMEAN ]] | ||
| + | *[[Manuals/calci/GESTEP | GESTEP ]] | ||
| + | *[[Manuals/calci/GOLDENANGLE | GOLDENANGLE ]] | ||
| + | *[[Manuals/calci/GOLDENRATIO | GOLDENRATIO ]] | ||
| + | *[[Manuals/calci/GROWTH | GROWTH ]] | ||
| + | *[[Manuals/calci/HARMEAN | HARMEAN ]] | ||
| + | *[[Manuals/calci/help | help ]] | ||
*[[Manuals/calci/HEX2BIN | HEX2BIN ]] | *[[Manuals/calci/HEX2BIN | HEX2BIN ]] | ||
*[[Manuals/calci/HEX2DEC | HEX2DEC ]] | *[[Manuals/calci/HEX2DEC | HEX2DEC ]] | ||
*[[Manuals/calci/HEX2OCT | HEX2OCT ]] | *[[Manuals/calci/HEX2OCT | HEX2OCT ]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/HISTOGRAM | HISTOGRAM ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/HLOOKUP | HLOOKUP ]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/HOUR | HOUR ]] | *[[Manuals/calci/HOUR | HOUR ]] | ||
*[[Manuals/calci/HYPERLINK | HYPERLINK ]] | *[[Manuals/calci/HYPERLINK | HYPERLINK ]] | ||
| + | *[[Manuals/calci/HYPGEOMDIST | HYPGEOMDIST ]] | ||
| + | *[[Manuals/calci/HYPOTENUSE | HYPOTENUSE ]] | ||
| + | *[[Manuals/calci/IF | IF ]] | ||
| + | *[[Manuals/calci/IMABS | IMABS ]] | ||
| + | *[[Manuals/calci/IMAGINARY | IMAGINARY ]] | ||
| + | *[[Manuals/calci/IMARGUMENT | IMARGUMENT ]] | ||
| + | *[[Manuals/calci/IMCONJUGATE | IMCONJUGATE ]] | ||
| + | *[[Manuals/calci/IMCOS | IMCOS ]] | ||
| + | *[[Manuals/calci/IMDIV | IMDIV ]] | ||
| + | *[[Manuals/calci/IMEXP | IMEXP ]] | ||
| + | *[[Manuals/calci/IMLN | IMLN ]] | ||
| + | *[[Manuals/calci/IMLOG10 | IMLOG10 ]] | ||
| + | *[[Manuals/calci/IMLOG2 | IMLOG2 ]] | ||
*[[Manuals/calci/IMPOWER | IMPOWER ]] | *[[Manuals/calci/IMPOWER | IMPOWER ]] | ||
*[[Manuals/calci/IMPRODUCT | IMPRODUCT ]] | *[[Manuals/calci/IMPRODUCT | IMPRODUCT ]] | ||
*[[Manuals/calci/IMREAL | IMREAL ]] | *[[Manuals/calci/IMREAL | IMREAL ]] | ||
| + | *[[Manuals/calci/IMSIN | IMSIN ]] | ||
*[[Manuals/calci/IMSQRT | IMSQRT ]] | *[[Manuals/calci/IMSQRT | IMSQRT ]] | ||
*[[Manuals/calci/IMSUB | IMSUB ]] | *[[Manuals/calci/IMSUB | IMSUB ]] | ||
*[[Manuals/calci/IMSUM | IMSUM ]] | *[[Manuals/calci/IMSUM | IMSUM ]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/INDEX | INDEX ]] | *[[Manuals/calci/INDEX | INDEX ]] | ||
*[[Manuals/calci/INDIRECT | INDIRECT ]] | *[[Manuals/calci/INDIRECT | INDIRECT ]] | ||
| + | *[[Manuals/calci/INT | INT ]] | ||
| + | *[[Manuals/calci/INTERCEPT | INTERCEPT ]] | ||
*[[Manuals/calci/INTRATE | INTRATE ]] | *[[Manuals/calci/INTRATE | INTRATE ]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/IPMT | IPMT ]] | *[[Manuals/calci/IPMT | IPMT ]] | ||
*[[Manuals/calci/IS FUNCTIONS | IS FUNCTIONS ]] | *[[Manuals/calci/IS FUNCTIONS | IS FUNCTIONS ]] | ||
*[[Manuals/calci/ISBLANK | ISBLANK ]] | *[[Manuals/calci/ISBLANK | ISBLANK ]] | ||
*[[Manuals/calci/ISEVEN | ISEVEN ]] | *[[Manuals/calci/ISEVEN | ISEVEN ]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR ]] | *[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR ]] | ||
*[[Manuals/calci/ISLOGICAL | ISLOGICAL ]] | *[[Manuals/calci/ISLOGICAL | ISLOGICAL ]] | ||
*[[Manuals/calci/ISNUMBER | ISNUMBER ]] | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
| + | *[[Manuals/calci/ISODD | ISODD ]] | ||
*[[Manuals/calci/ISPMT | ISPMT ]] | *[[Manuals/calci/ISPMT | ISPMT ]] | ||
*[[Manuals/calci/ISPRIME | ISPRIME ]] | *[[Manuals/calci/ISPRIME | ISPRIME ]] | ||
| + | *[[Manuals/calci/ISTEXT | ISTEXT ]] | ||
| + | *[[Manuals/calci/ITHPRIME | ITHPRIME ]] | ||
| + | *[[Manuals/calci/KURT | KURT ]] | ||
| + | *[[Manuals/calci/LARGE | LARGE ]] | ||
| + | *[[Manuals/calci/LCM | LCM ]] | ||
| + | *[[Manuals/calci/LEFT | LEFT ]] | ||
| + | *[[Manuals/calci/LEFTB | LEFTB ]] | ||
| + | *[[Manuals/calci/LEN | LEN ]] | ||
| + | *[[Manuals/calci/LENB | LENB ]] | ||
| + | *[[Manuals/calci/LINEST | LINEST ]] | ||
*[[Manuals/calci/LISTPRIMES | LISTPRIMES ]] | *[[Manuals/calci/LISTPRIMES | LISTPRIMES ]] | ||
| + | *[[Manuals/calci/LN | LN ]] | ||
| + | *[[Manuals/calci/LOG | LOG ]] | ||
| + | *[[Manuals/calci/LOG10 | LOG10 ]] | ||
| + | *[[Manuals/calci/LOGEST | LOGEST ]] | ||
| + | *[[Manuals/calci/LOGINV | LOGINV ]] | ||
*[[Manuals/calci/LOGNORMDIST | LOGNORMDIST ]] | *[[Manuals/calci/LOGNORMDIST | LOGNORMDIST ]] | ||
| + | *[[Manuals/calci/LOOKUP | LOOKUP ]] | ||
*[[Manuals/calci/LOWER | LOWER ]] | *[[Manuals/calci/LOWER | LOWER ]] | ||
| + | *[[Manuals/calci/LOWER1 | LOWER1 ]] | ||
| + | *[[Manuals/calci/LUCAS | LUCAS ]] | ||
| + | *[[Manuals/calci/MATCH | MATCH ]] | ||
| + | *[[Manuals/calci/MAX | MAX ]] | ||
| + | *[[Manuals/calci/MAX1 | MAX1 ]] | ||
*[[Manuals/calci/MAXA | MAXA ]] | *[[Manuals/calci/MAXA | MAXA ]] | ||
| + | *[[Manuals/calci/MAXA1 | MAXA1 ]] | ||
*[[Manuals/calci/MDETERM | MDETERM ]] | *[[Manuals/calci/MDETERM | MDETERM ]] | ||
| + | *[[Manuals/calci/MDURATION | MDURATION ]] | ||
| + | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
| + | *[[Manuals/calci/MID | MID ]] | ||
| + | *[[Manuals/calci/MIDB | MIDB ]] | ||
*[[Manuals/calci/MIN | MIN ]] | *[[Manuals/calci/MIN | MIN ]] | ||
*[[Manuals/calci/MIN1 | MIN1 ]] | *[[Manuals/calci/MIN1 | MIN1 ]] | ||
| Line 195: | Line 258: | ||
*[[Manuals/calci/MINUTE | MINUTE ]] | *[[Manuals/calci/MINUTE | MINUTE ]] | ||
*[[Manuals/calci/MINVERSE | MINVERSE ]] | *[[Manuals/calci/MINVERSE | MINVERSE ]] | ||
| + | *[[Manuals/calci/MMULT | MMULT ]] | ||
*[[Manuals/calci/MOD | MOD ]] | *[[Manuals/calci/MOD | MOD ]] | ||
*[[Manuals/calci/MODE | MODE ]] | *[[Manuals/calci/MODE | MODE ]] | ||
*[[Manuals/calci/MONTH | MONTH ]] | *[[Manuals/calci/MONTH | MONTH ]] | ||
| + | *[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE ]] | ||
*[[Manuals/calci/MROUND | MROUND ]] | *[[Manuals/calci/MROUND | MROUND ]] | ||
*[[Manuals/calci/MULTINOMIAL | MULTINOMIAL ]] | *[[Manuals/calci/MULTINOMIAL | MULTINOMIAL ]] | ||
*[[Manuals/calci/N | N ]] | *[[Manuals/calci/N | N ]] | ||
| + | *[[Manuals/calci/NEGBINOMDIS | NEGBINOMDIS ]] | ||
| + | *[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST ]] | ||
| + | *[[Manuals/calci/NETWORKDAYS | NETWORKDAYS ]] | ||
| + | *[[Manuals/calci/NORMAL | NORMAL ]] | ||
*[[Manuals/calci/NORMDIST | NORMDIST ]] | *[[Manuals/calci/NORMDIST | NORMDIST ]] | ||
*[[Manuals/calci/NORMINV | NORMINV ]] | *[[Manuals/calci/NORMINV | NORMINV ]] | ||
*[[Manuals/calci/NORMSDIST | NORMSDIST ]] | *[[Manuals/calci/NORMSDIST | NORMSDIST ]] | ||
*[[Manuals/calci/NORMSINV | NORMSINV ]] | *[[Manuals/calci/NORMSINV | NORMSINV ]] | ||
| + | *[[Manuals/calci/NOT | NOT ]] | ||
| + | *[[Manuals/calci/OCT2BIN | OCT2BIN ]] | ||
| + | *[[Manuals/calci/OCT2DEC | OCT2DEC ]] | ||
| + | *[[Manuals/calci/OCT2HEX | OCT2HEX ]] | ||
| + | *[[Manuals/calci/ODD | ODD ]] | ||
| + | *[[Manuals/calci/OFFSET | OFFSET ]] | ||
| + | *[[Manuals/calci/OR | OR ]] | ||
*[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE ]] | *[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE ]] | ||
| + | *[[Manuals/calci/PATTERNED | PATTERNED ]] | ||
*[[Manuals/calci/PEARSON | PEARSON ]] | *[[Manuals/calci/PEARSON | PEARSON ]] | ||
*[[Manuals/calci/PERCENTILE | PERCENTILE ]] | *[[Manuals/calci/PERCENTILE | PERCENTILE ]] | ||
| Line 211: | Line 288: | ||
*[[Manuals/calci/PERMUT | PERMUT ]] | *[[Manuals/calci/PERMUT | PERMUT ]] | ||
*[[Manuals/calci/PI | PI ]] | *[[Manuals/calci/PI | PI ]] | ||
| + | *[[Manuals/calci/POINT | POINT ]] | ||
*[[Manuals/calci/poisson | poisson ]] | *[[Manuals/calci/poisson | poisson ]] | ||
| + | *[[Manuals/calci/POISSONDISTRIBUTION | POISSONDISTRIBUTION ]] | ||
*[[Manuals/calci/POWER | POWER ]] | *[[Manuals/calci/POWER | POWER ]] | ||
| + | *[[Manuals/calci/PRICE | PRICE ]] | ||
| + | *[[Manuals/calci/PRICEDISC | PRICEDISC ]] | ||
| + | *[[Manuals/calci/PRICEMAT | PRICEMAT ]] | ||
*[[Manuals/calci/PROB | PROB ]] | *[[Manuals/calci/PROB | PROB ]] | ||
| + | *[[Manuals/calci/PRODUCT | PRODUCT ]] | ||
| + | *[[Manuals/calci/PROPER | PROPER ]] | ||
*[[Manuals/calci/QUARTILE | QUARTILE ]] | *[[Manuals/calci/QUARTILE | QUARTILE ]] | ||
| + | *[[Manuals/calci/QUOTIENT | QUOTIENT ]] | ||
| + | *[[Manuals/calci/RADIANS | RADIANS ]] | ||
*[[Manuals/calci/RAND | RAND ]] | *[[Manuals/calci/RAND | RAND ]] | ||
*[[Manuals/calci/RANDBBETWEEN | RANDBBETWEEN ]] | *[[Manuals/calci/RANDBBETWEEN | RANDBBETWEEN ]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/RANDBETWEEN | RANDBETWEEN ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/RANDOMNUMBERGENERATION | RANDOMNUMBERGENERATION ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM | RANDOMNUMBERGENERATIONUNIFORM ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/RANDOMUNIFORM | RANDOMUNIFORM ]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/RANK | RANK ]] | *[[Manuals/calci/RANK | RANK ]] | ||
*[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE ]] | *[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE ]] | ||
| + | *[[Manuals/calci/RATE | RATE ]] | ||
| + | *[[Manuals/calci/RECEIVED | RECEIVED ]] | ||
*[[Manuals/calci/REGRESSION | REGRESSION ]] | *[[Manuals/calci/REGRESSION | REGRESSION ]] | ||
| + | *[[Manuals/calci/REPLACE | REPLACE ]] | ||
| + | *[[Manuals/calci/REPLACEB | REPLACEB ]] | ||
| + | *[[Manuals/calci/REPT | REPT ]] | ||
| + | *[[Manuals/calci/RIGHT | RIGHT ]] | ||
| + | *[[Manuals/calci/RIGHTB | RIGHTB ]] | ||
*[[Manuals/calci/ROMAN | ROMAN ]] | *[[Manuals/calci/ROMAN | ROMAN ]] | ||
| + | *[[Manuals/calci/ROUND | ROUND ]] | ||
| + | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN ]] | ||
| + | *[[Manuals/calci/ROUNDUP | ROUNDUP ]] | ||
| + | *[[Manuals/calci/ROW | ROW ]] | ||
| + | *[[Manuals/calci/ROWS | ROWS ]] | ||
*[[Manuals/calci/RSQ | RSQ ]] | *[[Manuals/calci/RSQ | RSQ ]] | ||
| + | *[[Manuals/calci/SAMPLING | SAMPLING ]] | ||
| + | *[[Manuals/calci/SEARCH | SEARCH ]] | ||
| + | *[[Manuals/calci/SEARCHB | SEARCHB ]] | ||
| + | *[[Manuals/calci/SEC | SEC ]] | ||
| + | *[[Manuals/calci/SECH | SECH ]] | ||
*[[Manuals/calci/SECOND | SECOND ]] | *[[Manuals/calci/SECOND | SECOND ]] | ||
*[[Manuals/calci/SERIESSUM | SERIESSUM ]] | *[[Manuals/calci/SERIESSUM | SERIESSUM ]] | ||
*[[Manuals/calci/SIGN | SIGN ]] | *[[Manuals/calci/SIGN | SIGN ]] | ||
| + | *[[Manuals/calci/SIN | SIN ]] | ||
| + | *[[Manuals/calci/SINH | SINH ]] | ||
*[[Manuals/calci/SKEW | SKEW ]] | *[[Manuals/calci/SKEW | SKEW ]] | ||
*[[Manuals/calci/SLOPE | SLOPE ]] | *[[Manuals/calci/SLOPE | SLOPE ]] | ||
*[[Manuals/calci/SMALL | SMALL ]] | *[[Manuals/calci/SMALL | SMALL ]] | ||
| + | *[[Manuals/calci/SPHERE | SPHERE ]] | ||
| + | *[[Manuals/calci/SQRT | SQRT ]] | ||
| + | *[[Manuals/calci/SQRTPI | SQRTPI ]] | ||
| + | *[[Manuals/calci/STANDARDIZE | STANDARDIZE ]] | ||
*[[Manuals/calci/STDEV | STDEV ]] | *[[Manuals/calci/STDEV | STDEV ]] | ||
*[[Manuals/calci/STDEVA | STDEVA ]] | *[[Manuals/calci/STDEVA | STDEVA ]] | ||
| Line 242: | Line 346: | ||
*[[Manuals/calci/STDEVPA | STDEVPA ]] | *[[Manuals/calci/STDEVPA | STDEVPA ]] | ||
*[[Manuals/calci/STEYX | STEYX ]] | *[[Manuals/calci/STEYX | STEYX ]] | ||
| + | *[[Manuals/calci/SUBSTITUTE | SUBSTITUTE ]] | ||
*[[Manuals/calci/SUBTOTAL | SUBTOTAL ]] | *[[Manuals/calci/SUBTOTAL | SUBTOTAL ]] | ||
| + | *[[Manuals/calci/SUM | SUM ]] | ||
| + | *[[Manuals/calci/sum1 | sum1 ]] | ||
| + | *[[Manuals/calci/SUMIF | SUMIF ]] | ||
| + | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | ||
*[[Manuals/calci/SUMSQ | SUMSQ ]] | *[[Manuals/calci/SUMSQ | SUMSQ ]] | ||
*[[Manuals/calci/SUMX2MY2 | SUMX2MY2 ]] | *[[Manuals/calci/SUMX2MY2 | SUMX2MY2 ]] | ||
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2 ]] | *[[Manuals/calci/SUMX2PY2 | SUMX2PY2 ]] | ||
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | *[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | ||
| + | *[[Manuals/calci/T | T ]] | ||
| + | *[[Manuals/calci/TAN | TAN ]] | ||
| + | *[[Manuals/calci/TANH | TANH ]] | ||
*[[Manuals/calci/TDIST | TDIST ]] | *[[Manuals/calci/TDIST | TDIST ]] | ||
| + | *[[Manuals/calci/TIME | TIME ]] | ||
| + | *[[Manuals/calci/TIMEVALUE | TIMEVALUE ]] | ||
*[[Manuals/calci/TINV | TINV ]] | *[[Manuals/calci/TINV | TINV ]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/TRANSPOSE | TRANSPOSE ]] | *[[Manuals/calci/TRANSPOSE | TRANSPOSE ]] | ||
*[[Manuals/calci/TREND | TREND ]] | *[[Manuals/calci/TREND | TREND ]] | ||
*[[Manuals/calci/TRIANGLE | TRIANGLE ]] | *[[Manuals/calci/TRIANGLE | TRIANGLE ]] | ||
| + | *[[Manuals/calci/TRIM | TRIM ]] | ||
*[[Manuals/calci/TRIMMEAN | TRIMMEAN ]] | *[[Manuals/calci/TRIMMEAN | TRIMMEAN ]] | ||
*[[Manuals/calci/TRUNC | TRUNC ]] | *[[Manuals/calci/TRUNC | TRUNC ]] | ||
| Line 266: | Line 374: | ||
*[[Manuals/calci/TTESTUNEQUALVARIANCES | TTESTUNEQUALVARIANCES ]] | *[[Manuals/calci/TTESTUNEQUALVARIANCES | TTESTUNEQUALVARIANCES ]] | ||
*[[Manuals/calci/UNIFORM | UNIFORM ]] | *[[Manuals/calci/UNIFORM | UNIFORM ]] | ||
| + | *[[Manuals/calci/UPPER | UPPER ]] | ||
| + | *[[Manuals/calci/UPPER1 | UPPER1 ]] | ||
| + | *[[Manuals/calci/VALUE | VALUE ]] | ||
*[[Manuals/calci/VAR | VAR ]] | *[[Manuals/calci/VAR | VAR ]] | ||
*[[Manuals/calci/VARA | VARA ]] | *[[Manuals/calci/VARA | VARA ]] | ||
| Line 271: | Line 382: | ||
*[[Manuals/calci/VARPA | VARPA ]] | *[[Manuals/calci/VARPA | VARPA ]] | ||
*[[Manuals/calci/VECTOR | VECTOR ]] | *[[Manuals/calci/VECTOR | VECTOR ]] | ||
| + | *[[Manuals/calci/VLOOKUP | VLOOKUP ]] | ||
| + | *[[Manuals/calci/WEEKDAY | WEEKDAY ]] | ||
| + | *[[Manuals/calci/WEEKNUM | WEEKNUM ]] | ||
*[[Manuals/calci/WEIBULL | WEIBULL ]] | *[[Manuals/calci/WEIBULL | WEIBULL ]] | ||
| + | *[[Manuals/calci/WORKDAY | WORKDAY ]] | ||
| + | *[[Manuals/calci/YEAR | YEAR ]] | ||
| + | *[[Manuals/calci/YEARFRAC | YEARFRAC ]] | ||
*[[Manuals/calci/ZTEST | ZTEST ]] | *[[Manuals/calci/ZTEST | ZTEST ]] | ||
*[[Manuals/calci/ZTESTEQUALMEANS | ZTESTEQUALMEANS ]] | *[[Manuals/calci/ZTESTEQUALMEANS | ZTESTEQUALMEANS ]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 02:35, 4 February 2014
LIST OF ALL FUNCTIONS
Trignometric Functions
- ACOS
- ASIN
- ATAN
- COS
- COSEC
- COSH
- COTAN
- COTH
- DCOS
- DCOSEC
- DCOTAN
- DSEC
- DSIN
- DTAN
- SEC
- SECH
- SIN
- SINH
- TAN
- ACOSH
- ASINH
- ATAN2
- ATANH
- IMCOS
- IMSIN
- TANH
- CSCH
Other Functions
- ABC
- ABS
- ACCRINT
- ACOS
- ACOSH
- ADDRESS
- AMORDEGRC
- AMORLINC
- AND
- ANOVASINGLEFACTOR
- ANOVATWOFACTORWITHOUTREPLICATION
- ANOVATWOFACTORWITHREPLICATION
- AREAS
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- BERNOULLI
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOMDIST
- BINOMIAL
- calci_sum
- CEILING
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHINV
- CHITEST
- CHOOSE
- CIRCLE
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMPLEX
- CONCATENATE
- CONE
- CONFIDENCE
- CONVERT
- CORREL
- CORRELATION
- COS
- COSEC
- COSH
- COTAN
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- COVAR
- COVARIANCE
- CRITBINOM
- CYLINDER
- DATE
- date1
- datevalue
- DAVERAGE
- DAY
- DAYS360
- DAYSBETWEEN
- DCOS
- DCOSEC
- DCOTAN
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DEGREES
- DELTA
- DESCRIPTIVESTATISTICS
- DEVSQ
- DGET
- DISC
- DISCRETE
- DISTANCE
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DSEC
- DSIN
- DSTDEV
- DSTDEVP
- DSUM
- DTAN
- DURATION
- DVAR
- DVARP
- EDATE
- EFFECT
- ELLIPSE
- EOMONTH
- ERF
- ERFC
- EUROCONVERT
- EVEN
- EXACT
- EXP
- EXPONDIST
- EXPONENTIALSMOOTHING
- FACT
- FACTDOUBLE
- FDIST
- FIBONNACI
- FIND
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FORECAST
- FOURIERANALYSIS
- FREQUENCY
- FTEST
- FTESTANALYSIS
- GAMMADIST
- GAMMAINV
- GAMMALN
- GCD
- GEOMEAN
- GESTEP
- GOLDENANGLE
- GOLDENRATIO
- GROWTH
- HARMEAN
- help
- HEX2BIN
- HEX2DEC
- HEX2OCT
- HISTOGRAM
- HLOOKUP
- HOUR
- HYPERLINK
- HYPGEOMDIST
- HYPOTENUSE
- IF
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- INDEX
- INDIRECT
- INT
- INTERCEPT
- INTRATE
- IPMT
- IS FUNCTIONS
- ISBLANK
- ISEVEN
- ISLEAPYEAR
- ISLOGICAL
- ISNUMBER
- ISODD
- ISPMT
- ISPRIME
- ISTEXT
- ITHPRIME
- KURT
- LARGE
- LCM
- LEFT
- LEFTB
- LEN
- LENB
- LINEST
- LISTPRIMES
- LN
- LOG
- LOG10
- LOGEST
- LOGINV
- LOGNORMDIST
- LOOKUP
- LOWER
- LOWER1
- LUCAS
- MATCH
- MAX
- MAX1
- MAXA
- MAXA1
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIDB
- MIN
- MIN1
- MINA
- MINA1
- MINUTE
- MINVERSE
- MMULT
- MOD
- MODE
- MONTH
- MOVINGAVERAGE
- MROUND
- MULTINOMIAL
- N
- NEGBINOMDIS
- NEGBINOMDIST
- NETWORKDAYS
- NORMAL
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- OFFSET
- OR
- PASCALTRIANGLE
- PATTERNED
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- PI
- POINT
- poisson
- POISSONDISTRIBUTION
- POWER
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- QUARTILE
- QUOTIENT
- RADIANS
- RAND
- RANDBBETWEEN
- RANDBETWEEN
- RANDOMNUMBERGENERATION
- RANDOMNUMBERGENERATIONUNIFORM
- RANDOMUNIFORM
- RANK
- RANKANDPERCENTILE
- RATE
- RECEIVED
- REGRESSION
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- RSQ
- SAMPLING
- SEARCH
- SEARCHB
- SEC
- SECH
- SECOND
- SERIESSUM
- SIGN
- SIN
- SINH
- SKEW
- SLOPE
- SMALL
- SPHERE
- SQRT
- SQRTPI
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- SUBSTITUTE
- SUBTOTAL
- SUM
- sum1
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- T
- TAN
- TANH
- TDIST
- TIME
- TIMEVALUE
- TINV
- TRANSPOSE
- TREND
- TRIANGLE
- TRIM
- TRIMMEAN
- TRUNC
- TTEST
- TTESTEQUALVARIANCES
- TTESTPAIRED
- TTESTUNEQUALVARIANCES
- UNIFORM
- UPPER
- UPPER1
- VALUE
- VAR
- VARA
- VARP
- VARPA
- VECTOR
- VLOOKUP
- WEEKDAY
- WEEKNUM
- WEIBULL
- WORKDAY
- YEAR
- YEARFRAC
- ZTEST
- ZTESTEQUALMEANS