Difference between revisions of "Manuals/calci/ALL"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
 
==LIST OF ALL FUNCTIONS==
 
==LIST OF ALL FUNCTIONS==
−
===Trignometric Functions===
+
===Statistical Functions===
−
*[[Manuals/calci/ACOS | ACOS ]]
 
−
*[[Manuals/calci/ASIN  |ASIN]] 
 
−
*[[Manuals/calci/ATAN | ATAN]]
 
−
*[[Manuals/calci/COS | COS]]
 
−
*[[Manuals/calci/COSEC | COSEC]]
 
−
*[[Manuals/calci/COSH | COSH]]
 
−
*[[Manuals/calci/COTAN | COTAN]]
 
−
*[[Manuals/calci/COTH | COTH]]
 
−
*[[Manuals/calci/DCOS | DCOS]]
 
−
*[[Manuals/calci/DCOSEC | DCOSEC]]
 
−
*[[Manuals/calci/DCOTAN | DCOTAN]]
 
−
*[[Manuals/calci/DSEC | DSEC]]
 
−
*[[Manuals/calci/DSIN | DSIN]]
 
−
*[[Manuals/calci/DTAN | DTAN]]
 
−
*[[Manuals/calci/SEC | SEC]]
 
−
*[[Manuals/calci/SECH | SECH]]
 
−
*[[Manuals/calci/SIN | SIN]]
 
−
*[[Manuals/calci/SINH | SINH]]
 
−
*[[Manuals/calci/TAN | TAN]]
 
−
*[[Manuals/calci/ACOSH | ACOSH]]
 
−
*[[Manuals/calci/ASINH | ASINH]]
 
−
*[[Manuals/calci/ATAN2 | ATAN2]]
 
−
*[[Manuals/calci/ATANH | ATANH]]
 
−
*[[Manuals/calci/IMCOS | IMCOS]]
 
−
*[[Manuals/calci/IMSIN | IMSIN]]
 
−
*[[Manuals/calci/TANH | TANH]]
 
−
*[[Manuals/calci/CSCH | CSCH]]
 
−
 
 
−
===Financial Functions===
 
−
*[[Manuals/calci/ACCRINT | ACCRINT ]]
 
−
*[[Manuals/calci/accrintm | accrintm ]]
 
−
*[[Manuals/calci/AMORDEGRC | AMORDEGRC ]]
 
−
*[[Manuals/calci/AMORLINC | AMORLINC ]]
 
−
*[[Manuals/calci/COUPDAYBS | COUPDAYBS ]]
 
−
*[[Manuals/calci/COUPDAYS | COUPDAYS ]]
 
−
*[[Manuals/calci/COUPDAYSNC | COUPDAYSNC ]]
 
−
*[[Manuals/calci/coupncd | coupncd ]]
 
−
*[[Manuals/calci/COUPNUM | COUPNUM ]]
 
−
*[[Manuals/calci/couppcd | couppcd ]]
 
−
*[[Manuals/calci/cumipmt | cumipmt ]]
 
−
*[[Manuals/calci/cumprinc | cumprinc ]]
 
−
*[[Manuals/calci/db | db ]]
 
−
*[[Manuals/calci/DDB | DDB ]]
 
−
*[[Manuals/calci/DISC | DISC ]]
 
−
*[[Manuals/calci/DOLLAR | DOLLAR ]]
 
−
*[[Manuals/calci/DOLLARDE | DOLLARDE ]]
 
−
*[[Manuals/calci/DOLLARFR | DOLLARFR ]]
 
−
*[[Manuals/calci/DURATION | DURATION ]]
 
−
*[[Manuals/calci/EFFECT | EFFECT ]]
 
−
*[[Manuals/calci/FV | FV ]]
 
−
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE ]]
 
−
*[[Manuals/calci/INTRATE | INTRATE ]]
 
−
*[[Manuals/calci/IPMT | IPMT ]]
 
−
*[[Manuals/calci/IRR | IRR ]]
 
−
*[[Manuals/calci/ISPMT | ISPMT ]]
 
−
*[[Manuals/calci/MDURATION | MDURATION ]]
 
−
*[[Manuals/calci/MIRR | MIRR ]]
 
−
*[[Manuals/calci/NOMINAL | NOMINAL ]]
 
−
*[[Manuals/calci/NPER | NPER ]]
 
−
*[[Manuals/calci/NPV | NPV ]]
 
−
*[[Manuals/calci/ODDFPRICE | ODDFPRICE ]]
 
−
*[[Manuals/calci/ODDFYIELD | ODDFYIELD ]]
 
−
*[[Manuals/calci/ODDLPRICE | ODDLPRICE ]]
 
−
*[[Manuals/calci/ODDLYIELD | ODDLYIELD ]]
 
−
*[[Manuals/calci/OFFSET | OFFSET ]]
 
−
*[[Manuals/calci/PMT | PMT ]]
 
−
*[[Manuals/calci/PPMT | PPMT ]]
 
−
*[[Manuals/calci/PRICE | PRICE ]]
 
−
*[[Manuals/calci/PRICEDISC | PRICEDISC ]]
 
−
*[[Manuals/calci/PRICEMAT | PRICEMAT ]]
 
−
*[[Manuals/calci/PV | PV ]]
 
−
*[[Manuals/calci/RATE | RATE ]]
 
−
*[[Manuals/calci/RECEIVED | RECEIVED ]]
 
−
*[[Manuals/calci/SLN | SLN ]]
 
−
*[[Manuals/calci/SYD | SYD ]]
 
−
*[[Manuals/calci/TBILLEQ | TBILLEQ ]]
 
