Difference between revisions of "Manuals/calci/ALL"

From ZCubes Wiki
Jump to navigation Jump to search
 
(28 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
==LIST OF ALL FUNCTIONS==
+
 
−
===Trignometric Functions===
+
==Array Specific Member Functions==
−
*[[Manuals/calci/ACOS | ACOS ]]
+
[[Z^3 Array Manipulation Member Functions|Array Member Functions]]
−
*[[Manuals/calci/ASIN |ASIN]]   
+
 
−
*[[Manuals/calci/ATAN | ATAN]]
+
==LIST OF SELECTED FUNCTIONS==
−
*[[Manuals/calci/COS | COS]]
+
===Statistical Functions===
−
*[[Manuals/calci/COSEC | COSEC]]
+
*[[Manuals/calci/AVEDEV | AVEDEV  ]]
−
*[[Manuals/calci/COSH | COSH]]
+
*[[Manuals/calci/AVERAGE | AVERAGE  ]]
−
*[[Manuals/calci/COTAN | COTAN]]
+
*[[Manuals/calci/AVERAGEA | AVERAGEA  ]]
−
*[[Manuals/calci/COTH | COTH]]
+
*[[Manuals/calci/Bartlett%27sTest | Bartlett's Test ]]
−
*[[Manuals/calci/DCOS | DCOS]]
+
*[[Manuals/calci/BERNOULLI | BERNOULLI  ]]
−
*[[Manuals/calci/DCOSEC | DCOSEC]]
+
*[[Manuals/calci/BETADIST | BETADIST  ]]
−
*[[Manuals/calci/DCOTAN | DCOTAN]]
+
*[[Manuals/calci/BETAINV | BETAINV  ]]
−
*[[Manuals/calci/DSEC | DSEC]]
+
*[[Manuals/calci/BINOMDIST | BINOMDIST  ]]
−
*[[Manuals/calci/DSIN | DSIN]]
+
*[[Manuals/calci/BINOMIAL | BINOMIAL  ]]
−
*[[Manuals/calci/DTAN | DTAN]]
+
*[[Manuals/calci/CHIDIST | CHIDIST  ]]
−
*[[Manuals/calci/SEC | SEC]]
+
*[[Manuals/calci/CHIINV | CHIINV  ]]
−
*[[Manuals/calci/SECH | SECH]]
+
*[[Manuals/calci/CHITEST | CHITEST  ]]
−
*[[Manuals/calci/SIN | SIN]]
+
*[[Manuals/calci/CONFIDENCE | CONFIDENCE  ]]
−
*[[Manuals/calci/SINH | SINH]]
+
*[[Manuals/calci/CORREL | CORREL  ]]
−
*[[Manuals/calci/TAN | TAN]]
+
*[[Manuals/calci/COUNT | COUNT  ]]
−
*[[Manuals/calci/ACOSH | ACOSH]]
+
*[[Manuals/calci/COUNTA | COUNTA  ]]
−
*[[Manuals/calci/ASINH | ASINH]]
+
*[[Manuals/calci/COUNTBLANK | COUNTBLANK  ]]
−
*[[Manuals/calci/ATAN2 | ATAN2]]
+
*[[Manuals/calci/COUNTIF | COUNTIF  ]]
−
*[[Manuals/calci/ATANH | ATANH]]
+
*[[Manuals/calci/COVAR | COVAR  ]]
−
*[[Manuals/calci/IMCOS | IMCOS]]
+
*[[Manuals/calci/COVARIANCE | COVARIANCE  ]]
−
*[[Manuals/calci/IMSIN | IMSIN]]
+
*[[Manuals/calci/CRITBINOM | CRITBINOM  ]]
−
*[[Manuals/calci/TANH | TANH]]
+
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS  ]]
−
*[[Manuals/calci/CSCH | CSCH]]
+
*[[Manuals/calci/DEVSQ | DEVSQ  ]]
 +
*[[Manuals/calci/DISCRETE | DISCRETE  ]]
 +
*[[Manuals/calci/EXPONDIST | EXPONDIST  ]]
 +
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING  ]]
 +