−
*[[Manuals/calci/TBILLPRICE | TBILLPRICE ]]
 
−
*[[Manuals/calci/TBILLYIELD | TBILLYIELD ]]
 
−
*[[Manuals/calci/VDB | VDB ]]
 
−
*[[Manuals/calci/XIRR | XIRR ]]
 
−
*[[Manuals/calci/XNPV | XNPV ]]
 
−
*[[Manuals/calci/YIELD | YIELD ]]
 
−
*[[Manuals/calci/YIELDDISC | YIELDDISC ]]
 
−
*[[Manuals/calci/YIELDMAT | YIELDMAT ]]
 
−
 
 
−
===Other Functions===
 
−
*[[Manuals/calci/ABS | ABS  ]]
 
−
*[[Manuals/calci/ACCRINT | ACCRINT  ]]
 
−
*[[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/AVEDEV | AVEDEV  ]]
 
*[[Manuals/calci/AVEDEV | AVEDEV  ]]
 
*[[Manuals/calci/AVERAGE | AVERAGE  ]]
 
*[[Manuals/calci/AVERAGE | AVERAGE  ]]
 
*[[Manuals/calci/AVERAGEA | AVERAGEA  ]]
 
*[[Manuals/calci/AVERAGEA | AVERAGEA  ]]
 
*[[Manuals/calci/BERNOULLI | BERNOULLI  ]]
 
*[[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/BETADIST | BETADIST  ]]
 
*[[Manuals/calci/BETAINV | BETAINV  ]]
 
*[[Manuals/calci/BETAINV | BETAINV  ]]
−
*[[Manuals/calci/BIN2DEC | BIN2DEC  ]]
 
−
*[[Manuals/calci/BIN2HEX | BIN2HEX  ]]
 
−
*[[Manuals/calci/BIN2OCT | BIN2OCT  ]]
 
 
*[[Manuals/calci/BINOMDIST | BINOMDIST  ]]
 
*[[Manuals/calci/BINOMDIST | BINOMDIST  ]]
 
*[[Manuals/calci/BINOMIAL | BINOMIAL  ]]
 
*[[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/CHIDIST | CHIDIST  ]]
 
*[[Manuals/calci/CHIINV | CHIINV  ]]
 
*[[Manuals/calci/CHIINV | CHIINV  ]]
−
*[[Manuals/calci/CHINV | CHINV  ]]
 
 
*[[Manuals/calci/CHITEST | CHITEST  ]]
 
*[[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/CONFIDENCE | CONFIDENCE  ]]
−
*[[Manuals/calci/CONVERT | CONVERT  ]]
 
 
*[[Manuals/calci/CORREL | CORREL  ]]
 
*[[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/COUNT | COUNT  ]]
 
*[[Manuals/calci/COUNTA | COUNTA  ]]
 
*[[Manuals/calci/COUNTA | COUNTA  ]]
 
*[[Manuals/calci/COUNTBLANK | COUNTBLANK  ]]
 
*[[Manuals/calci/COUNTBLANK | COUNTBLANK  ]]
 
*[[Manuals/calci/COUNTIF | COUNTIF  ]]
 
*[[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/COVAR | COVAR  ]]
 
*[[Manuals/calci/COVARIANCE | COVARIANCE  ]]
 
*[[Manuals/calci/COVARIANCE | COVARIANCE  ]]
 
*[[Manuals/calci/CRITBINOM | CRITBINOM  ]]
 
*[[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/DCOUNT | DCOUNT  ]]
 
−
*[[Manuals/calci/DCOUNTA | DCOUNTA  ]]
 
−
*[[Manuals/calci/DDB | DDB  ]]
 
−
*[[Manuals/calci/DEC2BIN | DEC2BIN  ]]
 
−
*[[Manuals/calci/DEC2HEX | DEC2HEX  ]]
 
−
*[[Manuals/calci/DEC2OCT | DEC2OCT  ]]
 
−
*[[Manuals/calci/DEGREES | DEGREES  ]]
 
−
*[[Manuals/calci/DELTA | DELTA  ]]
 
 
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS  ]]
 
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS  ]]
 
*[[Manuals/calci/DEVSQ | DEVSQ  ]]
 
*[[Manuals/calci/DEVSQ | DEVSQ  ]]
−
*[[Manuals/calci/DGET | DGET  ]]
 
−
*[[Manuals/calci/DISC | DISC  ]]
 
 
*[[Manuals/calci/DISCRETE | DISCRETE  ]]
 
*[[Manuals/calci/DISCRETE | DISCRETE  ]]
−
*[[Manuals/calci/DISTANCE | DISTANCE  ]]
 
−
*[[Manuals/calci/DMAX | DMAX  ]]
 
−
*[[Manuals/calci/DMIN | DMIN  ]]
 
−
*[[Manuals/calci/DOLLAR | DOLLAR  ]]
 
−
*[[Manuals/calci/DOLLARDE | DOLLARDE  ]]
 
−
*[[Manuals/calci/DOLLARFR | DOLLARFR  ]]
 
−
*[[Manuals/calci/DPRODUCT | DPRODUCT  ]]
 
−
*[[Manuals/calci/DSTDEV | DSTDEV  ]]
 
−
*[[Manuals/calci/DSTDEVP | DSTDEVP  ]]
 
−
*[[Manuals/calci/DSUM | DSUM  ]]
 
−
*[[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/EXACT | EXACT  ]]
 
−
*[[Manuals/calci/EXP | EXP  ]]
 
 
*[[Manuals/calci/EXPONDIST | EXPONDIST  ]]
 
*[[Manuals/calci/EXPONDIST | EXPONDIST  ]]
 
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING  ]]
 
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING  ]]
−
*[[Manuals/calci/FACT | FACT  ]]
 
−
*[[Manuals/calci/FACTDOUBLE | FACTDOUBLE  ]]
 
 
*[[Manuals/calci/FDIST | FDIST  ]]
 
*[[Manuals/calci/FDIST | FDIST  ]]
−
*[[Manuals/calci/FIBONNACI | FIBONNACI  ]]
 
−
*[[Manuals/calci/FIND | FIND  ]]
 
 
*[[Manuals/calci/FINV | FINV  ]]
 
*[[Manuals/calci/FINV | FINV  ]]
 
*[[Manuals/calci/FISHER | FISHER  ]]
 
*[[Manuals/calci/FISHER | FISHER  ]]
 
*[[Manuals/calci/FISHERINV | FISHERINV  ]]
 
*[[Manuals/calci/FISHERINV | FISHERINV  ]]
−
*[[Manuals/calci/FIXED | FIXED  ]]
 
−
*[[Manuals/calci/FLOOR | FLOOR  ]]
 
 
*[[Manuals/calci/FORECAST | FORECAST  ]]
 
*[[Manuals/calci/FORECAST | FORECAST  ]]
−
*[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS  ]]
 
 
*[[Manuals/calci/FREQUENCY | FREQUENCY  ]]
 
*[[Manuals/calci/FREQUENCY | FREQUENCY  ]]
 
*[[Manuals/calci/FTEST | FTEST  ]]
 
*[[Manuals/calci/FTEST | FTEST  ]]
Line 214: Line 37:
 
*[[Manuals/calci/GAMMAINV | GAMMAINV  ]]
 
*[[Manuals/calci/GAMMAINV | GAMMAINV  ]]
 
*[[Manuals/calci/GAMMALN | GAMMALN  ]]
 
*[[Manuals/calci/GAMMALN | GAMMALN  ]]
−
*[[Manuals/calci/GCD | GCD  ]]
 
 
*[[Manuals/calci/GEOMEAN | GEOMEAN  ]]
 
*[[Manuals/calci/GEOMEAN | GEOMEAN  ]]
−
*[[Manuals/calci/GESTEP | GESTEP  ]]
 
−
*[[Manuals/calci/GOLDENANGLE | GOLDENANGLE  ]]
 
−
*[[Manuals/calci/GOLDENRATIO | GOLDENRATIO  ]]
 
 
*[[Manuals/calci/GROWTH | GROWTH  ]]
 
*[[Manuals/calci/GROWTH | GROWTH  ]]
 
*[[Manuals/calci/HARMEAN | HARMEAN  ]]
 
*[[Manuals/calci/HARMEAN | HARMEAN  ]]
−
*[[Manuals/calci/help | help ]]
+
*[[Manuals/calci/HISTOGRAM | HISTOGRAM  ]]
 +
*[[Manuals/calci/HYPGEOMDIST | HYPGEOMDIST  ]]
 +
*[[Manuals/calci/INTERCEPT | INTERCEPT  ]]
 +
*[[Manuals/calci/KURT | KURT  ]]
 +
*[[Manuals/calci/LARGE | LARGE  ]]
 +
*[[Manuals/calci/LINEST | LINEST  ]]
 +
*[[Manuals/calci/LOGINV | LOGINV  ]]
 +
*[[Manuals/calci/LOGNORMDIST | LOGNORMDIST  ]]
 +
*[[Manuals/calci/MAX | MAX  ]]
 +
*[[Manuals/calci/MAXA | MAXA  ]]
 +
*[[Manuals/calci/MEDIAN | MEDIAN  ]]
 +
*[[Manuals/calci/MIN | MIN  ]]
 +
*[[Manuals/calci/MINA | MINA  ]]
 +
*[[Manuals/calci/MODE | MODE  ]]
 +
*[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE  ]]
 +
*[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST  ]]
 +
*[[Manuals/calci/NORMDIST | NORMDIST  ]]
 +
*[[Manuals/calci/NORMINV | NORMINV  ]]
 +
*[[Manuals/calci/NORMSDIST | NORMSDIST  ]]
 +
*[[Manuals/calci/NORMSINV | NORMSINV  ]]
 +
*[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE  ]]
 +
*[[Manuals/calci/PATTERNED | PATTERNED  ]]
 +
*[[Manuals/calci/PEARSON | PEARSON  ]]
 +
*[[Manuals/calci/PERCENTILE | PERCENTILE  ]]
 +
*[[Manuals/calci/PERCENTRANK | PERCENTRANK  ]]
 +
*[[Manuals/calci/PERMUT | PERMUT  ]]
 +
*[[Manuals/calci/poisson | poisson  ]]
 +
*[[Manuals/calci/POISSONDISTRIBUTION | POISSONDISTRIBUTION  ]]
 +
*[[Manuals/calci/PROB | PROB  ]]
 +
*[[Manuals/calci/QUARTILE | QUARTILE  ]]
 +
*[[Manuals/calci/RANK | RANK  ]]
 +
*[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE  ]]
 +
*[[Manuals/calci/REGRESSION | REGRESSION  ]]
 +
*[[Manuals/calci/RSQ | RSQ  ]]
 +
*[[Manuals/calci/SAMPLING | SAMPLING  ]]
 +
*[[Manuals/calci/SKEW | SKEW  ]]
 +
*[[Manuals/calci/SLOPE | SLOPE  ]]
 +
*[[Manuals/calci/SMALL | SMALL  ]]
 +
*[[Manuals/calci/STANDARDIZE | STANDARDIZE  ]]
 +