*[[Manuals/calci/FDIST | FDIST  ]]
 +
*[[Manuals/calci/FINV | FINV  ]]
 +
*[[Manuals/calci/FISHER | FISHER  ]]
 +
*[[Manuals/calci/FISHERINV | FISHERINV  ]]
 +
*[[Manuals/calci/FORECAST | FORECAST  ]]
 +
*[[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/GEOMEAN | GEOMEAN  ]]
 +
*[[Manuals/calci/GROWTH | GROWTH  ]]
 +
*[[Manuals/calci/HARMEAN | HARMEAN  ]]
 +
*[[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  ]]
 +
*[[Manuals/calci/NORMAL | NORMAL ]]
 +
*[[Manuals/calci/LEVENESTEST | LEVENESTEST ]]
 +
*[[Manuals/calci/MULTIPLEREGRESSIONANALYSIS | MULTIPLEREGRESSIONANALYSIS ]]
 +
*[[Manuals/calci/WILCOXONSIGNEDRANKTEST | WILCOXONSIGNEDRANKTEST ]]
 +
*[[Manuals/calci/MANNWHITNEYUTEST | MANNWHITNEYUTEST ]]
 +
*[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST ]]
 +
*[[Manuals/calci/SIGNTEST | SIGNTEST ]]
 +
*[[Manuals/calci/STATS | STATS ]]
 +
*[[Manuals/calci/BINOMIALPROBABILITY | BINOMIALPROBABILITY ]]
 +
*[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST ]]
 +
*[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST ]]
 +
*[[Manuals/calci/KSTESTNORMAL | KSTESTNORMAL ]]
 +
*[[Manuals/calci/RIEMANNZETA | RIEMANNZETA ]]
 +
 
 +
===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/HEX2DEC | HEX2DEC  ]]
 +
*[[Manuals/calci/HEX2OCT | HEX2OCT  ]]
 +
*[[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/IMPRODUCT | IMPRODUCT  ]]
 +
*[[Manuals/calci/IMREAL | IMREAL  ]]
 +
*[[Manuals/calci/IMSIN | IMSIN  ]]
 +
*[[Manuals/calci/IMSQRT | IMSQRT  ]]
 +
*[[Manuals/calci/IMSUB | IMSUB  ]]
 +
*[[Manuals/calci/IMSUM | IMSUM  ]]
 +
*[[Manuals/calci/OCT2BIN | OCT2BIN  ]]
 +
*[[Manuals/calci/OCT2DEC | OCT2DEC  ]]
 +
*[[Manuals/calci/OCT2HEX | OCT2HEX  ]]
 +
 
 +
===Financial===
 +
*[[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/LOGEST  | LOGEST  ]]
 +
*[[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/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 ]]
 +
 
 +
===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/ISBLANK | ISBLANK  ]]
 +
*[[Manuals/calci/ISEVEN | ISEVEN  ]]
 +
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR  ]]
 +
*[[Manuals/calci/ISLOGICAL | ISLOGICAL  ]]
 +
*[[Manuals/calci/ISNUMBER | ISNUMBER  ]]
 +
*[[Manuals/calci/ISODD | ISODD  ]]
 +
*[[Manuals/calci/ISPRIME | ISPRIME  ]]
 +
*[[Manuals/calci/ISTEXT | ISTEXT  ]]
 +
*[[Manuals/calci/N | N  ]]
 +
 
 +
===Logical===
 +
*[[Manuals/calci/AND | AND  ]]
 +
*[[Manuals/calci/IF | IF  ]]
 +
*[[Manuals/calci/OR | OR  ]]
 +
 
 +
===Lookup and Reference===
 +
*[[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/CSCH | CSCH  ]]
 +
*[[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/LCM | LCM  ]]
 +
*[[Manuals/calci/LISTPRIMES | LISTPRIMES  ]]
 +
*[[Manuals/calci/LN | LN  ]]
 +