*[[Manuals/calci/STDEV | STDEV  ]]
 +
*[[Manuals/calci/STDEVA | STDEVA  ]]
 +
*[[Manuals/calci/STDEVP | STDEVP  ]]
 +
*[[Manuals/calci/STDEVPA | STDEVPA  ]]
 +
*[[Manuals/calci/STEYX | STEYX  ]]
 +
*[[Manuals/calci/TDIST | TDIST  ]]
 +
*[[Manuals/calci/TINV | TINV  ]]
 +
*[[Manuals/calci/TREND | TREND  ]]
 +
*[[Manuals/calci/TRIMMEAN | TRIMMEAN  ]]
 +
*[[Manuals/calci/TTEST | TTEST  ]]
 +
*[[Manuals/calci/TTESTEQUALVARIANCES | TTESTEQUALVARIANCES  ]]
 +
*[[Manuals/calci/TTESTPAIRED | TTESTPAIRED  ]]
 +
*[[Manuals/calci/TTESTUNEQUALVARIANCES | TTESTUNEQUALVARIANCES  ]]
 +
*[[Manuals/calci/UNIFORM | UNIFORM  ]]
 +
*[[Manuals/calci/VAR | VAR  ]]
 +
*[[Manuals/calci/VARA | VARA  ]]
 +
*[[Manuals/calci/VARP | VARP  ]]
 +
*[[Manuals/calci/VARPA | VARPA  ]]
 +
*[[Manuals/calci/WEIBULL | WEIBULL  ]]
 +
*[[Manuals/calci/ZTEST | ZTEST  ]]
 +
*[[Manuals/calci/ZTESTEQUALMEANS | ZTESTEQUALMEANS  ]]
 +
 
 +
===Database and List Management===
 +
*[[Manuals/calci/DAVERAGE | DAVERAGE  ]]
 +
*[[Manuals/calci/DCOUNT | DCOUNT  ]]
 +
*[[Manuals/calci/DCOUNTA | DCOUNTA  ]]
 +
*[[Manuals/calci/DGET | DGET  ]]
 +
*[[Manuals/calci/DMAX | DMAX  ]]
 +
*[[Manuals/calci/DMIN | DMIN  ]]
 +
*[[Manuals/calci/DPRODUCT | DPRODUCT  ]]
 +
*[[Manuals/calci/DSTDEV | DSTDEV  ]]
 +
*[[Manuals/calci/DSTDEVP | DSTDEVP  ]]
 +
*[[Manuals/calci/DSUM | DSUM  ]]
 +
*[[Manuals/calci/DURATION | DURATION  ]]
 +
*[[Manuals/calci/DVAR | DVAR  ]]
 +
*[[Manuals/calci/DVARP | DVARP  ]]
 +
 
 +
===Date and Time===
 +
*[[Manuals/calci/DATE | DATE  ]]
 +
*[[Manuals/calci/datevalue | datevalue  ]]
 +
*[[Manuals/calci/DAY | DAY  ]]
 +
*[[Manuals/calci/DAYS360 | DAYS360  ]]
 +
*[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN  ]]
 +
*[[Manuals/calci/EDATE | EDATE  ]]
 +
*[[Manuals/calci/EOMONTH | EOMONTH  ]]
 +
*[[Manuals/calci/HOUR | HOUR  ]]
 +
*[[Manuals/calci/MINUTE | MINUTE  ]]
 +
*[[Manuals/calci/MONTH | MONTH  ]]
 +
*[[Manuals/calci/NETWORKDAYS | NETWORKDAYS  ]]
 +
*[[Manuals/calci/SECOND | SECOND  ]]
 +
*[[Manuals/calci/TIME | TIME  ]]
 +
*[[Manuals/calci/TIMEVALUE | TIMEVALUE  ]]
 +
*[[Manuals/calci/WEEKDAY | WEEKDAY  ]]
 +
*[[Manuals/calci/WEEKNUM | WEEKNUM  ]]
 +
*[[Manuals/calci/WORKDAY | WORKDAY  ]]
 +
*[[Manuals/calci/YEAR | YEAR  ]]
 +
*[[Manuals/calci/YEARFRAC | YEARFRAC  ]]
 +
 
 +
===Engineering===
 +
*[[Manuals/calci/BESSELI | BESSELI  ]]
 +
*[[Manuals/calci/BESSELJ | BESSELJ  ]]
 +
*[[Manuals/calci/BESSELK | BESSELK  ]]
 +
*[[Manuals/calci/BESSELY | BESSELY  ]]
 +
*[[Manuals/calci/BIN2DEC | BIN2DEC  ]]
 +
*[[Manuals/calci/BIN2HEX | BIN2HEX  ]]
 +
*[[Manuals/calci/BIN2OCT | BIN2OCT  ]]
 +
*[[Manuals/calci/COMPLEX | COMPLEX  ]]
 +
*[[Manuals/calci/CONVERT | CONVERT  ]]
 +
*[[Manuals/calci/DEC2BIN | DEC2BIN  ]]
 +
*[[Manuals/calci/DEC2HEX | DEC2HEX  ]]
 +
*[[Manuals/calci/DEC2OCT | DEC2OCT  ]]
 +
*[[Manuals/calci/DELTA | DELTA  ]]
 +
*[[Manuals/calci/ERF | ERF  ]]
 +
*[[Manuals/calci/ERFC | ERFC  ]]
 +
*[[Manuals/calci/GESTEP | GESTEP ]]
 
*[[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/HISTOGRAM | HISTOGRAM  ]]
 
−
*[[Manuals/calci/HLOOKUP | HLOOKUP  ]]
 
−
*[[Manuals/calci/HOUR | HOUR  ]]
 
−
*[[Manuals/calci/HYPERLINK | HYPERLINK  ]]
 
−
*[[Manuals/calci/HYPGEOMDIST | HYPGEOMDIST  ]]
 
−
*[[Manuals/calci/HYPOTENUSE | HYPOTENUSE  ]]
 
−
*[[Manuals/calci/IF | IF  ]]
 
 
*[[Manuals/calci/IMABS | IMABS  ]]
 
*[[Manuals/calci/IMABS | IMABS  ]]
 
*[[Manuals/calci/IMAGINARY | IMAGINARY  ]]
 
*[[Manuals/calci/IMAGINARY | IMAGINARY  ]]
Line 247: Line 172:
 
*[[Manuals/calci/IMSUB | IMSUB  ]]
 
*[[Manuals/calci/IMSUB | IMSUB  ]]
 
*[[Manuals/calci/IMSUM | IMSUM  ]]
 
*[[Manuals/calci/IMSUM | IMSUM  ]]
−
*[[Manuals/calci/INDEX | INDEX ]]
+
*[[Manuals/calci/OCT2BIN | OCT2BIN ]]
−
*[[Manuals/calci/INDIRECT | INDIRECT ]]
+
*[[Manuals/calci/OCT2DEC | OCT2DEC ]]
−
*[[Manuals/calci/INT | INT ]]
+
*[[Manuals/calci/OCT2HEX | OCT2HEX  ]]
−
*[[Manuals/calci/INTERCEPT | INTERCEPT ]]
+
 
 +
===Financial===
 +
*[[Manuals/calci/ACCRINT | ACCRINT  ]]
 +
*[[Manuals/calci/AMORDEGRC | AMORDEGRC  ]]
 +
*[[Manuals/calci/AMORLINC | AMORLINC  ]]
 +
*[[Manuals/calci/COUPDAYBS | COUPDAYBS  ]]
 +
*[[Manuals/calci/COUPDAYS | COUPDAYS  ]]
 +
*[[Manuals/calci/COUPDAYSNC | COUPDAYSNC  ]]
 +
*[[Manuals/calci/COUPNUM | COUPNUM  ]]
 +
*[[Manuals/calci/DDB | DDB  ]]
 +
*[[Manuals/calci/DISC | DISC  ]]
 +
*[[Manuals/calci/DOLLARDE | DOLLARDE  ]]
 +
*[[Manuals/calci/DOLLARFR | DOLLARFR ]]
 +
*[[Manuals/calci/EFFECT | EFFECT ]]
 
*[[Manuals/calci/INTRATE | INTRATE  ]]
 
*[[Manuals/calci/INTRATE | INTRATE  ]]
 
*[[Manuals/calci/IPMT | IPMT  ]]
 
*[[Manuals/calci/IPMT | IPMT  ]]
 +
*[[Manuals/calci/ISPMT | ISPMT  ]]
 +
*[[Manuals/calci/LOGEST | LOGEST  ]]
 +
*[[Manuals/calci/MDURATION | MDURATION  ]]
 +
*[[Manuals/calci/PRICE | PRICE  ]]
 +
*[[Manuals/calci/PRICEDISC | PRICEDISC  ]]
 +
*[[Manuals/calci/PRICEMAT | PRICEMAT  ]]
 +
*[[Manuals/calci/RATE | RATE  ]]
 +
*[[Manuals/calci/RECEIVED | RECEIVED  ]]
 +
 +
===Geometry===
 +
*[[Manuals/calci/CIRCLE | CIRCLE  ]]
 +
*[[Manuals/calci/CONE | CONE  ]]
 +
*[[Manuals/calci/CYLINDER | CYLINDER  ]]
 +
*[[Manuals/calci/DISTANCE | DISTANCE  ]]
 +
*[[Manuals/calci/ELLIPSE | ELLIPSE  ]]
 +
*[[Manuals/calci/HYPOTENUSE | HYPOTENUSE  ]]
 +
*[[Manuals/calci/POINT | POINT  ]]
 +
*[[Manuals/calci/SPHERE | SPHERE  ]]
 +
*[[Manuals/calci/TRIANGLE | TRIANGLE  ]]
 +
 +
===Information===
 +
*[[Manuals/calci/CELL | CELL  ]]
 +
*[[Manuals/calci/EUROCONVERT | EUROCONVERT  ]]
 +
*[[Manuals/calci/GOLDENANGLE | GOLDENANGLE  ]]
 +
*[[Manuals/calci/GOLDENRATIO | GOLDENRATIO  ]]
 +
*[[Manuals/calci/help | help  ]]
 
*[[Manuals/calci/IS FUNCTIONS | IS FUNCTIONS  ]]
 
*[[Manuals/calci/IS FUNCTIONS | IS FUNCTIONS  ]]
 
*[[Manuals/calci/ISBLANK | ISBLANK  ]]
 
*[[Manuals/calci/ISBLANK | ISBLANK  ]]
Line 260: Line 224:
 
*[[Manuals/calci/ISNUMBER | ISNUMBER  ]]
 
*[[Manuals/calci/ISNUMBER | ISNUMBER  ]]
 
*[[Manuals/calci/ISODD | ISODD  ]]
 
*[[Manuals/calci/ISODD | ISODD  ]]
−
*[[Manuals/calci/ISPMT | ISPMT  ]]
 
 
*[[Manuals/calci/ISPRIME | ISPRIME  ]]
 
*[[Manuals/calci/ISPRIME | ISPRIME  ]]
 
*[[Manuals/calci/ISTEXT | ISTEXT  ]]
 