*[[Manuals/calci/LOG | LOG  ]]
 +
*[[Manuals/calci/LOG10 | LOG10  ]]
 +
*[[Manuals/calci/LUCAS | LUCAS  ]]
 +
*[[Manuals/calci/MDETERM | MDETERM  ]]
 +
*[[Manuals/calci/MINVERSE | MINVERSE  ]]
 +
*[[Manuals/calci/MMULT | MMULT  ]]
 +
*[[Manuals/calci/MOD | MOD  ]]
 +
*[[Manuals/calci/MROUND | MROUND  ]]
 +
*[[Manuals/calci/MULTINOMIAL | MULTINOMIAL  ]]
 +
*[[Manuals/calci/ODD | ODD  ]]
 +
*[[Manuals/calci/PI | PI  ]]
 +
*[[Manuals/calci/POWER | POWER  ]]
 +
*[[Manuals/calci/PRODUCT | PRODUCT  ]]
 +
*[[Manuals/calci/QUOTIENT | QUOTIENT  ]]
 +
*[[Manuals/calci/RADIANS | RADIANS  ]]
 +
*[[Manuals/calci/RAND | RAND  ]]
 +
*[[Manuals/calci/RANDBETWEEN | RANDBETWEEN  ]]
 +
*[[Manuals/calci/ROMAN | ROMAN  ]]
 +
*[[Manuals/calci/ROUND | ROUND  ]]
 +
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN  ]]
 +
*[[Manuals/calci/ROUNDUP | ROUNDUP  ]]
 +
*[[Manuals/calci/SEC | SEC ]]
 +
*[[Manuals/calci/SECH | SECH ]]
 +
*[[Manuals/calci/SERIESSUM | SERIESSUM  ]]
 +
*[[Manuals/calci/SIGN | SIGN  ]]
 +
*[[Manuals/calci/SIN | SIN ]]
 +
*[[Manuals/calci/SINH | SINH ]]
 +
*[[Manuals/calci/SQRT | SQRT  ]]
 +
*[[Manuals/calci/SQRTPI | SQRTPI  ]]
 +
*[[Manuals/calci/SUBTOTAL | SUBTOTAL  ]]
 +
*[[Manuals/calci/SUM | SUM  ]]
 +
*[[Manuals/calci/SUMIF | SUMIF  ]]
 +
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT  ]]
 +
*[[Manuals/calci/SUMSQ | SUMSQ  ]]
 +
*[[Manuals/calci/SUMX2MY2 | SUMX2MY2  ]]
 +
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2  ]]
 +
*[[Manuals/calci/SUMXMY2 | SUMXMY2  ]]
 +
*[[Manuals/calci/TAN| TAN ]]
 +
*[[Manuals/calci/TANH | TANH  ]]
 +
*[[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/FINDB | FINDB  ]]
 +
*[[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/TRIM | TRIM  ]]
 +
*[[Manuals/calci/UPPER | UPPER  ]]
 +
*[[Manuals/calci/VALUE | VALUE  ]]
 +
 
 +
===Matrix Functions===
 +
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL  ]]
 +
*[[Manuals/calci/ANTISYMMETRIC | ANTISYMMETRIC  ]]
 +
*[[Manuals/calci/ARROWHEAD | ARROWHEAD  ]]
 +
*[[Manuals/calci/BIDIAGONAL | BIDIAGONAL  ]]
 +
*[[Manuals/calci/BLOCKDIAGONAL | BLOCKDIAGONAL  ]]
 +
*[[Manuals/calci/CENTROSYMMETRIC | CENTROSYMMETRIC  ]]
 +
*[[Manuals/calci/CHOLESKY | CHOLESKY  ]]
 +
*[[Manuals/calci/CIRCULANT | CIRCULANT  ]]
 +
*[[Manuals/calci/CONFERENCE | CONFERENCE  ]]
 +
*[[Manuals/calci/EXCHANGE | EXCHANGE  ]]
 +
*[[Manuals/calci/FROBENIUS | FROBENIUS  ]]
 +