*[[Manuals/calci/ISTEXT | ISTEXT  ]]
 +
*[[Manuals/calci/N | N  ]]
 +
 +
===Logical===
 +
*[[Manuals/calci/AND | AND  ]]
 +
*[[Manuals/calci/IF | IF  ]]
 +
*[[Manuals/calci/OR | OR  ]]
 +
 +
===Lookup and Refrence==
 +
*[[Manuals/calci/ADDRESS | ADDRESS  ]]
 +
*[[Manuals/calci/AREAS | AREAS  ]]
 +
*[[Manuals/calci/CHOOSE | CHOOSE  ]]
 +
*[[Manuals/calci/COLUMN | COLUMN  ]]
 +
*[[Manuals/calci/COLUMNS | COLUMNS  ]]
 +
*[[Manuals/calci/HLOOKUP | HLOOKUP  ]]
 +
*[[Manuals/calci/HYPERLINK | HYPERLINK  ]]
 +
*[[Manuals/calci/INDEX | INDEX  ]]
 +
*[[Manuals/calci/INDIRECT | INDIRECT  ]]
 +
*[[Manuals/calci/LOOKUP | LOOKUP  ]]
 +
*[[Manuals/calci/MATCH | MATCH  ]]
 +
*[[Manuals/calci/NOT | NOT  ]]
 +
*[[Manuals/calci/OFFSET | OFFSET  ]]
 +
*[[Manuals/calci/ROW | ROW  ]]
 +
*[[Manuals/calci/ROWS | ROWS  ]]
 +
*[[Manuals/calci/TRANSPOSE | TRANSPOSE  ]]
 +
*[[Manuals/calci/VLOOKUP | VLOOKUP  ]]
 +
 +
===Math===
 +
*[[Manuals/calci/ABS | ABS  ]]
 +
*[[Manuals/calci/calci_sum | calci_sum  ]]
 +
*[[Manuals/calci/CEILING | CEILING  ]]
 +
*[[Manuals/calci/COMBIN | COMBIN  ]]
 +
*[[Manuals/calci/COS | COS  ]]
 +
*[[Manuals/calci/COSEC | COSEC  ]]
 +
*[[Manuals/calci/COSH | COSH  ]]
 +
*[[Manuals/calci/COTAN | COTAN  ]]
 +
*[[Manuals/calci/COTH | COTH  ]]
 +
*[[Manuals/calci/DEGREES | DEGREES  ]]
 +
*[[Manuals/calci/EVEN | EVEN  ]]
 +
*[[Manuals/calci/EXP | EXP  ]]
 +
*[[Manuals/calci/FACT | FACT  ]]
 +
*[[Manuals/calci/FACTDOUBLE | FACTDOUBLE  ]]
 +
*[[Manuals/calci/FIBONNACI | FIBONNACI  ]]
 +
*[[Manuals/calci/FLOOR | FLOOR  ]]
 +
*[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS  ]]
 +
*[[Manuals/calci/GCD | GCD  ]]
 +
*[[Manuals/calci/INT | INT  ]]
 
*[[Manuals/calci/ITHPRIME | ITHPRIME  ]]
 
*[[Manuals/calci/ITHPRIME | ITHPRIME  ]]
−
*[[Manuals/calci/KURT | KURT  ]]
 
−
*[[Manuals/calci/LARGE | LARGE  ]]
 
 
*[[Manuals/calci/LCM | LCM  ]]
 
*[[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/LN | LN  ]]
 
*[[Manuals/calci/LOG | LOG  ]]
 
*[[Manuals/calci/LOG | LOG  ]]
 
*[[Manuals/calci/LOG10 | LOG10  ]]
 
*[[Manuals/calci/LOG10 | LOG10  ]]
−
*[[Manuals/calci/LOGEST | LOGEST  ]]
 
−
*[[Manuals/calci/LOGINV | LOGINV  ]]
 
−
*[[Manuals/calci/LOGNORMDIST | LOGNORMDIST  ]]
 
−
*[[Manuals/calci/LOOKUP | LOOKUP  ]]
 
−
*[[Manuals/calci/LOWER | LOWER  ]]
 
−
*[[Manuals/calci/LOWER1 | LOWER1  ]]
 
 
*[[Manuals/calci/LUCAS | LUCAS  ]]
 
*[[Manuals/calci/LUCAS | LUCAS  ]]
−
*[[Manuals/calci/MATCH | MATCH  ]]
 
−
*[[Manuals/calci/MAX | MAX  ]]
 
−
*[[Manuals/calci/MAX1 | MAX1  ]]
 
−
*[[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/MIN1 | MIN1  ]]
 
−
*[[Manuals/calci/MINA | MINA  ]]
 
−
*[[Manuals/calci/MINA1 | MINA1  ]]
 
−
*[[Manuals/calci/MINUTE | MINUTE  ]]
 
 
*[[Manuals/calci/MINVERSE | MINVERSE  ]]
 
*[[Manuals/calci/MINVERSE | MINVERSE  ]]
 
*[[Manuals/calci/MMULT | MMULT  ]]
 
*[[Manuals/calci/MMULT | MMULT  ]]
 
*[[Manuals/calci/MOD | MOD  ]]
 
*[[Manuals/calci/MOD | MOD  ]]
−
*[[Manuals/calci/MODE | MODE  ]]
 
−
*[[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/NEGBINOMDIS | NEGBINOMDIS  ]]
 
−
*[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST  ]]
 
−
*[[Manuals/calci/NETWORKDAYS | NETWORKDAYS  ]]
 
−
*[[Manuals/calci/NORMAL | NORMAL  ]]
 
−
*[[Manuals/calci/NORMDIST | NORMDIST  ]]
 
−
*[[Manuals/calci/NORMINV | NORMINV  ]]
 
−
*[[Manuals/calci/NORMSDIST | NORMSDIST  ]]
 
−
*[[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/ODD | ODD  ]]
−
*[[Manuals/calci/OFFSET | OFFSET  ]]
 
−
*[[Manuals/calci/OR | OR  ]]
 
−
*[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE  ]]
 
−
*[[Manuals/calci/PATTERNED | PATTERNED  ]]
 
−
*[[Manuals/calci/PEARSON | PEARSON  ]]
 
−
*[[Manuals/calci/PERCENTILE | PERCENTILE  ]]
 
−
*[[Manuals/calci/PERCENTRANK | PERCENTRANK  ]]
 
−
*[[Manuals/calci/PERMUT | PERMUT  ]]
 
 
*[[Manuals/calci/PI | PI  ]]
 
*[[Manuals/calci/PI | PI  ]]
−
*[[Manuals/calci/POINT | POINT  ]]
 
−
*[[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/PRODUCT | PRODUCT  ]]
 
*[[Manuals/calci/PRODUCT | PRODUCT  ]]
−
*[[Manuals/calci/PROPER | PROPER  ]]
 
−
*[[Manuals/calci/QUARTILE | QUARTILE  ]]
 
 
*[[Manuals/calci/QUOTIENT | QUOTIENT  ]]
 
*[[Manuals/calci/QUOTIENT | QUOTIENT  ]]
 
*[[Manuals/calci/RADIANS | RADIANS  ]]
 
*[[Manuals/calci/RADIANS | RADIANS  ]]
 
*[[Manuals/calci/RAND | RAND  ]]
 
*[[Manuals/calci/RAND | RAND  ]]
−
*[[Manuals/calci/RANDBBETWEEN | RANDBBETWEEN  ]]
 
 
*[[Manuals/calci/RANDBETWEEN | RANDBETWEEN  ]]
 
*[[Manuals/calci/RANDBETWEEN | RANDBETWEEN  ]]
−
*[[Manuals/calci/RANDOMNUMBERGENERATION | RANDOMNUMBERGENERATION  ]]
 
−
*[[Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM | RANDOMNUMBERGENERATIONUNIFORM  ]]
 
−
*[[Manuals/calci/RANDOMUNIFORM | RANDOMUNIFORM  ]]
 
−
*[[Manuals/calci/RANK | RANK  ]]
 
−
*[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE  ]]
 
−
*[[Manuals/calci/RATE | RATE  ]]
 
−
*[[Manuals/calci/RECEIVED | RECEIVED  ]]
 
−
*[[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/ROUND | ROUND  ]]
 
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN  ]]
 
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN  ]]
 
*[[Manuals/calci/ROUNDUP | ROUNDUP  ]]
 
*[[Manuals/calci/ROUNDUP | ROUNDUP  ]]
−
*[[Manuals/calci/ROW | ROW  ]]
 
−
*[[Manuals/calci/ROWS | ROWS  ]]
 
−
*[[Manuals/calci/RSQ | RSQ  ]]
 
−
*[[Manuals/calci/SAMPLING | SAMPLING  ]]
 
−
*[[Manuals/calci/SEARCH | SEARCH  ]]
 
−
*[[Manuals/calci/SEARCHB | SEARCHB  ]]
 
−
*[[Manuals/calci/SECOND | SECOND  ]]
 
 
*[[Manuals/calci/SERIESSUM | SERIESSUM  ]]
 
*[[Manuals/calci/SERIESSUM | SERIESSUM  ]]
 
*[[Manuals/calci/SIGN | SIGN  ]]
 
*[[Manuals/calci/SIGN | SIGN  ]]
−
*[[Manuals/calci/SKEW | SKEW  ]]
 
−
*[[Manuals/calci/SLOPE | SLOPE  ]]
 
−
*[[Manuals/calci/SMALL | SMALL  ]]
 
−
*[[Manuals/calci/SPHERE | SPHERE  ]]
 
 
*[[Manuals/calci/SQRT | SQRT  ]]
 
*[[Manuals/calci/SQRT | SQRT  ]]
 
*[[Manuals/calci/SQRTPI | SQRTPI  ]]
 
*[[Manuals/calci/SQRTPI | SQRTPI  ]]
−
*[[Manuals/calci/STANDARDIZE | STANDARDIZE  ]]
 
−
*[[Manuals/calci/STDEV | STDEV  ]]
 
−
*[[Manuals/calci/STDEVA | STDEVA  ]]
 
−
*[[Manuals/calci/STDEVP | STDEVP  ]]
 
−
*[[Manuals/calci/STDEVPA | STDEVPA  ]]
 
−
*[[Manuals/calci/STEYX | STEYX  ]]
 
−
*[[Manuals/calci/SUBSTITUTE | SUBSTITUTE  ]]
 
 
*[[Manuals/calci/SUBTOTAL | SUBTOTAL  ]]
 
*[[Manuals/calci/SUBTOTAL | SUBTOTAL  ]]
 
*[[Manuals/calci/SUM | SUM  ]]
 
*[[Manuals/calci/SUM | SUM  ]]
−
*[[Manuals/calci/sum1 | sum1  ]]
 
 
*[[Manuals/calci/SUMIF | SUMIF  ]]
 
*[[Manuals/calci/SUMIF | SUMIF  ]]
 
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT  ]]
 
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT  ]]
Line 393: Line 309:
 
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2  ]]
 
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2  ]]
 
*[[Manuals/calci/SUMXMY2 | SUMXMY2  ]]
 