*[[Manuals/calci/HADAMARD | HADAMARD  ]]
 +
*[[Manuals/calci/HANKEL | HANKEL  ]]
 +
*[[Manuals/calci/HERMITIAN | HERMITIAN  ]]
 +
*[[Manuals/calci/HESSENBERG | HESSENBERG  ]]
 +
*[[Manuals/calci/HILBERT | HILBERT  ]]
 +
*[[Manuals/calci/HOLLOW | HOLLOW  ]]
 +
*[[Manuals/calci/IDEMPOTENT | IDEMPOTENT  ]]
 +
*[[Manuals/calci/IDENTITY | IDENTITY  ]]
 +
*[[Manuals/calci/INTEGER | INTEGER  ]]
 +
*[[Manuals/calci/LEHMER | LEHMER  ]]
 +
*[[Manuals/calci/MATRIXOPERATORS | MATRIXOPERATORS  ]]
 +
*[[Manuals/calci/METZLER | METZLER  ]]
 +
*[[Manuals/calci/MONOMIAL | MONOMIAL  ]]
 +
*[[Manuals/calci/MOORE | MOORE  ]]
 +
*[[Manuals/calci/NEGZEROPOS | NEGZEROPOS  ]]
 +
*[[Manuals/calci/PASCAL | PASCAL  ]]
 +
*[[Manuals/calci/PENTADIAGONAL | PENTADIAGONAL  ]]
 +
*[[Manuals/calci/PERMUTATION | PERMUTATION  ]]
 +
*[[Manuals/calci/PERSYMMETRIC | PERSYMMETRIC  ]]
 +
*[[Manuals/calci/REDHEFFER | REDHEFFER  ]]
 +
*[[Manuals/calci/SHIFT | SHIFT  ]]
 +
*[[Manuals/calci/SIGNATURE | SIGNATURE  ]]
 +
*[[Manuals/calci/SYMMETRIC | SYMMETRIC  ]]
 +
*[[Manuals/calci/TOEPLITZ | TOEPLITZ  ]]
 +
*[[Manuals/calci/TRIANGULAR | TRIANGULAR  ]]
 +
*[[Manuals/calci/TRIDIAGONAL | TRIDIAGONAL  ]]
 +
*[[Manuals/calci/VANDERMONDE | VANDERMONDE  ]]
  
 
===Other Functions===
 
===Other Functions===
−
*[[Manuals/calci/ADDRESS |ADDRESS ]]
+
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR ]]
−
*[[Manuals/calci/AREAS |AREAS ]]
+
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION ]]
−
*[[Manuals/calci/BINOMDIST |BINOMDIST ]]
+
*[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION ]]
−
*[[Manuals/calci/CALCI_SUM |CALCI_SUM ]]
+
*[[Manuals/calci/RANDOMNUMBERGENERATION | RANDOMNUMBERGENERATION ]]
−
*[[Manuals/calci/CELL | CELL ]]
+
*[[Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM | RANDOMNUMBERGENERATIONUNIFORM ]]
−
*[[Manuals/calci/CHAR |CHAR ]]
+
*[[Manuals/calci/RANDOMUNIFORM | RANDOMUNIFORM ]]
−
*[[Manuals/calci/CHIDIST |CHIDIST ]]
+
*[[Manuals/calci/MAGICSQUARE | MAGICSQUARE ]]
−
*[[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/CONVERT |CONVERT ]]
 
−
*[[Manuals/calci/DATE |DATE ]]
 
−
*[[Manuals/calci/datevalue |datevalue ]]
 
−
*[[Manuals/calci/DAY |DAY ]]
 
−
*[[Manuals/calci/DAYS360 |DAYS360 ]]
 
−
*[[Manuals/calci/DAYSBETWEEN |DAYSBETWEEN]]
 
−
*[[Manuals/calci/DEGREES |DEGREES ]]
 
−
*[[Manuals/calci/AVERAGE |AVERAGE ]]
 
−
*
 
−
*[[Manuals/calci/AVEDEV | AVEDEV ]]
 