*[[Manuals/calci/SUMXMY2 | SUMXMY2  ]]
 +
*[[Manuals/calci/TRUNC | TRUNC  ]]
 +
*[[Manuals/calci/VECTOR | VECTOR  ]]
 +
 +
===Text and Data===
 +
*[[Manuals/calci/CHAR | CHAR  ]]
 +
*[[Manuals/calci/CLEAN | CLEAN  ]]
 +
*[[Manuals/calci/CODE | CODE  ]]
 +
*[[Manuals/calci/CONCATENATE | CONCATENATE  ]]
 +
*[[Manuals/calci/DOLLAR | DOLLAR  ]]
 +
*[[Manuals/calci/EXACT | EXACT  ]]
 +
*[[Manuals/calci/FIND | FIND  ]]
 +
*[[Manuals/calci/FIXED | FIXED  ]]
 +
*[[Manuals/calci/LEFT | LEFT  ]]
 +
*[[Manuals/calci/LEFTB | LEFTB  ]]
 +
*[[Manuals/calci/LEN | LEN  ]]
 +
*[[Manuals/calci/LENB | LENB  ]]
 +
*[[Manuals/calci/LOWER | LOWER  ]]
 +
*[[Manuals/calci/MID | MID  ]]
 +
*[[Manuals/calci/MIDB | MIDB  ]]
 +
*[[Manuals/calci/PROPER | PROPER  ]]
 +
*[[Manuals/calci/REPLACE | REPLACE  ]]
 +
*[[Manuals/calci/REPLACEB | REPLACEB  ]]
 +
*[[Manuals/calci/REPT | REPT  ]]
 +
*[[Manuals/calci/RIGHT | RIGHT  ]]
 +
*[[Manuals/calci/RIGHTB | RIGHTB  ]]
 +
*[[Manuals/calci/SEARCH | SEARCH  ]]
 +
*[[Manuals/calci/SEARCHB | SEARCHB  ]]
 +
*[[Manuals/calci/SUBSTITUTE | SUBSTITUTE  ]]
 
*[[Manuals/calci/T | T  ]]
 
*[[Manuals/calci/T | T  ]]
−
*[[Manuals/calci/TDIST | TDIST  ]]
 
−
*[[Manuals/calci/TIME | TIME  ]]
 
−
*[[Manuals/calci/TIMEVALUE | TIMEVALUE  ]]
 
−
*[[Manuals/calci/TINV | TINV  ]]
 
−
*[[Manuals/calci/TRANSPOSE | TRANSPOSE  ]]
 
−
*[[Manuals/calci/TREND | TREND  ]]
 
−
*[[Manuals/calci/TRIANGLE | TRIANGLE  ]]
 
 
*[[Manuals/calci/TRIM | TRIM  ]]
 
*[[Manuals/calci/TRIM | TRIM  ]]
−
*[[Manuals/calci/TRIMMEAN | TRIMMEAN  ]]
 
−
*[[Manuals/calci/TRUNC | TRUNC  ]]
 
−
*[[Manuals/calci/TTEST | TTEST  ]]
 
−
*[[Manuals/calci/TTESTEQUALVARIANCES | TTESTEQUALVARIANCES  ]]
 
−
*[[Manuals/calci/TTESTPAIRED | TTESTPAIRED  ]]
 
−
*[[Manuals/calci/TTESTUNEQUALVARIANCES | TTESTUNEQUALVARIANCES  ]]
 
−
*[[Manuals/calci/UNIFORM | UNIFORM  ]]
 
 
*[[Manuals/calci/UPPER | UPPER  ]]
 
*[[Manuals/calci/UPPER | UPPER  ]]
−
*[[Manuals/calci/UPPER1 | UPPER1  ]]
 
 
*[[Manuals/calci/VALUE | VALUE  ]]
 
*[[Manuals/calci/VALUE | VALUE  ]]
−
*[[Manuals/calci/VAR | VAR  ]]
+
 
−
*[[Manuals/calci/VARA | VARA  ]]
+
===Other Functions===
−
*[[Manuals/calci/VARP | VARP  ]]
+
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR ]]
−
*[[Manuals/calci/VARPA | VARPA  ]]
+
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION ]]
−
*[[Manuals/calci/VECTOR | VECTOR  ]]
+
*[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION ]]
−
*[[Manuals/calci/VLOOKUP | VLOOKUP  ]]
+
*[[Manuals/calci/RANDOMNUMBERGENERATION | RANDOMNUMBERGENERATION ]]
−
*[[Manuals/calci/WEEKDAY | WEEKDAY  ]]
+
*[[Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM | RANDOMNUMBERGENERATIONUNIFORM ]]
−
*[[Manuals/calci/WEEKNUM | WEEKNUM  ]]
+
*[[Manuals/calci/RANDOMUNIFORM | RANDOMUNIFORM ]]
−
*[[Manuals/calci/WEIBULL | WEIBULL ]]
 
−
*[[Manuals/calci/WORKDAY | WORKDAY ]]
 
−
*[[Manuals/calci/YEAR | YEAR ]]
 
−
*[[Manuals/calci/YEARFRAC | YEARFRAC ]]
 
−
*[[Manuals/calci/ZTEST | ZTEST ]]
 
−
*[[Manuals/calci/ZTESTEQUALMEANS | ZTESTEQUALMEANS ]]
 

Revision as of 02:31, 20 March 2014

LIST OF ALL FUNCTIONS

Statistical Functions

Database and List Management

Date and Time

Engineering

Financial

Geometry

Information

Logical

=Lookup and Refrence

Math

Text and Data

Other Functions

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ALL&oldid=198242"