−
*[[Manuals/calci/DEVSQ | DEVSQ ]]
 
−
*[[Manuals/calci/ABS | ABS ]]
 
−
*[[Manuals/calci/EXP | EXP ]]
 
−
*[[Manuals/calci/IMABS | IMABS ]]
 
−
*[[Manuals/calci/CHITEST | CHITEST ]]
 
−
*[[Manuals/calci/IMAGINARY | IMAGINARY ]]
 
−
*[[Manuals/calci/IMCONJUGATE | IMCONJUGATE ]]
 
−
*[[Manuals/calci/IMDIV | IMDIV ]]
 
−
*[[Manuals/calci/IMEXP | IMEXP ]]
 
−
*[[Manuals/calci/LOG10 | LOG10 ]]
 
−
*[[Manuals/calci/MMULT | MMULT ]]
 
−
*[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST ]]
 
−
*[[Manuals/calci/CYLINDER | CYLINDER ]]
 
−
*[[Manuals/calci/BERNOULLI | BERNOULLI ]]
 
−
*[[Manuals/calci/CORRELATION | CORRELATION ]]
 
−
*
 
−
*[[Manuals/calci/EXPONDIST | EXPONDIST ]]
 
−
*[[Manuals/calci/AND | AND ]]
 
−
*[[Manuals/calci/BESSELI | BESSELI ]]
 
−
*[[Manuals/calci/BESSELJ | BESSELJ ]]
 
−
*[[Manuals/calci/BESSELK | BESSELK ]]
 
−
*[[Manuals/calci/BESSELY | BESSELY ]]
 
−
*
 
−
*[[Manuals/calci/AVERAGE |AVERAGE ]]
 
−
*[[Manuals/calci/COUNT |COUNT ]]
 
−
*[[Manuals/calci/COUNTA | COUNTA ]]
 
−
*[[Manuals/calci/COUNTBLANK |COUNTBLANK ]]
 
−
*[[Manuals/calci/COUNTIF |COUNTIF ]]
 
−
*[[Manuals/calci/DAVERAGE |DAVERAGE ]]
 
−
*[[Manuals/calci/DCOUNT |DCOUNT ]]
 
−
*[[Manuals/calci/DCOUNTA |DCOUNTA  ]]
 
−
*[[Manuals/calci/LCM |LCM  ]]
 
−
*
 
−
*[[Manuals/calci/BIN2DEC | BIN2DEC ]]
 
−
*[[Manuals/calci/BIN2HEX | BIN2HEX ]]
 
−
*[[Manuals/calci/BIN2OCT | BIN2OCT ]]
 
−
*[[Manuals/calci/DEC2BIN | DEC2BIN ]]
 
−
*[[Manuals/calci/DEC2HEX | DEC2HEX ]]
 
−
*[[Manuals/calci/DEC2OCT | DEC2OCT ]]
 
−
*[[Manuals/calci/DELTA | DELTA ]]
 
−
*[[Manuals/calci/DGET | DGET ]]
 
−
*[[Manuals/calci/DISTANCE | DISTANCE ]]
 
−
*[[Manuals/calci/DMAX | DMAX ]]
 
−
*[[Manuals/calci/DMIN | DMIN]]
 
−
*[[Manuals/calci/DPRODUCT | DPRODUCT ]]
 
−
*[[Manuals/calci/DSUM | DSUM ]]
 
−
*[[Manuals/calci/DURATION | DURATION]]
 
−
*[[Manuals/calci/EVEN | EVEN ]]
 
−
*[[Manuals/calci/FIXED | FIXED]]
 
−
*[[Manuals/calci/GCD | GCD ]]
 

Latest revision as of 09:19, 16 August 2024

Array Specific Member Functions

Array Member Functions

LIST OF SELECTED FUNCTIONS

Statistical Functions

Database and List Management

Date and Time

Engineering

Financial

Geometry

Information

Logical

Lookup and Reference

Math

Text and Data

Matrix Functions

Other Functions

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