Difference between revisions of "Z API Functions"

From ZCubes Wiki
Jump to navigation Jump to search
 
(92 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
==Listing of Functions available in ZCubes Processing Space==
+
==LIST OF ALL FUNCTIONS==
−
 
+
===Statistical Functions1===
−
*[[ Z3 | << Z3 Home ]]
+
*[[Manuals/calci/Average, AverageA, AverageX Example| Example]]
−
*[[ Z%5E3_Language_Documentation | Z3 Language Documentation]]
+
*[[Manuals/calci/z3console| z3console]]
−
 
+
*[[Manuals/calci/Examples | Examples of Java and z3 programs]]
−
 
+
*[[Manuals/calci/Examples1 | Engineering Examples in z3]]
−
A partial listing of Functions available to interact with ZCubes is listed below.
+
*[[Manuals/calci/Exampleslp | Linear Programming in z3]]
−
 
 
−
 
 
−
*[[Manuals/calci/ABS | ABS]]
 
−
*[[Manuals/calci/ACCRINT | ACCRINT]]
 
−
*[[Manuals/calci/ACCRINTM | ACCRINTM]]
 
−
*[[Manuals/calci/ADD | ADD]]
 
−
*[[Manuals/calci/ADDRESS | ADDRESS]]
 
−
*[[Manuals/calci/AGE | AGE]]
 
−
*[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
 
−
*[[Manuals/calci/AMORLINC | AMORLINC]]
 
−
*[[Manuals/calci/AND | AND]]
 
−
*[[Manuals/calci/ANGLE | ANGLE]]
 
−
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR]]
 
−
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
 
−
*[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION]]
 
−
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL]]
 
−
*[[Manuals/calci/AREAS | AREAS]]
 
−
*[[Manuals/calci/ASC | ASC]]
 
−
*[[Manuals/calci/ASIN | ASIN]]
 
 
*[[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/BESSELI | BESSELI]]
+
*[[Manuals/calci/AVERAGEBOTTOM | AVERAGEBOTTOM]]
−
*[[Manuals/calci/BESSELJ | BESSELJ]]
+
*[[Manuals/calci/AVERAGEIF | AVERAGEIF]]
−
*[[Manuals/calci/BESSELK | BESSELK]]
+
*[[Manuals/calci/AVERAGEMIDDLE | AVERAGEMIDDLE]]
−
*[[Manuals/calci/BESSELY | BESSELY]]
+
*[[Manuals/calci/AVERAGETOP | AVERAGETOP]]
 +
*[[Manuals/calci/AVG | AVG]]
 
*[[Manuals/calci/BETA | BETA]]
 
*[[Manuals/calci/BETA | BETA]]
−
*[[Manuals/calci/BETADIST | BETADIST]]
 
−
*[[Manuals/calci/BETAINV | BETAINV]]
 
 
*[[Manuals/calci/BETWEEN | BETWEEN]]
 
*[[Manuals/calci/BETWEEN | BETWEEN]]
 +
*[[Manuals/calci/BETWEENCORE | BETWEENCORE]]
 
*[[Manuals/calci/BINOM | BINOM]]
 
*[[Manuals/calci/BINOM | BINOM]]
−
*[[Manuals/calci/BINOMDIST | BINOMDIST]]
 
 
*[[Manuals/calci/BINOMIAL | BINOMIAL]]
 
*[[Manuals/calci/BINOMIAL | BINOMIAL]]
−
*[[Manuals/calci/CAL | CAL]]
+
*[[Manuals/calci/BINOMIALCOEFFICIENT | BINOMIALCOEFFICIENT]]
−
*[[Manuals/calci/CALC | CALC]]
 
−
*[[Manuals/calci/CEILING | CEILING]]
 
−
*[[Manuals/calci/CELL | CELL]]
 
−
*[[Manuals/calci/CHAR | CHAR]]
 
−
*[[Manuals/calci/CHIDIST | CHIDIST]]
 
−
*[[Manuals/calci/CHIINV | CHIINV]]
 
−
*[[Manuals/calci/CHITEST | CHITEST]]
 
−
*[[Manuals/calci/CHOLESKY | CHOLESKY]]
 
−
*[[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/CONCAT | CONCAT]]
 
−
*[[Manuals/calci/CONCATENATE | CONCATENATE]]
 
 
*[[Manuals/calci/CONFIDENCE | CONFIDENCE]]
 
*[[Manuals/calci/CONFIDENCE | CONFIDENCE]]
−
*[[Manuals/calci/CONVERT | CONVERT]]
+
*[[Manuals/calci/COUNT | COUNT]]
−
*[[Manuals/calci/CORREL | CORREL]]
+
*[[Manuals/calci/COUNTA | COUNTA]]
−
*[[Manuals/calci/COS | COS]]
+
*[[Manuals/calci/COUNTBLANK | COUNTBLANK]]
−
*[[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/COUNTIF | COUNTIF]]
−
*[[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/COVAR | COVAR]]
 
*[[Manuals/calci/COVAR | COVAR]]
−
*[[Manuals/calci/CRITBINOM | CRITBINOM]]
+
*[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]]
−
*[[Manuals/calci/CUMIPMT | CUMIPMT]]
+
*[[Manuals/calci/DECREASING | DECREASING]]
−
*[[Manuals/calci/CUMPRINC | CUMPRINC]]
+
*[[Manuals/calci/DECREMENT | DECREMENT]]
−
*[[Manuals/calci/DATE | DATE]]
+
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]]
−
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
+
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]]
−
*[[Manuals/calci/DAVERAGE | DAVERAGE]]
+
*[[Manuals/calci/DET | DET]]
−
*[[Manuals/calci/DAY | DAY]]
+
*[[Manuals/calci/DEVSQ | DEVSQ]]
−
*[[Manuals/calci/DAYS | DAYS]]
+
*[[Manuals/calci/FEQ | FEQ]]
−
*[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN]]
+
*[[Manuals/calci/FINV | FINV]]
−
*[[Manuals/calci/DB | DB]]
+
*[[Manuals/calci/FISHER | FISHER]]
−
*[[Manuals/calci/DCOUNT | DCOUNT]]
+
*[[Manuals/calci/FISHERINV | FISHERINV]]
−
*[[Manuals/calci/DCOUNTA | DCOUNTA]]
+
*[[Manuals/calci/FLOYDSTRIANGLE | FLOYDSTRIANGLE]]
−
*[[Manuals/calci/DDB | DDB]]
+
*[[Manuals/calci/FREQUENCY | FREQUENCY]]
−
*[[Manuals/calci/DE | DE]]
+
*[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST]]
−
*[[Manuals/calci/DEG | DEG]]
+
*[[Manuals/calci/FTEST | FTEST]]
−
*[[Manuals/calci/DEGREES | DEGREES]]
+
*[[Manuals/calci/FTESTANALYSIS | FTESTANALYSIS]]
−
*[[Manuals/calci/DELTA | DELTA]]
+
*[[Manuals/calci/GAMMADIST | GAMMADIST]]
−
*[[Manuals/calci/DES | DES]]
+
*[[Manuals/calci/GAMMAFUNCTION | GAMMAFUNCTION]]
−
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]]
+
*[[Manuals/calci/GAMMAINV | GAMMAINV]]
−
*[[Manuals/calci/DET | DET]]
+
*[[Manuals/calci/GAMMALN | GAMMALN]]
−
*[[Manuals/calci/DEVSQ | DEVSQ]]
+
*[[Manuals/calci/GEOMEAN | GEOMEAN]]
−
*[[Manuals/calci/DGET | DGET]]
+
*[[Manuals/calci/HARMEAN | HARMEAN]]
−
*[[Manuals/calci/DIAG | DIAG]]
+
*[[Manuals/calci/HARMONICSERIES | HARMONICSERIES]]
−
*[[Manuals/calci/DIS | DIS]]
+
*[[Manuals/calci/HYPGEOM | HYPGEOM]]
−
*[[Manuals/calci/DISC | DISC]]
+
*[[Manuals/calci/HYPGEOMDIST | HYPGEOMDIST]]
−
*[[Manuals/calci/DISTANCE | DISTANCE]]
+
*[[Manuals/calci/KRONECKERPRODUCT | KRONECKERPRODUCT]]
−
*[[Manuals/calci/DMAX | DMAX]]
+
*[[Manuals/calci/KURT | KURT]]
−
*[[Manuals/calci/DMIN | DMIN]]
+
*[[Manuals/calci/LAMDASELF | LAMDASELF]]
−
*[[Manuals/calci/DOLLAR | DOLLAR]]
+
*[[Manuals/calci/LARGE | LARGE]]
−
*[[Manuals/calci/DOLLARDE | DOLLARDE]]
+
*[[Manuals/calci/LAST | LAST]]
−
*[[Manuals/calci/DOLLARFR | DOLLARFR]]
+
*[[Manuals/calci/LIST | LIST]]
−
*[[Manuals/calci/DPRODUCT | DPRODUCT]]
+
*[[Manuals/calci/LISTALL | LISTALL]]
−
*[[Manuals/calci/DSTDEV | DSTDEV]]
+
*[[Manuals/calci/LOGINV | LOGINV]]
−
*[[Manuals/calci/DSTDEVP | DSTDEVP]]
+
*[[Manuals/calci/MAX | MAX]]
−
*[[Manuals/calci/DSUM | DSUM]]
+
*[[Manuals/calci/MAXA | MAXA]]
−
*[[Manuals/calci/DURATION | DURATION]]
+
*[[Manuals/calci/MAXIF | MAXIF]]
−
*[[Manuals/calci/DVAR | DVAR]]
+
*[[Manuals/calci/MEAN | MEAN]]
−
*[[Manuals/calci/DVARP | DVARP]]
+
*[[Manuals/calci/MEDIAN | MEDIAN]]
−
*[[Manuals/calci/EB | EB]]
+
*[[Manuals/calci/MEDIANIF | MEDIANIF]]
−
*[[Manuals/calci/EDATE | EDATE]]
+
*[[Manuals/calci/MEQUAL | MEQUAL]]
−
*[[Manuals/calci/EFFECT | EFFECT]]
+
*[[Manuals/calci/MIN | MIN]]
−
*[[Manuals/calci/ELLIPSE | ELLIPSE]]
+
*[[Manuals/calci/MINA | MINA]]
−
*[[Manuals/calci/EOMONTH | EOMONTH]]
+
*[[Manuals/calci/MINIF | MINIF]]
−
*[[Manuals/calci/EQ | EQ]]
+
*[[Manuals/calci/MINMAX | MINMAX]]
−
*[[Manuals/calci/ERF | ERF]]
+
*[[Manuals/calci/MODE | MODE]]
−
*[[Manuals/calci/ERFC | ERFC]]
+
*[[Manuals/calci/MODEIF | MODEIF]]
−
*[[Manuals/calci/EURO | EURO]]
+
*[[Manuals/calci/MRSQ | MRSQ]]
−
*[[Manuals/calci/EUROCONVERT | EUROCONVERT]]
+
*[[Manuals/calci/NEGBINOM | NEGBINOM]]
−
*[[Manuals/calci/EVEN | EVEN]]
+
*[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST]]
−
*[[Manuals/calci/EXACT | EXACT]]
+
*[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE]]
−
*[[Manuals/calci/EXP | EXP]]
+
*[[Manuals/calci/PEARSON | PEARSON]]
−
*[[Manuals/calci/EXPONDIST | EXPONDIST]]
+
*[[Manuals/calci/PERCENT | PERCENT]]
−
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING]]
+
*[[Manuals/calci/PERCENTAGES | PERCENTAGES]]
−
*[[Manuals/calci/FACT | FACT]]
+
*[[Manuals/calci/PERCENTILE | PERCENTILE]]
−
*[[Manuals/calci/FACTDOUBLE | FACTDOUBLE]]
+
*[[Manuals/calci/PERCENTRANK | PERCENTRANK]]
−
*[[Manuals/calci/FD | FD]]
+
*[[Manuals/calci/PERFECTNUMBERS | PERFECTNUMBERS]]
−
*[[Manuals/calci/FDIST | FDIST]]
+
*[[Manuals/calci/PERMUT | PERMUT]]
−
*[[Manuals/calci/FIBONNACI | FIBONNACI]]
+
*[[Manuals/calci/PERMUTATIONS | PERMUTATIONS]]
−
*[[Manuals/calci/FIND | FIND]]
+
*[[Manuals/calci/PROB | PROB]]
−
*[[Manuals/calci/FINDB | FINDB]]
+
*[[Manuals/calci/QUARTILE | QUARTILE]]
−
*[[Manuals/calci/FINV | FINV]]
+
*[[Manuals/calci/QUATERNION | QUATERNION]]
−
*[[Manuals/calci/FISHER | FISHER]]
+
*[[Manuals/calci/RANK | RANK]]
−
*[[Manuals/calci/FISHERINV | FISHERINV]]
+
*[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE]]
−
*[[Manuals/calci/FIXED | FIXED]]
+
*[[Manuals/calci/RANKS | RANKS]]
−
*[[Manuals/calci/FLOOR | FLOOR]]
+
*[[Manuals/calci/RATIOS | RATIOS]]
−
*[[Manuals/calci/FOR | FOR]]
+
*[[Manuals/calci/RECIPROCAL | RECIPROCAL]]
−
*[[Manuals/calci/FORECAST | FORECAST]]
+
*[[Manuals/calci/RECIPROCALOF | RECIPROCALOF]]
−
*[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS]]
+
*[[Manuals/calci/RSQ | RSQ]]
−
*[[Manuals/calci/FREQUENCY | FREQUENCY]]
+
*[[Manuals/calci/SMALL | SMALL]]
−
*[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST]]
+
*[[Manuals/calci/SMALLLETTERS | SMALLLETTERS]]
−
*[[Manuals/calci/FTEST | FTEST]]
+
*[[Manuals/calci/STANDARDIZE | STANDARDIZE]]
−
*[[Manuals/calci/FTESTANALYSIS | FTESTANALYSIS]]
+
*[[Manuals/calci/STDEV | STDEV]]
−
*[[Manuals/calci/FUNC | FUNC]]
+
*[[Manuals/calci/STDEVA | STDEVA]]
−
*[[Manuals/calci/FUNCT | FUNCT]]
+
*[[Manuals/calci/STDEVIF | STDEVIF]]
−
*[[Manuals/calci/FV | FV]]
+
*[[Manuals/calci/STDEVP | STDEVP]]
−
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
+
*[[Manuals/calci/STDEVPA | STDEVPA]]
−
*[[Manuals/calci/GAMMADIST | GAMMADIST]]
+
*[[Manuals/calci/STDEVPIF | STDEVPIF]]
−
*[[Manuals/calci/GAMMAINV | GAMMAINV]]
+
*[[Manuals/calci/TDIST | TDIST]]
−
*[[Manuals/calci/GAMMALN | GAMMALN]]
+
*[[Manuals/calci/TINV | TINV]]
−
*[[Manuals/calci/GCD | GCD]]
+
*[[Manuals/calci/TOP | TOP]]
−
*[[Manuals/calci/GE | GE]]
+
*[[Manuals/calci/TOPN | TOPN]]
−
*[[Manuals/calci/GEOMEAN | GEOMEAN]]
+
*[[Manuals/calci/TOQUARTER | TOQUARTER]]
−
*[[Manuals/calci/GESTEP | GESTEP]]
+
*[[Manuals/calci/TRIM | TRIM]]
−
*[[Manuals/calci/GOLDENANGLE | GOLDENANGLE]]
+
*[[Manuals/calci/TRIMARRAY | TRIMARRAY]]
−
*[[Manuals/calci/GOLDENRATIO | GOLDENRATIO]]
+
*[[Manuals/calci/TRIMMEAN | TRIMMEAN]]
−
*[[Manuals/calci/GROWTH | GROWTH]]
+
*[[Manuals/calci/VAR | VAR]]
−
*[[Manuals/calci/HADAMARD | HADAMARD]]
+
*[[Manuals/calci/VARA | VARA]]
−
*[[Manuals/calci/HANKEL | HANKEL]]
+
*[[Manuals/calci/VARIF | VARIF]]
−
*[[Manuals/calci/HARMEAN | HARMEAN]]
+
*[[Manuals/calci/VARP | VARP]]
−
*[[Manuals/calci/HEX | HEX]]
+
*[[Manuals/calci/VARPA | VARPA]]
−
*[[Manuals/calci/HISTOGRAM | HISTOGRAM]]
+
*[[Manuals/calci/VARPIF | VARPIF]]
−
*[[Manuals/calci/HLOOKUP | HLOOKUP]]
+
*[[Manuals/calci/VARS | VARS]]
−
*[[Manuals/calci/HOUR | HOUR]]
+
*[[Manuals/calci/XBETWEEN | XBETWEEN]]
−
*[[Manuals/calci/HYPERLINK | HYPERLINK]]
+
 
−
*[[Manuals/calci/HYPGEOM | HYPGEOM]]
+
===Statistical Functions2===
−
*[[Manuals/calci/HYPGEOMDIST | HYPGEOMDIST]]
+
*[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]]
−
*[[Manuals/calci/HYPOTENUSE | HYPOTENUSE]]
+
*[[Manuals/calci/BETADIST | BETADIST]]
−
*[[Manuals/calci/IF | IF]]
+
*[[Manuals/calci/BETADISTX | BETADISTX]]
−
*[[Manuals/calci/IM | IM]]
+
*[[Manuals/calci/BETAFUNCTION | BETAFUNCTION]]
−
*[[Manuals/calci/IMABS | IMABS]]
+
*[[Manuals/calci/BETAINV | BETAINV]]
−
*[[Manuals/calci/IMAGINARY | IMAGINARY]]
+
*[[Manuals/calci/BINOMDIST | BINOMDIST]]
−
*[[Manuals/calci/IMARGUMENT | IMARGUMENT]]
+
*[[Manuals/calci/BINOMIALDISTRIBUTED | BINOMIALDISTRIBUTED]]
−
*[[Manuals/calci/IMCONJUGATE | IMCONJUGATE]]
+
*[[Manuals/calci/BINOMIALPROBABILTY | BINOMIALPROBABILTY]]
−
*[[Manuals/calci/IMCOS | IMCOS]]
+
*[[Manuals/calci/BINOMIALSERIES | BINOMIALSERIES]]
−
*[[Manuals/calci/IMDIV | IMDIV]]
+
*[[Manuals/calci/CHIDIST | CHIDIST]]
−
*[[Manuals/calci/IMEXP | IMEXP]]
+
*[[Manuals/calci/CHIINV | CHIINV]]
−
*[[Manuals/calci/IMLN | IMLN]]
+
*[[Manuals/calci/CHITEST | CHITEST]]
−
*[[Manuals/calci/IMLOG | IMLOG]]
+
*[[Manuals/calci/CORREL | CORREL]]
−
*[[Manuals/calci/IMPOWER | IMPOWER]]
+
*[[Manuals/calci/CORRELATIONDATAANALYSIS | CORRELATIONDATAANALYSIS]]
−
*[[Manuals/calci/IMPRODUCT | IMPRODUCT]]
+
*[[Manuals/calci/CRITBINOM | CRITBINOM]]
−
*[[Manuals/calci/IMREAL | IMREAL]]
+
*[[Manuals/calci/DISCRETEDISTRIBUTED | DISCRETEDISTRIBUTED]]  
−
*[[Manuals/calci/IMSIN | IMSIN]]
+
*[[Manuals/calci/EXPONDIST | EXPONDIST]]
−
*[[Manuals/calci/IMSQRT | IMSQRT]]
+
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING]]
−
*[[Manuals/calci/IMSUB | IMSUB]]
+
*[[Manuals/calci/FDIST | FDIST]]
−
*[[Manuals/calci/IMSUM | IMSUM]]
+
*[[Manuals/calci/FORECAST | FORECAST]]
−
*[[Manuals/calci/IN | IN]]
+
*[[Manuals/calci/GROWTH | GROWTH]]
−
*[[Manuals/calci/INDEX | INDEX]]
+
*[[Manuals/calci/HISTOGRAM | HISTOGRAM]]
−
*[[Manuals/calci/INDIRECT | INDIRECT]]
+
*[[Manuals/calci/KFUNCTION | KFUNCTION]]
−
*[[Manuals/calci/INT | INT]]
+
*[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST]]
−
*[[Manuals/calci/INTEG | INTEG]]
+
*[[Manuals/calci/KSTESTCORE | KSTESTCORE]]
−
*[[Manuals/calci/INTERCEPT | INTERCEPT]]
+
*[[Manuals/calci/KSTESTEXPONENTIAL | KSTESTEXPONENTIAL]]
−
*[[Manuals/calci/INTRATE | INTRATE]]
+
*[[Manuals/calci/KSTESTNORMAL | KSTESTNORMAL]]
−
*[[Manuals/calci/INVERSE | INVERSE]]
+
*[[Manuals/calci/LEVENESTEST | LEVENESTEST]]
−
*[[Manuals/calci/IPMT | IPMT]]
+
*[[Manuals/calci/LEVENESTESTOLD | LEVENESTESTOLD]]
−
*[[Manuals/calci/IRR | IRR]]
+
*[[Manuals/calci/LINEST | LINEST]]
−
*[[Manuals/calci/ISBLANK | ISBLANK]]
+
*[[Manuals/calci/LINKEDLIST | LINKEDLIST]]
−
*[[Manuals/calci/ISEVEN | ISEVEN]]
+
*[[Manuals/calci/LINKNODE | LINKNODE]]
−
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]]
+
*[[Manuals/calci/LISPLIST | LISPLIST]]
−
*[[Manuals/calci/ISLOGICAL | ISLOGICAL]]
+
*[[Manuals/calci/LOGNORMDIST | LOGNORMDIST]]
−
*[[Manuals/calci/ISNUMBER | ISNUMBER]]
+
*[[Manuals/calci/MANNWHITNEYUTEST | MANNWHITNEYUTEST]]
−
*[[Manuals/calci/ISODD | ISODD]]
+
*[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST]]
−
*[[Manuals/calci/ISPMT | ISPMT]]
+
*[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE]]
−
*[[Manuals/calci/ISPRIME | ISPRIME]]
+
*[[Manuals/calci/MPEARSON | MPEARSON]]
−
*[[Manuals/calci/ISTEXT | ISTEXT]]
+
*[[Manuals/calci/MULTIPLEREGRESSIONANALYSIS | MULTIPLEREGRESSIONANALYSIS]]
−
*[[Manuals/calci/ITHPRIME | ITHPRIME]]
+
*[[Manuals/calci/NORMALDISTRIBUTED | NORMALDISTRIBUTED]]
−
*[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST]]
+
*[[Manuals/calci/NORMDIST | NORMDIST]]
−
*[[Manuals/calci/KSTESTNORMAL | KSTESTNORMAL]]
+
*[[Manuals/calci/NORMINV | NORMINV]]
−
*[[Manuals/calci/KURT | KURT]]
+
*[[Manuals/calci/NORMSDIST | NORMSDIST]]
−
*[[Manuals/calci/LARGE | LARGE]]
+
*[[Manuals/calci/NORMSINV | NORMSINV]]
−
*[[Manuals/calci/LB | LB]]
+
*[[Manuals/calci/PATTERNDISTRIBUTED | PATTERNDISTRIBUTED]]
−
*[[Manuals/calci/LCM | LCM]]
+
*[[Manuals/calci/POISSON | POISSON]]
−
*[[Manuals/calci/LE | LE]]
+
*[[Manuals/calci/POISSONDISTRIBUTED | POISSONDISTRIBUTED]]
−
*[[Manuals/calci/LEFTB | LEFTB]]
+
*[[Manuals/calci/REGRESSIONANALYSIS | REGRESSIONANALYSIS]]
−
*[[Manuals/calci/LEN | LEN]]
+
*[[Manuals/calci/REPEAT | REPEAT]]
−
*[[Manuals/calci/LENB | LENB]]
+
*[[Manuals/calci/SAMPLING | SAMPLING]]
−
*[[Manuals/calci/LEVENESTEST | LEVENESTEST]]
+
*[[Manuals/calci/SIGNTEST | SIGNTEST]]
−
*[[Manuals/calci/LINE | LINE]]
+
*[[Manuals/calci/SKEW | SKEW]]
−
*[[Manuals/calci/LINEST | LINEST]]
+
*[[Manuals/calci/STATIC | STATIC]]
−
*[[Manuals/calci/LIST | LIST]]
+
*[[Manuals/calci/STATS | STATS]]
−
*[[Manuals/calci/LISTPRIMES | LISTPRIMES]]
+
*[[Manuals/calci/STEYX | STEYX]]
−
*[[Manuals/calci/LN | LN]]
+
*[[Manuals/calci/TREND | TREND]]
−
*[[Manuals/calci/LOG | LOG]]
+
*[[Manuals/calci/TTEST | TTEST]]
−
*[[Manuals/calci/LOGEST | LOGEST]]
+
*[[Manuals/calci/TTESTPAIRED | TTESTPAIRED]]
−
*[[Manuals/calci/LOGINV | LOGINV]]
+
*[[Manuals/calci/TTESTTWOSAMPLESEQUALVARIANCES | TTESTTWOSAMPLESEQUALVARIANCES]]
−
*[[Manuals/calci/LOGNORMDIST | LOGNORMDIST]]
+
*[[Manuals/calci/TTESTTWOSAMPLESUNEQUALVARIANCES | TTESTTWOSAMPLESUNEQUALVARIANCES]]
−
*[[Manuals/calci/LOOKUP | LOOKUP]]
+
*[[Manuals/calci/UNIFORMDISTRIBUTED | UNIFORMDISTRIBUTED]]
−
*[[Manuals/calci/LOWER | LOWER]]
+
*[[Manuals/calci/WEIBULL | WEIBULL]]
−
*[[Manuals/calci/LT | LT]]
+
*[[Manuals/calci/WILCOXONSIGNEDRANKTEST | WILCOXONSIGNEDRANKTEST]]
−
*[[Manuals/calci/LUCAS | LUCAS]]
+
*[[Manuals/calci/ZTEST | ZTEST]]
−
*[[Manuals/calci/MAGICSQUARE | MAGICSQUARE]]
+
*[[Manuals/calci/ZTESTTWOSAMPLEFORMEANS | ZTESTTWOSAMPLEFORMEANS]]
−
*[[Manuals/calci/MANNWHITNEYUTEST | MANNWHITNEYUTEST]]
+
 
−
*[[Manuals/calci/MATCH | MATCH]]
+
===Math1===
−
*[[Manuals/calci/MATRIX | MATRIX]]
+
*[[Manuals/calci/ABS | ABS]]
−
*[[Manuals/calci/MAX | MAX]]
+
*[[Manuals/calci/ACOS | ACOS]]
−
*[[Manuals/calci/MAXA | MAXA]]
+
*[[Manuals/calci/ACOSH | ACOSH]]
−
*[[Manuals/calci/MDETERM | MDETERM]]
+
*[[Manuals/calci/ADD | ADD]]
−
*[[Manuals/calci/MDURATION | MDURATION]]
+
*[[Manuals/calci/ADDBY | ADDBY]]
−
*[[Manuals/calci/MEAN | MEAN]]
+
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]]
−
*[[Manuals/calci/MEDIAN | MEDIAN]]
+
*[[Manuals/calci/ADDFACT | ADDFACT]]
−
*[[Manuals/calci/MID | MID]]
+
*[[Manuals/calci/ADDWITH | ADDWITH]]
−
*[[Manuals/calci/MIDB | MIDB]]
+
*[[Manuals/calci/ANGLE | ANGLE]]
−
*[[Manuals/calci/MIN | MIN]]
+
*[[Manuals/calci/ANGLEAT | ANGLEAT]]
−
*[[Manuals/calci/MINA | MINA]]
+
*[[Manuals/calci/ANGLES | ANGLES]]
−
*[[Manuals/calci/MINUTE | MINUTE]]
+
*[[Manuals/calci/ANGLESLIST | ANGLESLIST]]
−
*[[Manuals/calci/MINVERSE | MINVERSE]]
+
*[[Manuals/calci/ANTILOG | ANTILOG]]
−
*[[Manuals/calci/MIRR | MIRR]]
+
*[[Manuals/calci/ARITHMETICSERIES |ARITHMETICSERIES]]
−
*[[Manuals/calci/MMULT | MMULT]]
+
*[[Manuals/calci/ASCENDING | ASCENDING]]
−
*[[Manuals/calci/MOD | MOD]]
+
*[[Manuals/calci/ASIN | ASIN]]
−
*[[Manuals/calci/MODE | MODE]]
+
*[[Manuals/calci/ASINH | ASINH]]
−
*[[Manuals/calci/MONTH | MONTH]]
+
*[[Manuals/calci/ATAN | ATAN]]
−
*[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST]]
+
*[[Manuals/calci/ATANH | ATANH]]
−
*[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE]]
+
*[[Manuals/calci/BASETHETA | BASETHETA]]
−
*[[Manuals/calci/MROUND | MROUND]]
+
*[[Manuals/calci/CAL | CAL]]
−
*[[Manuals/calci/MULTINOMIAL | MULTINOMIAL]]
+
*[[Manuals/calci/CALC | CALC]]
−
*[[Manuals/calci/MULTIPLEREGRESSIONANALYSIS | MULTIPLEREGRESSIONANALYSIS]]
+
*[[Manuals/calci/CALCULATE | CALCULATE]]
−
*[[Manuals/calci/NA | NA]]
+
*[[Manuals/calci/CAR | CAR]]
−
*[[Manuals/calci/NE | NE]]
+
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]]
−
*[[Manuals/calci/NEG | NEG]]
+
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]]
−
*[[Manuals/calci/NEGBINOM | NEGBINOM]]
+
*[[Manuals/calci/CAR | CDR]]
−
*[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST]]
+
*[[Manuals/calci/CEILING | CEILING]]
−
*[[Manuals/calci/NES | NES]]
+
*[[Manuals/calci/CEILINGAT | CEILINGAT]]
−
*[[Manuals/calci/NEST | NEST]]
+
*[[Manuals/calci/CIS | CIS]]
−
*[[Manuals/calci/NETWORKDAYS | NETWORKDAYS]]
+
*[[Manuals/calci/COMBIN | COMBIN]]
−
*[[Manuals/calci/NO | NO]]
+
*[[Manuals/calci/COMBINATIONS | COMBINATIONS]]
−
*[[Manuals/calci/NOMINAL | NOMINAL]]
+
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]]
−
*[[Manuals/calci/NORMDIST | NORMDIST]]
+
*[[Manuals/calci/COS | COS]]
−
*[[Manuals/calci/NORMINV | NORMINV]]
+
*[[Manuals/calci/COS#Examples | COSExamples]]
−
*[[Manuals/calci/NORMSDIST | NORMSDIST]]
+
*[[Manuals/calci/COSEC | COSEC]]
−
*[[Manuals/calci/NORMSINV | NORMSINV]]
+
*[[Manuals/calci/COSH | COSH]]
−
*[[Manuals/calci/NOT | NOT]]
+
*[[Manuals/calci/COTAN | COTAN]]
−
*[[Manuals/calci/NPER | NPER]]
+
*[[Manuals/calci/COTH | COTH]]
−
*[[Manuals/calci/NPV | NPV]]
+
*[[Manuals/calci/CROSSPRODUCT | CROSSPRODUCT]]
−
*[[Manuals/calci/NTH | NTH]]
+
*[[Manuals/calci/CSCH | CSCH]]
−
*[[Manuals/calci/NUM | NUM]]
+
*[[Manuals/calci/CUBEROOT | CUBEROOT]]
−
*[[Manuals/calci/NUMBER | NUMBER]]
+
*[[Manuals/calci/CUBES | CUBES]]
−
*[[Manuals/calci/ODD | ODD]]
+
*[[Manuals/calci/CYCLEWITHIN | CYCLEWITHIN]]
−
*[[Manuals/calci/ODDFPRICE | ODDFPRICE]]
+
*[[Manuals/calci/DCOS | DCOS]]
−
*[[Manuals/calci/ODDFYIELD | ODDFYIELD]]
+
*[[Manuals/calci/DCOSEC | DCOSEC]]
−
*[[Manuals/calci/ODDLPRICE | ODDLPRICE]]
+
*[[Manuals/calci/DCOTAN | DCOTAN]]
−
*[[Manuals/calci/ODDLYIELD | ODDLYIELD]]
+
*[[Manuals/calci/DECIMAL | DECIMAL]]
−
*[[Manuals/calci/OFF | OFF]]
+
*[[Manuals/calci/DECIMALPART | DECIMALPART]]
−
*[[Manuals/calci/OFFSET | OFFSET]]
+
*[[Manuals/calci/DEG | DEG]]
−
*[[Manuals/calci/OK | OK]]
+
*[[Manuals/calci/DEGREES | DEGREES]]
−
*[[Manuals/calci/ON | ON]]
+
*[[Manuals/calci/DEGREESLIST | DEGREESLIST]]
−
*[[Manuals/calci/ONE | ONE]]
+
*[[Manuals/calci/DESCENDING | DESCENDING]]
−
*[[Manuals/calci/OR | OR]]
+
*[[Manuals/calci/DIFFERENCE | DIFFERENCE]]
−
*[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE]]
+
*[[Manuals/calci/DIGITS | DIGITS]]
−
*[[Manuals/calci/PEARSON | PEARSON]]
+
*[[Manuals/calci/DISTINCT | DISTINCT]]
−
*[[Manuals/calci/PERCENT | PERCENT]]
+
*[[Manuals/calci/DISTINCTSET | DISTINCTSET]]
−
*[[Manuals/calci/PERCENTILE | PERCENTILE]]
+
*[[Manuals/calci/DIVIDE | DIVIDE]]
−
*[[Manuals/calci/PERCENTRANK | PERCENTRANK]]
+
*[[Manuals/calci/DIVIDEBY | DIVIDEBY]]
−
*[[Manuals/calci/PERMUT | PERMUT]]
+
*[[Manuals/calci/DIVIDEWITH | DIVIDEWITH]]
−
*[[Manuals/calci/PMT | PMT]]
+
*[[Manuals/calci/DIVISION | DIVISION]]
−
*[[Manuals/calci/POINT | POINT]]
+
*[[Manuals/calci/DIVISIONOF | DIVISIONOF]]
−
*[[Manuals/calci/POISSON | POISSON]]
+
*[[Manuals/calci/DIVPARTS | DIVPARTS]]
−
*[[Manuals/calci/POWER | POWER]]
+
*[[Manuals/calci/DOTPRODUCT | DOTPRODUCT]]
−
*[[Manuals/calci/PPMT | PPMT]]
+
*[[Manuals/calci/DSEC | DSEC]]
−
*[[Manuals/calci/PRICE | PRICE]]
+
*[[Manuals/calci/DSIN | DSIN]]
−
*[[Manuals/calci/PRICEDISC | PRICEDISC]]
+
*[[Manuals/calci/DTAN | DTAN]]
−
*[[Manuals/calci/PRICEMAT | PRICEMAT]]
+
*[[Manuals/calci/DYADIC | DYADIC]]
−
*[[Manuals/calci/PRIMES | PRIMES]]
+
*[[Manuals/calci/ELEMENTAT | ELEMENTAT]]
−
*[[Manuals/calci/PROB | PROB]]
+
*[[Manuals/calci/ELEMENTDIS | ELEMENTDIS]]
−
*[[Manuals/calci/PRODUCT | PRODUCT]]
+
*[[Manuals/calci/ELEMENTINARRAY | ELEMENTINARRAY]]
−
*[[Manuals/calci/PROPER | PROPER]]
+
*[[Manuals/calci/EQ | EQ]]
−
*[[Manuals/calci/PV | PV]]
+
*[[Manuals/calci/EQS | EQS]]
−
*[[Manuals/calci/QUARTILE | QUARTILE]]
+
*[[Manuals/calci/EQUATION | EQUATION]]
−
*[[Manuals/calci/QUOTIENT | QUOTIENT]]
+
*[[Manuals/calci/EVEN | EVEN]]
−
*[[Manuals/calci/RAD | RAD]]
+
*[[Manuals/calci/EVENS | EVENS]]
−
*[[Manuals/calci/RADIANS | RADIANS]]
+
*[[Manuals/calci/EVENSET | EVENSET]]
−
*[[Manuals/calci/RAND | RAND]]
+
*[[Manuals/calci/EVENSUPTO | EVENSUPTO]]
−
*[[Manuals/calci/RANDBETWEEN | RANDBETWEEN]]
+
*[[Manuals/calci/EVERYSET | EVERYSET]]
−
*[[Manuals/calci/RANDOM | RANDOM]]
+
*[[Manuals/calci/EXP | EXP]]
−
*[[Manuals/calci/RANDOMNUMBERGENERATION | RANDOMNUMBERGENERATION]]
+
*[[Manuals/calci/EXPOF | EXPOF]]
−
*[[Manuals/calci/RANK | RANK]]
+
*[[Manuals/calci/FACT | FACT]]
−
*[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE]]
+
*[[Manuals/calci/FACTDOUBLE | FACTDOUBLE]]
−
*[[Manuals/calci/RATE | RATE]]
+
*[[Manuals/calci/FACTORIAL | FACTORIAL]]
−
*[[Manuals/calci/RECEIVED | RECEIVED]]
+
*[[Manuals/calci/FACTS | FACTS]]
−
*[[Manuals/calci/REGRESSIONANALYSIS | REGRESSIONANALYSIS]]
+
*[[Manuals/calci/FACTUNTIL | FACTUNTIL]]
−
*[[Manuals/calci/REPLACE | REPLACE]]
+
*[[Manuals/calci/FIBONACCI | FIBONACCI]]
−
*[[Manuals/calci/REPLACEB | REPLACEB]]
+
*[[Manuals/calci/FIBONNACI | FIBONNACI]]
−
*[[Manuals/calci/REPT | REPT]]
+
*[[Manuals/calci/FIFTHOF | FIFTHOF]]
−
*[[Manuals/calci/RIGHTB | RIGHTB]]
+
*[[Manuals/calci/FLOOR | FLOOR]]
−
*[[Manuals/calci/ROMAN | ROMAN]]
+
*[[Manuals/calci/FLOORAT | FLOORAT]]
−
*[[Manuals/calci/ROUND | ROUND]]
+
*[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS]]
−
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]]
+
*[[Manuals/calci/FOURTHOF | FOURTHOF]]
−
*[[Manuals/calci/ROUNDUP | ROUNDUP]]
+
*[[Manuals/calci/FOURTHROOT | FOURTHROOT]]
−
*[[Manuals/calci/ROW | ROW]]
+
*[[Manuals/calci/FRACTION | FRACTION]]
−
*[[Manuals/calci/ROWS | ROWS]]
+
*[[Manuals/calci/GCD | GCD]]
−
*[[Manuals/calci/RSQ | RSQ]]
+
*[[Manuals/calci/GCV | GCV]]
−
*[[Manuals/calci/SAMPLING | SAMPLING]]
+
*[[Manuals/calci/GE | GE]]
−
*[[Manuals/calci/SEARCH | SEARCH]]
+
*[[Manuals/calci/GEOMETRICSERIES | GEOMETRICSERIES]]
−
*[[Manuals/calci/SEARCHB | SEARCHB]]
+
*[[Manuals/calci/GOLDENANGLE | GOLDENANGLE]]
−
*[[Manuals/calci/SEC | SEC]]
+
*[[Manuals/calci/GOLDENRATIO | GOLDENRATIO]]
−
*[[Manuals/calci/SECOND | SECOND]]
+
*[[Manuals/calci/GREEK | GREEK]]
−
*[[Manuals/calci/SERIES | SERIES]]
+
*[[Manuals/calci/GREEKARRAY | GREEKARRAY]]
−
*[[Manuals/calci/SERIESSUM | SERIESSUM]]
+
*[[Manuals/calci/GREEKS | GREEKS]]
−
*[[Manuals/calci/SET | SET]]
+
*[[Manuals/calci/GT | GT]]
−
*[[Manuals/calci/SIGN | SIGN]]
+
*[[Manuals/calci/GTE | GTE]]
−
*[[Manuals/calci/SIGNTEST | SIGNTEST]]
+
*[[Manuals/calci/HALFOF | HALFOF]]
−
*[[Manuals/calci/SIN | SIN]]
+
*[[Manuals/calci/HUNDRED | HUNDRED]]
−
*[[Manuals/calci/SKEW | SKEW]]
+
*[[Manuals/calci/INCREASING | INCREASING]]
−
*[[Manuals/calci/SLN | SLN]]
+
*[[Manuals/calci/INCREMENT | INCREMENT]]
−
*[[Manuals/calci/SLOG | SLOG]]
+
*[[Manuals/calci/INSET | INSET]]
−
*[[Manuals/calci/SLOPE | SLOPE]]
+
*[[Manuals/calci/INT | INT]]
−
*[[Manuals/calci/SMALL | SMALL]]
+
*[[Manuals/calci/INTDIV | INTDIV]]
−
*[[Manuals/calci/SO | SO]]
+
*[[Manuals/calci/INTEGERDIVISION | INTEGERDIVISION]]
−
*[[Manuals/calci/SPHERE | SPHERE]]
+
*[[Manuals/calci/INTEGERS | INTEGERS]]
−
*[[Manuals/calci/SQRT | SQRT]]
+
*[[Manuals/calci/INTERSECTION | INTERSECTION]]
−
*[[Manuals/calci/SQRTPI | SQRTPI]]
+
*[[Manuals/calci/ITHPRIME | ITHPRIME]]
−
*[[Manuals/calci/SS | SS]]
+
*[[Manuals/calci/JOIN | JOIN]]
−
*[[Manuals/calci/STANDARDIZE | STANDARDIZE]]
+
*[[Manuals/calci/JOINSET | JOINSET]]
−
*[[Manuals/calci/STATS | STATS]]
+
*[[Manuals/calci/JPARTITION | JPARTITION]]
−
*[[Manuals/calci/STDEV | STDEV]]
+
*[[Manuals/calci/LB | LB]]
−
*[[Manuals/calci/STDEVA | STDEVA]]
+
*[[Manuals/calci/LBSTAR | LBSTAR]]
−
*[[Manuals/calci/STDEVP | STDEVP]]
+
*[[Manuals/calci/LCM | LCM]]
−
*[[Manuals/calci/STDEVPA | STDEVPA]]
+
*[[Manuals/calci/LE | LE]]
−
*[[Manuals/calci/STEYX | STEYX]]
+
*[[Manuals/calci/LGSTAR | LGSTAR]]
−
*[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]]
+
*[[Manuals/calci/LINEAREQUATION | LINEAREQUATION]]
−
*[[Manuals/calci/SUBTOTAL | SUBTOTAL]]
+
*[[Manuals/calci/LISTPRIMES | LISTPRIMES]]
−
*[[Manuals/calci/SUM | SUM]]
+
*[[Manuals/calci/LN | LN]]
−
*[[Manuals/calci/SUMIF | SUMIF]]
+
*[[Manuals/calci/LNSTAR | LNSTAR]]
−
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT]]
+
*[[Manuals/calci/LOG | LOG]]
−
*[[Manuals/calci/SUMSQ | SUMSQ]]
+
*[[Manuals/calci/LOGSTAR | LOGSTAR]]
−
*[[Manuals/calci/SYD | SYD]]
+
*[[Manuals/calci/LOGVALUES | LOGVALUES]]
−
*[[Manuals/calci/TAN | TAN]]
+
*[[Manuals/calci/LT | LT]]
−
*[[Manuals/calci/TBILLEQ | TBILLEQ]]
+
*[[Manuals/calci/LTE | LTE]]
−
*[[Manuals/calci/TBILLPRICE | TBILLPRICE]]
+
*[[Manuals/calci/LUCAS | LUCAS]]
−
*[[Manuals/calci/TBILLYIELD | TBILLYIELD]]
+
*[[Manuals/calci/MAKEPAIR | MAKEPAIR]]
−
*[[Manuals/calci/TDIST | TDIST]]
+
*[[Manuals/calci/MAKESUBTOTAL | MAKESUBTOTAL]]
−
*[[Manuals/calci/TEN | TEN]]
+
*[[Manuals/calci/MAKEUNITVALUE | MAKEUNITVALUE]]
−
*[[Manuals/calci/TEXT | TEXT]]
+
*[[Manuals/calci/MAKEFRACTION | MAKEFRACTION]]
−
*[[Manuals/calci/THING | THING]]
+
*[[Manuals/calci/MINUS | MINUS]]
−
*[[Manuals/calci/TIME | TIME]]
+
*[[Manuals/calci/MINUSOF | MINUSOF]]
−
*[[Manuals/calci/TIMEVALUE | TIMEVALUE]]
+
*[[Manuals/calci/MOD | MOD]]
−
*[[Manuals/calci/TINV | TINV]]
+
*[[Manuals/calci/MODBY | MODBY]]
−
*[[Manuals/calci/TRANSPOSE | TRANSPOSE]]
+
*[[Manuals/calci/MODWITH | MODWITH]]
−
*[[Manuals/calci/TREND | TREND]]
+
*[[Manuals/calci/MOP | MOP]]
−
*[[Manuals/calci/TRIANGLE | TRIANGLE]]
+
*[[Manuals/calci/MOPWITH | MOPWITH]]
−
*[[Manuals/calci/TRIM | TRIM]]
+
*[[Manuals/calci/MOPWITHEQ | MOPWITHEQ]]
−
*[[Manuals/calci/TRIMMEAN | TRIMMEAN]]
+
*[[Manuals/calci/MOPWITHFEQ | MOPWITHFEQ]]
−
*[[Manuals/calci/TRUNC | TRUNC]]
+
*[[Manuals/calci/MOPWITHGT | MOPWITHGT]]
−
*[[Manuals/calci/TTEST | TTEST]]
+
*[[Manuals/calci/MOPWITHGTE | MOPWITHGTE]]
−
*[[Manuals/calci/TTESTPAIRED | TTESTPAIRED]]
+
*[[Manuals/calci/MOPWITHLT | MOPWITHLT]]
−
*[[Manuals/calci/TZ | TZ]]
+
*[[Manuals/calci/MOPWITHLTE | MOPWITHLTE]]
−
*[[Manuals/calci/UPPER | UPPER]]
+
*[[Manuals/calci/MOPWITHMOD | MOPWITHMOD]]
−
*[[Manuals/calci/VALUE | VALUE]]
+
*[[Manuals/calci/MOPWITHNE | MOPWITHNE]]
−
*[[Manuals/calci/VAR | VAR]]
+
*[[Manuals/calci/MOPWITHPOWER | MOPWITHPOWER]]
−
*[[Manuals/calci/VARA | VARA]]
+
*[[Manuals/calci/MOPX | MOPX]]
−
*[[Manuals/calci/VARP | VARP]]
+
*[[Manuals/calci/MROUND | MROUND]]
−
*[[Manuals/calci/VARPA | VARPA]]
+
*[[Manuals/calci/MULTINOMIAL | MULTINOMIAL]]
−
*[[Manuals/calci/VDB | VDB]]
+
*[[Manuals/calci/MULTIPLES | MULTIPLES]]
−
*[[Manuals/calci/VLOOKUP | VLOOKUP]]
+
*[[Manuals/calci/MULTIPLESOF | MULTIPLESOF]]
−
*[[Manuals/calci/WEEKDAY | WEEKDAY]]
+
*[[Manuals/calci/MULTIPLESTWO | MULTIPLESTWO]]
−
*[[Manuals/calci/WEEKNUM | WEEKNUM]]
+
*[[Manuals/calci/MULTIPLY | MULTIPLY]]
−
*[[Manuals/calci/WEIBULL | WEIBULL]]
+
*[[Manuals/calci/MULTIPLYBY | MULTIPLYBY]]
−
*[[Manuals/calci/WH | WH]]
+
*[[Manuals/calci/MULTIPLYWITH | MULTIPLYWITH]]
−
*[[Manuals/calci/WILCOXONSIGNEDRANKTEST | WILCOXONSIGNEDRANKTEST]]
+
*[[Manuals/calci/NEG | NEG]]
−
*[[Manuals/calci/WORKDAY | WORKDAY]]
+
*[[Manuals/calci/NEGATE | NEGATE]]
−
*[[Manuals/calci/WS | WS]]
+
*[[Manuals/calci/NEGATIVE | NEGATIVE]]
−
*[[Manuals/calci/XIRR | XIRR]]
+
*[[Manuals/calci/NEXTPOWER | NEXTPOWER]]
−
*[[Manuals/calci/XMY | XMY]]
+
*[[Manuals/calci/NTH | NTH]]
−
*[[Manuals/calci/XNPV | XNPV]]
+
*[[Manuals/calci/NTHELEMENT | NTHELEMENT]]
−
*[[Manuals/calci/YEAR | YEAR]]
+
*[[Manuals/calci/NTHROOT | NTHROOT]]
−
*[[Manuals/calci/YEARFRAC | YEARFRAC]]
+
*[[Manuals/calci/NUMS | NUMS]]
−
*[[Manuals/calci/YIELD | YIELD]]
+
*[[Manuals/calci/NUMSCORE | NUMSCORE]]
−
*[[Manuals/calci/YIELDDISC | YIELDDISC]]
+
*[[Manuals/calci/ODD | ODD]]
−
*[[Manuals/calci/YIELDMAT | YIELDMAT]]
+
*[[Manuals/calci/ODDS | ODDS]]
−
*[[Manuals/calci/ZERO | ZERO]]
+
*[[Manuals/calci/ODDSET | ODDSET]]
−
*[[Manuals/calci/ZT | ZT]]
+
*[[Manuals/calci/ODDSUPTO | ODDSUPTO]]
−
*[[Manuals/calci/ZTEST | ZTEST]]
+
*[[Manuals/calci/ORDINAL | ORDINAL]]
−
*[[Manuals/calci/hadamard | hadamard]]
+
*[[Manuals/calci/PLUSMINUS | PLUSMINUS]]
−
*[[Manuals/calci/hankel | hankel]]
+
*[[Manuals/calci/POSITIVE | POSITIVE]]
−
*[[Manuals/calci/ACCELERATIONDUETOGRAVITY | ACCELERATIONDUETOGRAVITY]]
+
*[[Manuals/calci/POWER | POWER]]
−
*[[Manuals/calci/ACKERMANN | ACKERMANN]]
+
*[[Manuals/calci/PRIMEFACTORS | PRIMEFACTORS]]
−
*[[Manuals/calci/ACOS | ACOS]]
+
*[[Manuals/calci/PRIMES | PRIMES]]
−
*[[Manuals/calci/ACOSH | ACOSH]]
+
*[[Manuals/calci/PRODUCT | PRODUCT]]
−
*[[Manuals/calci/ACRONYM | ACRONYM]]
+
*[[Manuals/calci/PRODUCTOF | PRODUCTOF]]
−
*[[Manuals/calci/ADDBY | ADDBY]]
+
*[[Manuals/calci/QUADRATIC | QUADRATIC]]
−
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]]
+
*[[Manuals/calci/QUOTIENT | QUOTIENT]]
−
*[[Manuals/calci/ADDDATE | ADDDATE]]
+
*[[Manuals/calci/RAD | RAD]]
−
*[[Manuals/calci/ADDFACT | ADDFACT]]
+
*[[Manuals/calci/RADIANSLIST | RADIANSLIST]]
−
*[[Manuals/calci/ADDINS | ADDINS]]
+
*[[Manuals/calci/RAND | RAND]]
−
*[[Manuals/calci/ADDWITH | ADDWITH]]
+
*[[Manuals/calci/RANDBETWEEN | RANDBETWEEN]]
−
*[[Manuals/calci/ADJ | ADJ]]
+
*[[Manuals/calci/RANDINT | RANDINT]]
−
*[[Manuals/calci/ANALYZE | ANALYZE]]
+
*[[Manuals/calci/RANDNUM | RANDNUM]]
−
*[[Manuals/calci/ANGLEAT | ANGLEAT]]
+
*[[Manuals/calci/REM | REM]]
−
*[[Manuals/calci/ANGLES | ANGLES]]
+
*[[Manuals/calci/REMAINDER | REMAINDER]]
−
*[[Manuals/calci/ANGLESLIST | ANGLESLIST]]
+
*[[Manuals/calci/ROMAN | ROMAN]]
−
*[[Manuals/calci/ANTIDIAGONALWITH | ANTIDIAGONALWITH]]
+
*[[Manuals/calci/ROMANOLD | ROMANOLD]]
−
*[[Manuals/calci/ANTILOG | ANTILOG]]
+
*[[Manuals/calci/ROOTNTH | ROOTNTH]]
−
*[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
+
*[[Manuals/calci/ROOTNTHFUNCTION | ROOTNTHFUNCTION]]
−
*[[Manuals/calci/APPLY | APPLY]]
+
*[[Manuals/calci/ROOTTHETA | ROOTTHETA]]
−
*[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
+
*[[Manuals/calci/ROOTTHETATOQUARDRANT | ROOTTHETATOQUARDRANT]]
−
*[[Manuals/calci/APPLYFUNCTIONTOELEMENTS | APPLYFUNCTIONTOELEMENTS]]
+
*[[Manuals/calci/ROUND | ROUND]]
−
*[[Manuals/calci/APPLYFUNCTIONTORANGE | APPLYFUNCTIONTORANGE]]
+
*[[Manuals/calci/ROUNDAT | ROUNDAT]]
−
*[[Manuals/calci/APPLYOF | APPLYOF]]
+
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]]
−
*[[Manuals/calci/APPLYTOALLKEYS | APPLYTOALLKEYS]]
+
*[[Manuals/calci/ROUNDUP | ROUNDUP]]
−
*[[Manuals/calci/APPLYTOKEYS | APPLYTOKEYS]]
+
*[[Manuals/calci/SCALARPRODUCT | SCALARPRODUCT]]
−
*[[Manuals/calci/ARBIT | ARBIT]]
+
*[[Manuals/calci/SEC | SEC]]
−
*[[Manuals/calci/ARGS | ARGS]]
+
*[[Manuals/calci/SECH | SECH]]
−
*[[Manuals/calci/ARGSONE | ARGSONE]]
+
*[[Manuals/calci/SERIES | SERIES]]
−
*[[Manuals/calci/ARITHMETICSERIES | ARITHMETICSERIES]]
+
*[[Manuals/calci/SERIESOF | SERIESOF]]
−
*[[Manuals/calci/ARITHMETICSERIESCORE | ARITHMETICSERIESCORE]]
+
*[[Manuals/calci/SERIESSTR | SERIESSTR]]
−
*[[Manuals/calci/ARRAY | ARRAY]]
+
*[[Manuals/calci/SERIESSUM | SERIESSUM]]
−
*[[Manuals/calci/ARRAYFY | ARRAYFY]]
+
*[[Manuals/calci/SERIESTERMS | SERIESTERMS]]
−
*[[Manuals/calci/ARRAYIFY | ARRAYIFY]]
+
*[[Manuals/calci/SET | SET]]
−
*[[Manuals/calci/ARRAYMAKE | ARRAYMAKE]]
+
*[[Manuals/calci/SETCONVERSION | SETCONVERSION]]
−
*[[Manuals/calci/ARRAYPRINT | ARRAYPRINT]]
+
*[[Manuals/calci/SETVALUE | SETVALUE]]
−
*[[Manuals/calci/ARRAYSIZE | ARRAYSIZE]]
+
*[[Manuals/calci/SEVENTHOF | SEVENTHOF]]
−
*[[Manuals/calci/ARRAYTOCALCI | ARRAYTOCALCI]]
+
*[[Manuals/calci/SEVERAL | SEVERAL]]
−
*[[Manuals/calci/ARRAYTOSTRING | ARRAYTOSTRING]]
+
*[[Manuals/calci/SIGMA | SIGMA]]
−
*[[Manuals/calci/ASARRAY | ASARRAY]]
+
*[[Manuals/calci/SIGMAOF | SIGMAOF]]
−
*[[Manuals/calci/ASCENDING | ASCENDING]]
+
*[[Manuals/calci/SIGN | SIGN]]
−
*[[Manuals/calci/ASINH | ASINH]]
+
*[[Manuals/calci/SIN | SIN]]
−
*[[Manuals/calci/ASSIGN | ASSIGN]]
+
*[[Manuals/calci/SIN#Examples |SINExamples]]
−
*[[Manuals/calci/ASYNCITERATE | ASYNCITERATE]]
+
*[[Manuals/calci/SINC | SINC]]
−
*[[Manuals/calci/ATAN | ATAN]]
+
*[[Manuals/calci/SINCP | SINCP]]
−
*[[Manuals/calci/ATANH | ATANH]]
+
*[[Manuals/calci/SINH | SINH]]
−
*[[Manuals/calci/ATOZ | ATOZ]]
+
*[[Manuals/calci/SIXTHOF | SIXTHOF]]
−
*[[Manuals/calci/ATTRTOPROP | ATTRTOPROP]]
+
*[[Manuals/calci/SLOG | SLOG]]
−
*[[Manuals/calci/AVERAGEBOTTOM | AVERAGEBOTTOM]]
+
*[[Manuals/calci/SORTING | SORTING]]
−
*[[Manuals/calci/AVERAGEIF | AVERAGEIF]]
+
*[[Manuals/calci/SQRT | SQRT]]
−
*[[Manuals/calci/AVERAGEMIDDLE | AVERAGEMIDDLE]]
+
*[[Manuals/calci/SQRTPI | SQRTPI]]
−
*[[Manuals/calci/AVERAGETOP | AVERAGETOP]]
+
*[[Manuals/calci/SUBSET | SUBSET]]
−
*[[Manuals/calci/AVG | AVG]]
+
*[[Manuals/calci/SUBTOTAL | SUBTOTAL]]
−
*[[Manuals/calci/BADWORDS | BADWORDS]]
+
*[[Manuals/calci/SUBTRACT | SUBTRACT]]
−
*[[Manuals/calci/BAHTTEXT | BAHTTEXT]]
+
*[[Manuals/calci/SUBTRACTBY | SUBTRACTBY]]
−
*[[Manuals/calci/BARCHART | BARCHART]]
+
*[[Manuals/calci/SUBTRACTFROM | SUBTRACTFROM]]
−
*[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
+
*[[Manuals/calci/SUBTRACTWITH | SUBTRACTWITH]]
−
*[[Manuals/calci/BASETHETA | BASETHETA]]
+
*[[Manuals/calci/SUM | SUM]]
−
*[[Manuals/calci/BEEP | BEEP]]
+
*[[Manuals/calci/SUMBY | SUMBY]]
−
*[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]]
+
*[[Manuals/calci/SUMFACTORS | SUMFACTORS]]
−
*[[Manuals/calci/BETADISTX | BETADISTX]]
+
*[[Manuals/calci/SUMIF | SUMIF]]
−
*[[Manuals/calci/BETAFUNCTION | BETAFUNCTION]]
+
*[[Manuals/calci/SUMOF | SUMOF]]
−
*[[Manuals/calci/BETWEENCORE | BETWEENCORE]]
+
*[[Manuals/calci/SUMOFSQUARES | SUMOFSQUARES]]
−
*[[Manuals/calci/BG | BG]]
+
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT]]
−
*[[Manuals/calci/BILLION | BILLION]]
+
*[[Manuals/calci/SUPERLOGARITHM | SUPERLOGARITHM]]
−
*[[Manuals/calci/BINOMIALCOEFFICIENT | BINOMIALCOEFFICIENT]]
+
*[[Manuals/calci/SUPERSET | SUPERSET]]
−
*[[Manuals/calci/BINOMIALDISTRIBUTED | BINOMIALDISTRIBUTED]]
+
*[[Manuals/calci/TAN | TAN]]
−
*[[Manuals/calci/BINOMIALPROBABILTY | BINOMIALPROBABILTY]]
+
*[[Manuals/calci/TANH | TANH]]
−
*[[Manuals/calci/BINOMIALSERIES | BINOMIALSERIES]]
+
*[[Manuals/calci/TEN | TEN]]
−
*[[Manuals/calci/BIRTHDAYPROBABILITY | BIRTHDAYPROBABILITY]]
+
*[[Manuals/calci/TENTHOF | TENTHOF]]
−
*[[Manuals/calci/BITAND | BITAND]]
+
*[[Manuals/calci/THETAINDEGREES | THETAINDEGREES]]
−
*[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
+
*[[Manuals/calci/THETAS | THETAS]]
−
*[[Manuals/calci/BITNOT | BITNOT]]
+
*[[Manuals/calci/THIRDOF | THIRDOF]]
−
*[[Manuals/calci/BITOR | BITOR]]
+
*[[Manuals/calci/THOUSAND | THOUSAND]]
−
*[[Manuals/calci/BITRSHIFT | BITRSHIFT]]
+
*[[Manuals/calci/TRILLION | TRILLION]]
−
*[[Manuals/calci/BITRSHIFTZ | BITRSHIFTZ]]
+
*[[Manuals/calci/TRUNC | TRUNC]]
−
*[[Manuals/calci/BITXOR | BITXOR]]
+
*[[Manuals/calci/UNION | UNION]]
−
*[[Manuals/calci/BOLD | BOLD]]
+
*[[Manuals/calci/UNIQUE | UNIQUE]]
−
*[[Manuals/calci/BOTTOM | BOTTOM]]
+
*[[Manuals/calci/UNIQUESET | UNIQUESET]]
−
*[[Manuals/calci/BOTTOMN | BOTTOMN]]
+
*[[Manuals/calci/UNIQUESUBSTRINGS | UNIQUESUBSTRINGS]]
−
*[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
+
*[[Manuals/calci/UNITADD | UNITADD]]
−
*[[Manuals/calci/BYID | BYID]]
+
*[[Manuals/calci/UNITDIVIDE | UNITDIVIDE]]
−
*[[Manuals/calci/CAGR | CAGR]]
+
*[[Manuals/calci/UNITEQ | UNITEQ]]
−
*[[Manuals/calci/CALCULATE | CALCULATE]]
+
*[[Manuals/calci/UNITEQS | UNITEQS]]
−
*[[Manuals/calci/CALENDARPLOT | CALENDARPLOT]]
+
*[[Manuals/calci/UNITEXPRESSION | UNITEXPRESSION]]
−
*[[Manuals/calci/CALENDER | CALENDER]]
+
*[[Manuals/calci/UNITGE | UNITGE]]
−
*[[Manuals/calci/CALLLISP | CALLLISP]]
+
*[[Manuals/calci/UNITGT | UNITGT]]
−
*[[Manuals/calci/CALLOPTION | CALLOPTION]]
+
*[[Manuals/calci/UNITIFY | UNITIFY]]
−
*[[Manuals/calci/CALLSQL | CALLSQL]]
+
*[[Manuals/calci/UNITLE | UNITLE]]
−
*[[Manuals/calci/CANVASIMAGE | CANVASIMAGE]]
+
*[[Manuals/calci/UNITLT | UNITLT]]
−
*[[Manuals/calci/CAPITALLETTERS | CAPITALLETTERS]]
+
*[[Manuals/calci/UNITMINUS | UNITMINUS]]
−
*[[Manuals/calci/CAR | CAR]]
+
*[[Manuals/calci/UNITMOD | UNITMOD]]
−
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]]
+
*[[Manuals/calci/UNITMULTIPLY | UNITMULTIPLY]]
−
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]]
+
*[[Manuals/calci/UNITNE | UNITNE]]
−
*[[Manuals/calci/CASE | CASE]]
+
*[[Manuals/calci/UNITNES | UNITNES]]
−
*[[Manuals/calci/CASEIF | CASEIF]]
+
*[[Manuals/calci/UNITOP | UNITOP]]
−
*[[Manuals/calci/CDR | CDR]]
+
*[[Manuals/calci/UNITPOWER | UNITPOWER]]
−
*[[Manuals/calci/CEILINGAT | CEILINGAT]]
+
*[[Manuals/calci/VECTORDIRECTPRODUCT | VECTORDIRECTPRODUCT]]
−
*[[Manuals/calci/CHECKFACT | CHECKFACT]]
+
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]]
−
*[[Manuals/calci/CHOLESKYFACTORIZATION | CHOLESKYFACTORIZATION]]
+
 
−
*[[Manuals/calci/CHORDDIAGRAM | CHORDDIAGRAM]]
+
===Math2===
−
*[[Manuals/calci/CHORDMATRIXDIAGRAM | CHORDMATRIXDIAGRAM]]
+
*[[Manuals/calci/ACKERMANN | ACKERMANN]]
−
*[[Manuals/calci/CHR | CHR]]
+
*[[Manuals/calci/ADDINS | ADDINS]]
−
*[[Manuals/calci/CIRCLEPACKING | CIRCLEPACKING]]
+
*[[Manuals/calci/ARITHMETICSERIESCORE | ARITHMETICSERIESCORE]]
−
*[[Manuals/calci/CIRCLEWITHTEXT | CIRCLEWITHTEXT]]
+
*[[Manuals/calci/CREATEEQUATION | CREATEEQUATION]]
−
*[[Manuals/calci/CIS | CIS]]
+
*[[Manuals/calci/CREATEFORMULA | CREATEFORMULA]]
−
*[[Manuals/calci/CLAUSES | CLAUSES]]
+
*[[Manuals/calci/DELTA | DELTA]]
−
*[[Manuals/calci/CLEAR | CLEAR]]
+
*[[Manuals/calci/DERIVATIVEOFFUNCTION | DERIVATIVEOFFUNCTION]]
 +
*[[Manuals/calci/ENFORCEINTEGER | ENFORCEINTEGER]]
 +
*[[Manuals/calci/ENFORCENATURAL | ENFORCENATURAL]]
 +
*[[Manuals/calci/ENFORCENEGATIVE | ENFORCENEGATIVE]]
 +
*[[Manuals/calci/ENFORCENEGATIVEINTEGER | ENFORCENEGATIVEINTEGER]]
 +
*[[Manuals/calci/ENFORCENEGZEROPOS | ENFORCENEGZEROPOS]]
 +
*[[Manuals/calci/ENFORCEPOSITIVE | ENFORCEPOSITIVE]]
 +
*[[Manuals/calci/ENFORCEPOSITIVEINTEGER | ENFORCEPOSITIVEINTEGER]]
 +
*[[Manuals/calci/ENFORCETYPE | ENFORCETYPE]]
 +
*[[Manuals/calci/ENFORCEZERO | ENFORCEZERO]]
 +
*[[Manuals/calci/EVALX | EVALX]]
 +
*[[Manuals/calci/FLATTEN | FLATTEN]]
 +
*[[Manuals/calci/INTEGRATE | INTEGRATE]]
 +
*[[Manuals/calci/INTEGRATEFOR | INTEGRATEFOR]]
 +
*[[Manuals/calci/INTEGRATEFORCORE | INTEGRATEFORCORE]]
 +
*[[Manuals/calci/INTEGRATEUNTIL | INTEGRATEUNTIL]]
 +
*[[Manuals/calci/INTS | INTS]]
 +
*[[Manuals/calci/INTSTWO | INTSTWO]]
 +
*[[Manuals/calci/NEWCALCI | NEWCALCI]]
 +
*[[Manuals/calci/NEWFUNCTIONNAME | NEWFUNCTIONNAME]]
 +
*[[Manuals/calci/QUALITATIVEDESCRIPTION | QUALITATIVEDESCRIPTION]]
 +
*[[Manuals/calci/SUMSQ | SUMSQ]]
 +
*[[Manuals/calci/SUMWITH | SUMWITH]]
 +
*[[Manuals/calci/TETRATE | TETRATE]]
 +
 
 +
===Date and Time1===
 +
*[[Manuals/calci/ADDDATE | ADDDATE]]
 +
*[[Manuals/calci/AGINGINDAYS | AGINGINDAYS]]
 
*[[Manuals/calci/CLOCK | CLOCK]]
 
*[[Manuals/calci/CLOCK | CLOCK]]
−
*[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
+
*[[Manuals/calci/CALENDER | CALENDER]]
−
*[[Manuals/calci/CLS | CLS]]
+
*[[Manuals/calci/DATE | DATE]]
−
*[[Manuals/calci/CLUSTERDENDROGRAM | CLUSTERDENDROGRAM]]
+
*[[Manuals/calci/DATESERIAL | DATESERIAL]]
−
*[[Manuals/calci/COALESCE | COALESCE]]
+
*[[Manuals/calci/DATESTRING | DATESTRING]]
−
*[[Manuals/calci/COLLAPSIBLEINDENTEDTREE | COLLAPSIBLEINDENTEDTREE]]
+
*[[Manuals/calci/DATETOEXCEL | DATETOEXCEL]]
−
*[[Manuals/calci/COLLAPSIBLETREE | COLLAPSIBLETREE]]
+
*[[Manuals/calci/DATETOJS | DATETOJS]]
−
*[[Manuals/calci/COLLECTION | COLLECTION]]
+
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
−
*[[Manuals/calci/COLORS | COLORS]]
+
*[[Manuals/calci/DAY | DAY]]
−
*[[Manuals/calci/COLUMNWITH | COLUMNWITH]]
+
*[[Manuals/calci/DAYINDEX | DAYINDEX]]
−
*[[Manuals/calci/COLWITH | COLWITH]]
+
*[[Manuals/calci/DAYS | DAYS]]
−
*[[Manuals/calci/COMBINATIONS | COMBINATIONS]]
+
*[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN]]
−
*[[Manuals/calci/COMMENTGET | COMMENTGET]]
+
*[[Manuals/calci/DAYSBETWEENBASIS | DAYSBETWEENBASIS]]
−
*[[Manuals/calci/COMPARE | COMPARE]]
+
*[[Manuals/calci/DAYSINYEAR | DAYSINYEAR]]
−
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]]
+
*[[Manuals/calci/DAYSINYEARTILLDATE | DAYSINYEARTILLDATE]]
−
*[[Manuals/calci/COMPLEXNUM | COMPLEXNUM]]
+
*[[Manuals/calci/EDATE | EDATE]]
−
*[[Manuals/calci/COMPLEXNUMBER | COMPLEXNUMBER]]
+
*[[Manuals/calci/EOMONTH | EOMONTH]]
−
*[[Manuals/calci/CONCATSTRINGTOARRAY | CONCATSTRINGTOARRAY]]
+
*[[Manuals/calci/FORMATTIME | FORMATTIME]]
−
*[[Manuals/calci/CONS | CONS]]
+
*[[Manuals/calci/FROMTO | FROMTO]]
−
*[[Manuals/calci/CONST | CONST]]
+
*[[Manuals/calci/FROMTOADV | FROMTOADV]]
−
*[[Manuals/calci/CONSTANTS | CONSTANTS]]
+
*[[Manuals/calci/GREGORIANDATE | GREGORIANDATE]]
−
*[[Manuals/calci/CONTAINS | CONTAINS]]
+
*[[Manuals/calci/HOUR | HOUR]]
−
*[[Manuals/calci/CONTAINVISUALLY | CONTAINVISUALLY]]
+
*[[Manuals/calci/JULIANDATE | JULIANDATE]]
−
*[[Manuals/calci/CONTOURS | CONTOURS]]
+
*[[Manuals/calci/MINUTE | MINUTE]]
−
*[[Manuals/calci/CONVERGE | CONVERGE]]
+
*[[Manuals/calci/MONTH | MONTH]]
−
*[[Manuals/calci/CONVERTCORE | CONVERTCORE]]
+
*[[Manuals/calci/MOMENT| MOMENT]]
−
*[[Manuals/calci/CORRELATIONDATAANALYSIS | CORRELATIONDATAANALYSIS]]
+
*[[Manuals/calci/MONTHEND | MONTHEND]]
−
*[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]]
+
*[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]]
−
*[[Manuals/calci/CREATEEQUATION | CREATEEQUATION]]
+
*[[Manuals/calci/MONTHS | MONTHS]]
−
*[[Manuals/calci/CREATEFORMULA | CREATEFORMULA]]
+
*[[Manuals/calci/MONTHSTRING | MONTHSTRING]]
−
*[[Manuals/calci/CROSSPRODUCT | CROSSPRODUCT]]
+
*[[Manuals/calci/NETWORKDAYS | NETWORKDAYS]]
−
*[[Manuals/calci/CSCH | CSCH]]
+
*[[Manuals/calci/SECOND | SECOND]]
−
*[[Manuals/calci/CSSA | CSSA]]
+
*[[Manuals/calci/TIME | TIME]]
−
*[[Manuals/calci/CSV | CSV]]
+
*[[Manuals/calci/TODATE | TODATE]]
−
*[[Manuals/calci/CUBE | CUBE]]
+
*[[Manuals/calci/TODAY | TODAY]]
−
*[[Manuals/calci/CUBEDEV | CUBEDEV]]
+
*[[Manuals/calci/TOMONTH | TOMONTH]]
−
*[[Manuals/calci/CUBEROOT | CUBEROOT]]
+
*[[Manuals/calci/TONUMBER | TONUMBER]]
−
*[[Manuals/calci/CUBES | CUBES]]
+
*[[Manuals/calci/WEEKDAY | WEEKDAY]]
−
*[[Manuals/calci/CURVE | CURVE]]
+
*[[Manuals/calci/WEEKNUM | WEEKNUM]]
−
*[[Manuals/calci/CYCLEWITHIN | CYCLEWITHIN]]
+
*[[Manuals/calci/WORKDAY | WORKDAY]]
−
*[[Manuals/calci/DATESERIAL | DATESERIAL]]
+
*[[Manuals/calci/YEAR | YEAR]]
−
*[[Manuals/calci/DATESTRING | DATESTRING]]
+
*[[Manuals/calci/YEARBASIS | YEARBASIS]]
−
*[[Manuals/calci/DATETOEXCEL | DATETOEXCEL]]
+
*[[Manuals/calci/YEARFRAC | YEARFRAC]]
−
*[[Manuals/calci/DATETOJS | DATETOJS]]
+
 
−
*[[Manuals/calci/DAYINDEX | DAYINDEX]]
+
===Date and Time2===
−
*[[Manuals/calci/DAYSBETWEENBASIS | DAYSBETWEENBASIS]]
+
*[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]]
−
*[[Manuals/calci/DAYSINYEAR | DAYSINYEAR]]
+
*[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]]
−
*[[Manuals/calci/DAYSINYEARTILLDATE | DAYSINYEARTILLDATE]]
+
*[[Manuals/calci/TIMEVALUE | TIMEVALUE]]
−
*[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]]
+
 
−
*[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]]
+
===Engineering1===
−
*[[Manuals/calci/DBPEDIA | DBPEDIA]]
+
*[[Manuals/calci/ARGS | ARGS]]
−
*[[Manuals/calci/DCOS | DCOS]]
+
*[[Manuals/calci/ARGSONE | ARGSONE]]
−
*[[Manuals/calci/DCOSEC | DCOSEC]]
+
*[[Manuals/calci/COMPLEX | COMPLEX]]
−
*[[Manuals/calci/DCOTAN | DCOTAN]]
+
*[[Manuals/calci/COMPLEXNUM | COMPLEXNUM]]
−
*[[Manuals/calci/DEAL | DEAL]]
+
*[[Manuals/calci/COMPLEXNUMBER | COMPLEXNUMBER]]
−
*[[Manuals/calci/DECIMAL | DECIMAL]]
+
*[[Manuals/calci/CONVERT | CONVERT]]
−
*[[Manuals/calci/DECIMALPART | DECIMALPART]]
+
*[[Manuals/calci/CONVERTCORE | CONVERTCORE]]
−
*[[Manuals/calci/DECK | DECK]]
+
*[[Manuals/calci/ERF | ERF]]
−
*[[Manuals/calci/DECLARE | DECLARE]]
+
*[[Manuals/calci/ERFC | ERFC]]
−
*[[Manuals/calci/DECR | DECR]]
+
*[[Manuals/calci/ERROR | ERROR]]
−
*[[Manuals/calci/DECREASING | DECREASING]]
+
*[[Manuals/calci/ERRORTYPE | ERRORTYPE]]
−
*[[Manuals/calci/DECREMENT | DECREMENT]]
+
*[[Manuals/calci/ERRORTYPES | ERRORTYPES]]
−
*[[Manuals/calci/DEFAULT | DEFAULT]]
+
*[[Manuals/calci/GESTEP | GESTEP]]
−
*[[Manuals/calci/DEFAULTNUMBER | DEFAULTNUMBER]]
+
*[[Manuals/calci/GFUNCTION | GFUNCTION]]
−
*[[Manuals/calci/DEFAULTPROPER | DEFAULTPROPER]]
+
*[[Manuals/calci/HEX | HEX]]
−
*[[Manuals/calci/DEFUN | DEFUN]]
+
*[[Manuals/calci/IMABS | IMABS]]
−
*[[Manuals/calci/DEGREESLIST | DEGREESLIST]]
+
*[[Manuals/calci/IMAGINARY | IMAGINARY]]
−
*[[Manuals/calci/DERIVATIVEOFFUNCTION | DERIVATIVEOFFUNCTION]]
+
*[[Manuals/calci/IMARGUMENT | IMARGUMENT]]
−
*[[Manuals/calci/DESCENDING | DESCENDING]]
+
*[[Manuals/calci/IMCONJUGATE | IMCONJUGATE]]
−
*[[Manuals/calci/DESCRIBEFUNCTIONCALLMISSING | DESCRIBEFUNCTIONCALLMISSING]]
+
*[[Manuals/calci/IMCOS | IMCOS]]
−
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]]
+
*[[Manuals/calci/IMCOSH | IMCOSH]]
−
*[[Manuals/calci/DEVARRAY | DEVARRAY]]
+
*[[Manuals/calci/IMCOT | IMCOT]]
−
*[[Manuals/calci/DIAGONALFILL | DIAGONALFILL]]
+
*[[Manuals/calci/IMCOTH | IMCOTH]]
−
*[[Manuals/calci/DIAGONALMATRIX | DIAGONALMATRIX]]
+
*[[Manuals/calci/IMCSC | IMCSC]]
−
*[[Manuals/calci/DIAGONALWITH | DIAGONALWITH]]
+
*[[Manuals/calci/IMCSCH | IMCSCH]]
−
*[[Manuals/calci/DIFFERENCE | DIFFERENCE]]
+
*[[Manuals/calci/IMDIV | IMDIV]]
−
*[[Manuals/calci/DIGITS | DIGITS]]
+
*[[Manuals/calci/IMDIVTWO | IMDIVTWO]]
−
*[[Manuals/calci/DIM | DIM]]
+
*[[Manuals/calci/IMEXP | IMEXP]]
−
*[[Manuals/calci/DIMENSIONS | DIMENSIONS]]
+
*[[Manuals/calci/IMLN | IMLN]]
−
*[[Manuals/calci/DISCRETEDISTRIBUTED | DISCRETEDISTRIBUTED]]
+
*[[Manuals/calci/IMLOG | IMLOG]]
−
*[[Manuals/calci/DISPLAYXML | DISPLAYXML]]
+
*[[Manuals/calci/IMPOWER | IMPOWER]]
−
*[[Manuals/calci/DISTINCT | DISTINCT]]
+
*[[Manuals/calci/IMPRODUCT | IMPRODUCT]]
−
*[[Manuals/calci/DISTINCTSET | DISTINCTSET]]
+
*[[Manuals/calci/IMPRODUCTTWO | IMPRODUCTTWO]]
−
*[[Manuals/calci/DIVIDE | DIVIDE]]
+
*[[Manuals/calci/IMREAL | IMREAL]]
−
*[[Manuals/calci/DIVIDEBY | DIVIDEBY]]
+
*[[Manuals/calci/IMSEC | IMSEC]]
−
*[[Manuals/calci/DIVIDEWITH | DIVIDEWITH]]
+
*[[Manuals/calci/IMSECH | IMSECH]]
−
*[[Manuals/calci/DIVISION | DIVISION]]
+
*[[Manuals/calci/IMSIN | IMSIN]]
−
*[[Manuals/calci/DIVISIONOF | DIVISIONOF]]
+
*[[Manuals/calci/IMSINH | IMSINH]]
−
*[[Manuals/calci/DIVPARTS | DIVPARTS]]
+
*[[Manuals/calci/IMSQRT | IMSQRT]]
−
*[[Manuals/calci/DOBY | DOBY]]
+
*[[Manuals/calci/IMSTRING | IMSTRING]]
−
*[[Manuals/calci/DOCALLAFTER | DOCALLAFTER]]
+
*[[Manuals/calci/IMSUB | IMSUB]]
−
*[[Manuals/calci/DOEFFECT | DOEFFECT]]
+
*[[Manuals/calci/IMSUBTWO | IMSUBTWO]]
−
*[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
+
*[[Manuals/calci/IMSUM | IMSUM]]
−
*[[Manuals/calci/DONOTHING | DONOTHING]]
+
*[[Manuals/calci/IMSUMTWO | IMSUMTWO]]
−
*[[Manuals/calci/DOSQL | DOSQL]]
+
*[[Manuals/calci/IMTAN | IMTAN]]
−
*[[Manuals/calci/DOTPRODUCT | DOTPRODUCT]]
+
*[[Manuals/calci/IMTANH | IMTANH]]
−
*[[Manuals/calci/DRAGON | DRAGON]]
+
*[[Manuals/calci/MAKECOMPLEXIMINUS | MAKECOMPLEXIMINUS]]
−
*[[Manuals/calci/DRAW | DRAW]]
+
*[[Manuals/calci/MAKECOMPLEXIMINUSSIMPLE | MAKECOMPLEXIMINUSSIMPLE]]
−
*[[Manuals/calci/DRAWDATACURVE | DRAWDATACURVE]]
+
*[[Manuals/calci/MAKECOMPLEXIPLUS | MAKECOMPLEXIPLUS]]
−
*[[Manuals/calci/DRAWSHAPE | DRAWSHAPE]]
+
*[[Manuals/calci/MAKECOMPLEXISIMPLE | MAKECOMPLEXISIMPLE]]
−
*[[Manuals/calci/DROP | DROP]]
+
*[[Manuals/calci/REMOVECONVERSION | REMOVECONVERSION]]
−
*[[Manuals/calci/DSEC | DSEC]]
+
*[[Manuals/calci/REMOVENUMBERS | REMOVENUMBERS]]
−
*[[Manuals/calci/DSIN | DSIN]]
+
*[[Manuals/calci/TOUNITS | TOUNITS]]
−
*[[Manuals/calci/DSV | DSV]]
+
*[[Manuals/calci/UNITS | UNITS]]
−
*[[Manuals/calci/DTAN | DTAN]]
+
*[[Manuals/calci/UNITSFAILTONULL | UNITSFAILTONULL]]
−
*[[Manuals/calci/DUPLICATE | DUPLICATE]]
+
*[[Manuals/calci/UNITSOF | UNITSOF]]
−
*[[Manuals/calci/DYADIC | DYADIC]]
+
 
−
*[[Manuals/calci/EARTH | EARTH]]
+
===Engineering2===
−
*[[Manuals/calci/EDGEBUNDLING | EDGEBUNDLING]]
+
*[[Manuals/calci/BESSELI | BESSELI]]
−
*[[Manuals/calci/EFFECTBULGE | EFFECTBULGE]]
+
*[[Manuals/calci/BESSELJ | BESSELJ]]
−
*[[Manuals/calci/EFFECTCOLORBOOK | EFFECTCOLORBOOK]]
+
*[[Manuals/calci/BESSELK | BESSELK]]
−
*[[Manuals/calci/EFFECTDISPLACEMENT | EFFECTDISPLACEMENT]]
+
*[[Manuals/calci/BESSELY | BESSELY]]
−
*[[Manuals/calci/EFFECTEDGEDETECTION | EFFECTEDGEDETECTION]]
 
−
*[[Manuals/calci/EFFECTEDGEDETECTIONALGORITHM | EFFECTEDGEDETECTIONALGORITHM]]
 
−
*[[Manuals/calci/EFFECTGLASS | EFFECTGLASS]]
 
−
*[[Manuals/calci/EFFECTGLASSBOX | EFFECTGLASSBOX]]
 
−
*[[Manuals/calci/EFFECTGLASSPATTERN | EFFECTGLASSPATTERN]]
 
−
*[[Manuals/calci/EFFECTNEONLINES | EFFECTNEONLINES]]
 
−
*[[Manuals/calci/EFFECTPATTERN | EFFECTPATTERN]]
 
−
*[[Manuals/calci/EFFECTRIPPLES | EFFECTRIPPLES]]
 
−
*[[Manuals/calci/EIGENVALUES | EIGENVALUES]]
 
−
*[[Manuals/calci/EIGHTHOF | EIGHTHOF]]
 
−
*[[Manuals/calci/ELBOWEDENDOGRAM | ELBOWEDENDOGRAM]]
 
−
*[[Manuals/calci/ELEMENTAT | ELEMENTAT]]
 
−
*[[Manuals/calci/ELEMENTDIS | ELEMENTDIS]]
 
−
*[[Manuals/calci/ELEMENTINARRAY | ELEMENTINARRAY]]
 
 
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
 
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
−
*[[Manuals/calci/ENFORCEINTEGER | ENFORCEINTEGER]]
+
 
−
*[[Manuals/calci/ENFORCENATURAL | ENFORCENATURAL]]
+
===Financial1===
−
*[[Manuals/calci/ENFORCENEGATIVE | ENFORCENEGATIVE]]
+
*[[Manuals/calci/ACCRINT | ACCRINT]]
−
*[[Manuals/calci/ENFORCENEGATIVEINTEGER | ENFORCENEGATIVEINTEGER]]
+
*[[Manuals/calci/AMORLINC | AMORLINC]]
−
*[[Manuals/calci/ENFORCENEGZEROPOS | ENFORCENEGZEROPOS]]
+
*[[Manuals/calci/CAGR | CAGR]]
−
*[[Manuals/calci/ENFORCEPOSITIVE | ENFORCEPOSITIVE]]
+
*[[Manuals/calci/COUPDAYBS | COUPDAYBS]]
−
*[[Manuals/calci/ENFORCEPOSITIVEINTEGER | ENFORCEPOSITIVEINTEGER]]
+
*[[Manuals/calci/COUPDAYS | COUPDAYS]]
−
*[[Manuals/calci/ENFORCETYPE | ENFORCETYPE]]
+
*[[Manuals/calci/COUPDAYSNC | COUPDAYSNC]]
−
*[[Manuals/calci/ENFORCEZERO | ENFORCEZERO]]
+
*[[Manuals/calci/COUPNCD | COUPNCD]]
−
*[[Manuals/calci/EQS | EQS]]
+
*[[Manuals/calci/COUPNUM | COUPNUM]]
−
*[[Manuals/calci/EQUATION | EQUATION]]
+
*[[Manuals/calci/COUPPCD | COUPPCD]]
−
*[[Manuals/calci/ERROR | ERROR]]
+
*[[Manuals/calci/CUMIPMT | CUMIPMT]]
−
*[[Manuals/calci/ERRORTYPE | ERRORTYPE]]
+
*[[Manuals/calci/CUMPRINC | CUMPRINC]]
−
*[[Manuals/calci/ERRORTYPES | ERRORTYPES]]
+
*[[Manuals/calci/DB | DB]]
−
*[[Manuals/calci/ESCAPE | ESCAPE]]
+
*[[Manuals/calci/DDB | DDB]]
−
*[[Manuals/calci/EVALX | EVALX]]
+
*[[Manuals/calci/DISC | DISC]]
−
*[[Manuals/calci/EVENS | EVENS]]
+
*[[Manuals/calci/DOLLAR | DOLLAR]]
−
*[[Manuals/calci/EVENSET | EVENSET]]
+
*[[Manuals/calci/DOLLARDE | DOLLARDE]]
−
*[[Manuals/calci/EVENSUPTO | EVENSUPTO]]
+
*[[Manuals/calci/DOLLARFR | DOLLARFR]]
−
*[[Manuals/calci/EVERYSET | EVERYSET]]
+
*[[Manuals/calci/DURATION | DURATION]]
−
*[[Manuals/calci/EXEC | EXEC]]
+
*[[Manuals/calci/EFFECT | EFFECT]]
−
*[[Manuals/calci/EXPOF | EXPOF]]
+
*[[Manuals/calci/EFFECTBULGE | EFFECTBULGE]]
−
*[[Manuals/calci/EXPORTTO | EXPORTTO]]
+
*[[Manuals/calci/EURO | EURO]]
−
*[[Manuals/calci/EXPRESSMYOPINION | EXPRESSMYOPINION]]
+
*[[Manuals/calci/EUROCONVERT | EUROCONVERT]]
−
*[[Manuals/calci/EXPRESSUSERSOPINION | EXPRESSUSERSOPINION]]
+
*[[Manuals/calci/FV | FV]]
−
*[[Manuals/calci/EXTENT | EXTENT]]
+
*[[Manuals/calci/FVIF | FVIF]]
−
*[[Manuals/calci/EXTRACTNUMBERS | EXTRACTNUMBERS]]
+
*[[Manuals/calci/FVIFA | FVIFA]]
−
*[[Manuals/calci/EXTRACTTEXT | EXTRACTTEXT]]
+
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
−
*[[Manuals/calci/EYE | EYE]]
+
*[[Manuals/calci/INTRATE | INTRATE]]
−
*[[Manuals/calci/FACTORIAL | FACTORIAL]]
+
*[[Manuals/calci/IPMT | IPMT]]
−
*[[Manuals/calci/FACTS | FACTS]]
+
*[[Manuals/calci/IRR | IRR]]
−
*[[Manuals/calci/FACTUNTIL | FACTUNTIL]]
+
*[[Manuals/calci/ISPMT | ISPMT]]
−
*[[Manuals/calci/FAIL | FAIL]]
+
*[[Manuals/calci/LOGEST | LOGEST]]
−
*[[Manuals/calci/FALSE | FALSE]]
+
*[[Manuals/calci/MDURATION | MDURATION]]
−
*[[Manuals/calci/FALSEVALUE | FALSEVALUE]]
+
*[[Manuals/calci/MIRR | MIRR]]
−
*[[Manuals/calci/FALSEY | FALSEY]]
+
*[[Manuals/calci/NPER | NPER]]
−
*[[Manuals/calci/FDZ | FDZ]]
+
*[[Manuals/calci/NPV | NPV]]
−
*[[Manuals/calci/FEQ | FEQ]]
+
*[[Manuals/calci/PMT | PMT]]
−
*[[Manuals/calci/FIBONACCI | FIBONACCI]]
+
*[[Manuals/calci/PMTLISTING | PMTLISTING]]
−
*[[Manuals/calci/FIELDINDEX | FIELDINDEX]]
+
*[[Manuals/calci/PPMT | PPMT]]
−
*[[Manuals/calci/FIFTHOF | FIFTHOF]]
+
*[[Manuals/calci/PV | PV]]
−
*[[Manuals/calci/FILTER | FILTER]]
+
*[[Manuals/calci/PVEQUATION | PVEQUATION]]
−
*[[Manuals/calci/FINDUNIT | FINDUNIT]]
+
*[[Manuals/calci/PVIF | PVIF]]
−
*[[Manuals/calci/FIXCHARS | FIXCHARS]]
+
*[[Manuals/calci/PVIFA | PVIFA]]
−
*[[Manuals/calci/FIXEDBAD | FIXEDBAD]]
+
*[[Manuals/calci/RATE | RATE]]
−
*[[Manuals/calci/FLATTEN | FLATTEN]]
+
*[[Manuals/calci/RECEIVED | RECEIVED]]
−
*[[Manuals/calci/FLOORAT | FLOORAT]]
+
*[[Manuals/calci/TBILLEQ | TBILLEQ]]
−
*[[Manuals/calci/FLOYDSTRIANGLE | FLOYDSTRIANGLE]]
+
*[[Manuals/calci/TBILLPRICE | TBILLPRICE]]
−
*[[Manuals/calci/FORALL | FORALL]]
+
*[[Manuals/calci/TBILLYIELD | TBILLYIELD]]
−
*[[Manuals/calci/FORDOFUNCTIONS | FORDOFUNCTIONS]]
+
*[[Manuals/calci/USDOLLAR | USDOLLAR]]
−
*[[Manuals/calci/FOREACH | FOREACH]]
+
*[[Manuals/calci/XNPV | XNPV]]
−
*[[Manuals/calci/FORLOOP | FORLOOP]]
+
 
−
*[[Manuals/calci/FORMATRANGE | FORMATRANGE]]
+
===Financial2===
−
*[[Manuals/calci/FORMATTIME | FORMATTIME]]
+
*[[Manuals/calci/ACCRINTM | ACCRINTM]]
−
*[[Manuals/calci/FORMATWITHRANGES | FORMATWITHRANGES]]
+
*[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
−
*[[Manuals/calci/FORMULA | FORMULA]]
+
*[[Manuals/calci/NOMINAL | NOMINAL]]
−
*[[Manuals/calci/FORRESULTSONLY | FORRESULTSONLY]]
+
*[[Manuals/calci/ODDFPRICE | ODDFPRICE]]
−
*[[Manuals/calci/FORX | FORX]]
+
*[[Manuals/calci/ODDFYIELD | ODDFYIELD]]
−
*[[Manuals/calci/FORXX | FORXX]]
+
*[[Manuals/calci/ODDLPRICE | ODDLPRICE]]
−
*[[Manuals/calci/FORXXCOMBINATORIAL | FORXXCOMBINATORIAL]]
+
*[[Manuals/calci/ODDLYIELD | ODDLYIELD]]
−
*[[Manuals/calci/FORY | FORY]]
+
*[[Manuals/calci/OPTIONSECURITY | OPTIONSECURITY]]
−
*[[Manuals/calci/FOURTHOF | FOURTHOF]]
+
*[[Manuals/calci/PRICE | PRICE]]
−
*[[Manuals/calci/FOURTHROOT | FOURTHROOT]]
+
*[[Manuals/calci/PRICEDISC | PRICEDISC]]
−
*[[Manuals/calci/FRACTAL | FRACTAL]]
+
*[[Manuals/calci/PRICEMAT | PRICEMAT]]
−
*[[Manuals/calci/FRACTION | FRACTION]]
+
*[[Manuals/calci/PUTOPTION | PUTOPTION]]
−
*[[Manuals/calci/FROMTO | FROMTO]]
+
*[[Manuals/calci/SLN | SLN]]
−
*[[Manuals/calci/FROMTOADV | FROMTOADV]]
+
*[[Manuals/calci/SYD | SYD]]
−
*[[Manuals/calci/FROMTOGEOMETRIC | FROMTOGEOMETRIC]]
+
*[[Manuals/calci/VDB | VDB]]
−
*[[Manuals/calci/FUCTIONTOIMPLEMENT | FUCTIONTOIMPLEMENT]]
+
*[[Manuals/calci/XIRR | XIRR]]
−
*[[Manuals/calci/FUNCTIONFROMTEMPLATE | FUNCTIONFROMTEMPLATE]]
+
*[[Manuals/calci/YIELD | YIELD]]
−
*[[Manuals/calci/FUNCTIONOF | FUNCTIONOF]]
+
*[[Manuals/calci/YIELDDISC | YIELDDISC]]
−
*[[Manuals/calci/FUZZY | FUZZY]]
+
*[[Manuals/calci/YIELDMAT | YIELDMAT]]
−
*[[Manuals/calci/FVIF | FVIF]]
+
*[[Manuals/calci/YMXC | YMXC]]
−
*[[Manuals/calci/FVIFA | FVIFA]]
+
 
−
*[[Manuals/calci/GAMMAFUNCTION | GAMMAFUNCTION]]
+
===Geometry and Graph1===
−
*[[Manuals/calci/GCV | GCV]]
+
*[[Manuals/calci/BARCHART | BARCHART]]
−
*[[Manuals/calci/GDIM | GDIM]]
+
*[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
−
*[[Manuals/calci/GENERATEBOOLEAN | GENERATEBOOLEAN]]
+
*[[Manuals/calci/CHORDDIAGRAM | CHORDDIAGRAM]]
−
*[[Manuals/calci/GENERATEGRAPH | GENERATEGRAPH]]
+
*[[Manuals/calci/CHORDMATRIXDIAGRAM | CHORDMATRIXDIAGRAM]]
−
*[[Manuals/calci/GENERATEINTEGER | GENERATEINTEGER]]
+
*[[Manuals/calci/CIRCLE | CIRCLE]]
−
*[[Manuals/calci/GENERATENATURAL | GENERATENATURAL]]
+
*[[Manuals/calci/CIRCLEPACKING | CIRCLEPACKING]]
−
*[[Manuals/calci/GENERATENEGATIVE | GENERATENEGATIVE]]
+
*[[Manuals/calci/CIRCLEWITHTEXT | CIRCLEWITHTEXT]]
−
*[[Manuals/calci/GENERATENEGATIVEINTEGER | GENERATENEGATIVEINTEGER]]
+
*[[Manuals/calci/CUBE | CUBE]]
−
*[[Manuals/calci/GENERATENEGATIVENONZEROINTEGER | GENERATENEGATIVENONZEROINTEGER]]
+
*[[Manuals/calci/CUBEDEV | CUBEDEV]]
−
*[[Manuals/calci/GENERATENEGZEROPOS | GENERATENEGZEROPOS]]
+
*[[Manuals/calci/CURVE | CURVE]]
−
*[[Manuals/calci/GENERATENUMBER | GENERATENUMBER]]
+
*[[Manuals/calci/DRAW | DRAW]]
−
*[[Manuals/calci/GENERATEPOSITIVE | GENERATEPOSITIVE]]
+
*[[Manuals/calci/DRAWDATACURVE | DRAWDATACURVE]]
−
*[[Manuals/calci/GENERATEPOSITIVEINTEGER | GENERATEPOSITIVEINTEGER]]
+
*[[Manuals/calci/DRAWSHAPE | DRAWSHAPE]]
−
*[[Manuals/calci/GENERATEPOSITIVENONZEROINTEGER | GENERATEPOSITIVENONZEROINTEGER]]
+
*[[Manuals/calci/EDGEBUNDLING | EDGEBUNDLING]]
−
*[[Manuals/calci/GENERATESERIESSTRING | GENERATESERIESSTRING]]
+
*[[Manuals/calci/ELLIPSE | ELLIPSE]]
−
*[[Manuals/calci/GENERATESUDOKU | GENERATESUDOKU]]
+
*[[Manuals/calci/FROMTOGEOMETRIC | FROMTOGEOMETRIC]]
−
*[[Manuals/calci/GENERATEZERO | GENERATEZERO]]
+
*[[Manuals/calci/FRACTAL | FRACTAL]]
−
*[[Manuals/calci/GEOMETRICSERIES | GEOMETRICSERIES]]
+
*[[Manuals/calci/GEOMETRY | GEOMETRY]]
−
*[[Manuals/calci/GEOMETRY | GEOMETRY]]
+
*[[Manuals/calci/GRAPH | GRAPH]]
−
*[[Manuals/calci/GETCELLTD | GETCELLTD]]
+
*[[Manuals/calci/HYPOTENUSE | HYPOTENUSE]]
−
*[[Manuals/calci/GETCOLUMN | GETCOLUMN]]
+
*[[Manuals/calci/INQUADRANT | INQUADRANT]]
−
*[[Manuals/calci/GETCONVERSION | GETCONVERSION]]
+
*[[Manuals/calci/INQUADRANTSIGN | INQUADRANTSIGN]]
−
*[[Manuals/calci/GETFUNCTION | GETFUNCTION]]
+
*[[Manuals/calci/INQUADRANTTHETA | INQUADRANTTHETA]]
−
*[[Manuals/calci/GETFUNCTIONSET | GETFUNCTIONSET]]
+
*[[Manuals/calci/INTERCEPT | INTERCEPT]]
−
*[[Manuals/calci/GETGPS | GETGPS]]
+
*[[Manuals/calci/LINE | LINE]]
−
*[[Manuals/calci/GETJSON | GETJSON]]
+
*[[Manuals/calci/LISSAJOUS | LISSAJOUS]]
−
*[[Manuals/calci/GETLATLONG | GETLATLONG]]
+
*[[Manuals/calci/LISSAJOUSCURVE | LISSAJOUSCURVE]]
−
*[[Manuals/calci/GETLINE | GETLINE]]
+
*[[Manuals/calci/MAKEZCIRCLE | MAKEZCIRCLE]]
−
*[[Manuals/calci/GETNUMBERTAIL | GETNUMBERTAIL]]
+
*[[Manuals/calci/MANDELBROT | MANDELBROT]]
−
*[[Manuals/calci/GETREALORCOMPLEX | GETREALORCOMPLEX]]
+
*[[Manuals/calci/PIECHART | PIECHART]]
−
*[[Manuals/calci/GETROW | GETROW]]
+
*[[Manuals/calci/PLOT | PLOT]]
−
*[[Manuals/calci/GETSERIES | GETSERIES]]
+
*[[Manuals/calci/POINT | POINT]]
−
*[[Manuals/calci/GFUNCTION | GFUNCTION]]
+
*[[Manuals/calci/POINTAT | POINTAT]]
−
*[[Manuals/calci/GKMAPPING | GKMAPPING]]
+
*[[Manuals/calci/POLYGON | POLYGON]]
−
*[[Manuals/calci/GMAP | GMAP]]
+
*[[Manuals/calci/RECTANGLE | RECTANGLE]]
−
*[[Manuals/calci/GOALSEEK | GOALSEEK]]
+
*[[Manuals/calci/SHAPE | SHAPE]]
−
*[[Manuals/calci/GOTO | GOTO]]
+
*[[Manuals/calci/SLOPE | SLOPE]]
−
*[[Manuals/calci/GOV | GOV]]
+
*[[Manuals/calci/SOR | SOR]]
−
*[[Manuals/calci/GRAPH | GRAPH]]
+
*[[Manuals/calci/SORT | SORT]]
−
*[[Manuals/calci/GREEK | GREEK]]
+
*[[Manuals/calci/SPHERE | SPHERE]]
−
*[[Manuals/calci/GREEKARRAY | GREEKARRAY]]
+
*[[Manuals/calci/SQUARES | SQUARES]]
−
*[[Manuals/calci/GREEKS | GREEKS]]
+
*[[Manuals/calci/STAR | STAR]]
−
*[[Manuals/calci/GREGORIANDATE | GREGORIANDATE]]
+
*[[Manuals/calci/STARS | STARS]]
−
*[[Manuals/calci/GROUP | GROUP]]
+
*[[Manuals/calci/TETRA | TETRA]]
−
*[[Manuals/calci/GT | GT]]
+
*[[Manuals/calci/TETRAHEDRON | TETRAHEDRON]]
−
*[[Manuals/calci/GTE | GTE]]
+
*[[Manuals/calci/TETRAHEDRONDEV | TETRAHEDRONDEV]]
−
*[[Manuals/calci/HADAMARDPRODUCT | HADAMARDPRODUCT]]
+
*[[Manuals/calci/TRIANGLE | TRIANGLE]]
−
*[[Manuals/calci/HALFOF | HALFOF]]
+
*[[Manuals/calci/XYPOINT | XYPOINT]]
−
*[[Manuals/calci/HARMONICSERIES | HARMONICSERIES]]
+
 
−
*[[Manuals/calci/HEART | HEART]]
+
===Geometry and Graph2===
−
*[[Manuals/calci/HREF | HREF]]
+
*[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
−
*[[Manuals/calci/HTML | HTML]]
+
*[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
−
*[[Manuals/calci/HUNDRED | HUNDRED]]
+
*[[Manuals/calci/CLUSTERDENDROGRAM | CLUSTERDENDROGRAM]]
−
*[[Manuals/calci/HVLOOKUP | HVLOOKUP]]
+
*[[Manuals/calci/DRAGON | DRAGON]]
−
*[[Manuals/calci/IFNULL | IFNULL]]
+
*[[Manuals/calci/FD | FD]]
−
*[[Manuals/calci/IMAGE | IMAGE]]
+
*[[Manuals/calci/FDZ | FDZ]]
−
*[[Manuals/calci/IMAGEURL | IMAGEURL]]
+
*[[Manuals/calci/filegeometry | filegeometry]]
−
*[[Manuals/calci/IMCOSH | IMCOSH]]
+
*[[Manuals/calci/PLOTDEV | PLOTDEV]]
−
*[[Manuals/calci/IMCOT | IMCOT]]
+
*[[Manuals/calci/STEMANDLEAFPLOT | STEMANDLEAFPLOT]]
−
*[[Manuals/calci/IMCOTH | IMCOTH]]
+
*[[Manuals/calci/SURFACEGRAPH | SURFACEGRAPH]]
−
*[[Manuals/calci/IMCSC | IMCSC]]
+
*[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
−
*[[Manuals/calci/IMCSCH | IMCSCH]]
+
*[[Manuals/calci/TORUS | TORUS]]
−
*[[Manuals/calci/IMDIVTWO | IMDIVTWO]]
+
 
−
*[[Manuals/calci/IMG | IMG]]
+
===Information1===
−
*[[Manuals/calci/IMPRODUCTTWO | IMPRODUCTTWO]]
+
*[[Manuals/calci/APPLY | APPLY]]
−
*[[Manuals/calci/IMSEC | IMSEC]]
+
*[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
−
*[[Manuals/calci/IMSECH | IMSECH]]
+
*[[Manuals/calci/APPLYFUNCTIONTOELEMENTS | APPLYFUNCTIONTOELEMENTS]]
−
*[[Manuals/calci/IMSINH | IMSINH]]
+
*[[Manuals/calci/APPLYFUNCTIONTORANGE | APPLYFUNCTIONTORANGE]]
−
*[[Manuals/calci/IMSTRING | IMSTRING]]
+
*[[Manuals/calci/APPLYOF | APPLYOF]]
−
*[[Manuals/calci/IMSUBTWO | IMSUBTWO]]
+
*[[Manuals/calci/APPLYTOALLKEYS | APPLYTOALLKEYS]]
−
*[[Manuals/calci/IMSUMTWO | IMSUMTWO]]
+
*[[Manuals/calci/APPLYTOKEYS | APPLYTOKEYS]]
−
*[[Manuals/calci/IMTAN | IMTAN]]
+
*[[Manuals/calci/ATOZ | ATOZ]]
−
*[[Manuals/calci/IMTANH | IMTANH]]
+
*[[Manuals/calci/BADWORDS | BADWORDS]]
 +
*[[Manuals/calci/BG | BG]]
 +
*[[Manuals/calci/BILLION | BILLION]]
 +
*[[Manuals/calci/BOLD | BOLD]]
 +
*[[Manuals/calci/BOTTOM | BOTTOM]]
 +
*[[Manuals/calci/BOTTOMN | BOTTOMN]]
 +
*[[Manuals/calci/CALENDARPLOT | CALENDARPLOT]]
 +
*[[Manuals/calci/CAPITALLETTERS | CAPITALLETTERS]]
 +
*[[Manuals/calci/CELL | CELL]]
 +
*[[Manuals/calci/COMMENTGET | COMMENTGET]]
 +
*[[Manuals/calci/COMPARE | COMPARE]]
 +
*[[Manuals/calci/CONS | CONS]]
 +
*[[Manuals/calci/CONST | CONST]]
 +
*[[Manuals/calci/CONSTANTS | CONSTANTS]]
 +
*[[Manuals/calci/DE | DE]]
 +
*[[Manuals/calci/DECLARE | DECLARE]]
 +
*[[Manuals/calci/DECR | DECR]]
 +
*[[Manuals/calci/EXEC | EXEC]]
 +
*[[Manuals/calci/FORMATRANGE | FORMATRANGE]]
 +
*[[Manuals/calci/FORMATWITHRANGES | FORMATWITHRANGES]]
 +
*[[Manuals/calci/GDIM | GDIM]]
 +
*[[Manuals/calci/GOALSEEK | GOALSEEK]]
 +
*[[Manuals/calci/GOTO | GOTO]]
 +
*[[Manuals/calci/GOV | GOV]]
 +
*[[Manuals/calci/HEART | HEART]]
 +
*[[Manuals/calci/HREF | HREF]]
 +
*[[Manuals/calci/HTML | HTML]]
 +
*[[Manuals/calci/HYPERLINK | HYPERLINK]]
 +
*[[Manuals/calci/IN | IN]]
 
*[[Manuals/calci/INARRAY | INARRAY]]
 
*[[Manuals/calci/INARRAY | INARRAY]]
 
*[[Manuals/calci/INCR | INCR]]
 
*[[Manuals/calci/INCR | INCR]]
−
*[[Manuals/calci/INCREASING | INCREASING]]
+
*[[Manuals/calci/ISARRAY | ISARRAY]]
−
*[[Manuals/calci/INCREMENT | INCREMENT]]
+
*[[Manuals/calci/ISARRAYORSUCH | ISARRAYORSUCH]]
−
*[[Manuals/calci/INFO | INFO]]
 
−
*[[Manuals/calci/INQUADRANT | INQUADRANT]]
 
−
*[[Manuals/calci/INQUADRANTSIGN | INQUADRANTSIGN]]
 
−
*[[Manuals/calci/INQUADRANTTHETA | INQUADRANTTHETA]]
 
−
*[[Manuals/calci/INSET | INSET]]
 
−
*[[Manuals/calci/INTDIV | INTDIV]]
 
−
*[[Manuals/calci/INTEGERDIVISION | INTEGERDIVISION]]
 
−
*[[Manuals/calci/INTEGERS | INTEGERS]]
 
−
*[[Manuals/calci/INTEGRATE | INTEGRATE]]
 
−
*[[Manuals/calci/INTEGRATEFOR | INTEGRATEFOR]]
 
−
*[[Manuals/calci/INTEGRATEFORCORE | INTEGRATEFORCORE]]
 
−
*[[Manuals/calci/INTEGRATEUNTIL | INTEGRATEUNTIL]]
 
−
*[[Manuals/calci/INTERSECTION | INTERSECTION]]
 
−
*[[Manuals/calci/INTS | INTS]]
 
−
*[[Manuals/calci/INTSTWO | INTSTWO]]
 
−
*[[Manuals/calci/ISARRAY | ISARRAY]]
 
−
*[[Manuals/calci/ISARRAYORSUCH | ISARRAYORSUCH]]
 
 
*[[Manuals/calci/ISARRAYORSUCHNOTSTRING | ISARRAYORSUCHNOTSTRING]]
 
*[[Manuals/calci/ISARRAYORSUCHNOTSTRING | ISARRAYORSUCHNOTSTRING]]
 
*[[Manuals/calci/ISATOMICSYMBOL | ISATOMICSYMBOL]]
 
*[[Manuals/calci/ISATOMICSYMBOL | ISATOMICSYMBOL]]
 +
*[[Manuals/calci/ISBLANK | ISBLANK]]
 
*[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]]
 
*[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]]
 
*[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]]
 
*[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]]
 +
*[[Manuals/calci/ISCOMPOSITE | ISCOMPOSITE]]
 
*[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]]
 
*[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]]
 
*[[Manuals/calci/ISEMPTY | ISEMPTY]]
 
*[[Manuals/calci/ISEMPTY | ISEMPTY]]
Line 832: Line 807:
 
*[[Manuals/calci/ISERR | ISERR]]
 
*[[Manuals/calci/ISERR | ISERR]]
 
*[[Manuals/calci/ISERROR | ISERROR]]
 
*[[Manuals/calci/ISERROR | ISERROR]]
 +
*[[Manuals/calci/ISEVEN | ISEVEN]]
 +
*[[Manuals/calci/ISFALSE | ISFALSE]]
 
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]]
 
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]]
 
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]]
 
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]]
 
*[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]]
 
*[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]]
 
*[[Manuals/calci/ISINARRAY | ISINARRAY]]
 
*[[Manuals/calci/ISINARRAY | ISINARRAY]]
 +
*[[Manuals/calci/ISINTEGER | ISINTEGER]]
 +
*[[Manuals/calci/ISINTEGER#Safe_Integer | Safe Integer]]
 
*[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]]
 
*[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]]
 +
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]]
 
*[[Manuals/calci/ISLIKELYTYPE | ISLIKELYTYPE]]
 
*[[Manuals/calci/ISLIKELYTYPE | ISLIKELYTYPE]]
 
*[[Manuals/calci/ISLOCATION | ISLOCATION]]
 
*[[Manuals/calci/ISLOCATION | ISLOCATION]]
 +
*[[Manuals/calci/ISLOGICAL | ISLOGICAL]]
 
*[[Manuals/calci/ISLOWER | ISLOWER]]
 
*[[Manuals/calci/ISLOWER | ISLOWER]]
 
*[[Manuals/calci/ISMONTH | ISMONTH]]
 
*[[Manuals/calci/ISMONTH | ISMONTH]]
Line 845: Line 826:
 
*[[Manuals/calci/ISNULL | ISNULL]]
 
*[[Manuals/calci/ISNULL | ISNULL]]
 
*[[Manuals/calci/ISNULLLIKE | ISNULLLIKE]]
 
*[[Manuals/calci/ISNULLLIKE | ISNULLLIKE]]
 +
*[[Manuals/calci/ISNUMBER | ISNUMBER]]
 
*[[Manuals/calci/ISNUMBERSYMBOLS | ISNUMBERSYMBOLS]]
 
*[[Manuals/calci/ISNUMBERSYMBOLS | ISNUMBERSYMBOLS]]
 
*[[Manuals/calci/ISOBJECT | ISOBJECT]]
 
*[[Manuals/calci/ISOBJECT | ISOBJECT]]
 +
*[[Manuals/calci/ISODD | ISODD]]
 
*[[Manuals/calci/ISOPERATORSYMBOL | ISOPERATORSYMBOL]]
 
*[[Manuals/calci/ISOPERATORSYMBOL | ISOPERATORSYMBOL]]
 
*[[Manuals/calci/ISPERFECTNUMBER | ISPERFECTNUMBER]]
 
*[[Manuals/calci/ISPERFECTNUMBER | ISPERFECTNUMBER]]
 
*[[Manuals/calci/ISPOINTLIKE | ISPOINTLIKE]]
 
*[[Manuals/calci/ISPOINTLIKE | ISPOINTLIKE]]
 +
*[[Manuals/calci/ISPRIME | ISPRIME]]
 
*[[Manuals/calci/ISRANGEOBJECT | ISRANGEOBJECT]]
 
*[[Manuals/calci/ISRANGEOBJECT | ISRANGEOBJECT]]
 
*[[Manuals/calci/ISREF | ISREF]]
 
*[[Manuals/calci/ISREF | ISREF]]
Line 857: Line 841:
 
*[[Manuals/calci/ISSUBSET | ISSUBSET]]
 
*[[Manuals/calci/ISSUBSET | ISSUBSET]]
 
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]]
 
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]]
 +
*[[Manuals/calci/ISTEXT | ISTEXT]]
 +
*[[Manuals/calci/ISTRUE | ISTRUE]]
 
*[[Manuals/calci/ISVECTOR | ISVECTOR]]
 
*[[Manuals/calci/ISVECTOR | ISVECTOR]]
 
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]]
 
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]]
 
*[[Manuals/calci/ITALIC | ITALIC]]
 
*[[Manuals/calci/ITALIC | ITALIC]]
−
*[[Manuals/calci/ITERATE | ITERATE]]
 
−
*[[Manuals/calci/ITERATENR | ITERATENR]]
 
 
*[[Manuals/calci/JIS | JIS]]
 
*[[Manuals/calci/JIS | JIS]]
−
*[[Manuals/calci/JOIN | JOIN]]
+
*[[Manuals/calci/KEYINARRAY | KEYINARRAY]]
−
*[[Manuals/calci/JOINSET | JOINSET]]
 
−
*[[Manuals/calci/JPARTITION | JPARTITION]]
 
−
*[[Manuals/calci/JULIANDATE | JULIANDATE]]
 
−
*[[Manuals/calci/JUPITER | JUPITER]]
 
−
*[[Manuals/calci/KEEPCOLUMNS | KEEPCOLUMNS]]
 
−
*[[Manuals/calci/KEYINARRAY | KEYINARRAY]]
 
 
*[[Manuals/calci/KEYS | KEYS]]
 
*[[Manuals/calci/KEYS | KEYS]]
 
*[[Manuals/calci/KEYTAGS | KEYTAGS]]
 
*[[Manuals/calci/KEYTAGS | KEYTAGS]]
−
*[[Manuals/calci/KFUNCTION | KFUNCTION]]
 
 
*[[Manuals/calci/KNOW | KNOW]]
 
*[[Manuals/calci/KNOW | KNOW]]
−
*[[Manuals/calci/KRONECKERPRODUCT | KRONECKERPRODUCT]]
 
−
*[[Manuals/calci/KSTESTCORE | KSTESTCORE]]
 
−
*[[Manuals/calci/KSTESTEXPONENTIAL | KSTESTEXPONENTIAL]]
 
−
*[[Manuals/calci/LAMDASELF | LAMDASELF]]
 
−
*[[Manuals/calci/LAST | LAST]]
 
−
*[[Manuals/calci/LATITUDE | LATITUDE]]
 
 
*[[Manuals/calci/LAZYOBJECT | LAZYOBJECT]]
 
*[[Manuals/calci/LAZYOBJECT | LAZYOBJECT]]
 
*[[Manuals/calci/LAZYRANGE | LAZYRANGE]]
 
*[[Manuals/calci/LAZYRANGE | LAZYRANGE]]
 
*[[Manuals/calci/LAZYSERIES | LAZYSERIES]]
 
*[[Manuals/calci/LAZYSERIES | LAZYSERIES]]
−
*[[Manuals/calci/LBSTAR | LBSTAR]]
 
−
*[[Manuals/calci/LETTERS | LETTERS]]
 
−
*[[Manuals/calci/LEVENESTESTOLD | LEVENESTESTOLD]]
 
−
*[[Manuals/calci/LFN | LFN]]
 
−
*[[Manuals/calci/LGSTAR | LGSTAR]]
 
 
*[[Manuals/calci/LIKE | LIKE]]
 
*[[Manuals/calci/LIKE | LIKE]]
−
*[[Manuals/calci/LINEAREQUATION | LINEAREQUATION]]
+
*[[Manuals/calci/LOAD | LOAD]]
−
*[[Manuals/calci/LINKEDLIST | LINKEDLIST]]
+
*[[Manuals/calci/LOADSEMANTICINFO | LOADSEMANTICINFO]]
−
*[[Manuals/calci/LINKNODE | LINKNODE]]
+
*[[Manuals/calci/LOL | LOL]]
−
*[[Manuals/calci/LISPLIST | LISPLIST]]
+
*[[Manuals/calci/MAP | MAP]]
−
*[[Manuals/calci/LISSAJOUS | LISSAJOUS]]
+
*[[Manuals/calci/MAPLISP | MAPLISP]]
−
*[[Manuals/calci/LISSAJOUSCURVE | LISSAJOUSCURVE]]
+
*[[Manuals/calci/MAPTABLE | MAPTABLE]]
−
*[[Manuals/calci/LISTALL | LISTALL]]
+
*[[Manuals/calci/MATCH | MATCH]]
−
*[[Manuals/calci/LISTCOLUMNLABELS | LISTCOLUMNLABELS]]
+
*[[Manuals/calci/MILLION | MILLION]]
−
*[[Manuals/calci/LISTCOLUMNS | LISTCOLUMNS]]
+
*[[Manuals/calci/MROWAGGREGATE | MROWAGGREGATE]]
−
*[[Manuals/calci/LISTROWS | LISTROWS]]
+
*[[Manuals/calci/MROWDUPLICATE | MROWDUPLICATE]]
−
*[[Manuals/calci/LISTUNIQUE | LISTUNIQUE]]
+
*[[Manuals/calci/MROWOP | MROWOP]]
−
*[[Manuals/calci/LISTV | LISTV]]
+
*[[Manuals/calci/NA | NA]]
−
*[[Manuals/calci/LNSTAR | LNSTAR]]
+
*[[Manuals/calci/NE | NE]]
−
*[[Manuals/calci/LOAD | LOAD]]
+
*[[Manuals/calci/NES | NES]]
−
*[[Manuals/calci/LOADSEMANTICINFO | LOADSEMANTICINFO]]
+
*[[Manuals/calci/NEST | NEST]]
−
*[[Manuals/calci/LOGSTAR | LOGSTAR]]
+
*[[Manuals/calci/NIL | NIL]]
−
*[[Manuals/calci/LOGVALUES | LOGVALUES]]
+
*[[Manuals/calci/NINTHOF | NINTHOF]]
−
*[[Manuals/calci/LOL | LOL]]
+
*[[Manuals/calci/NO | NO]]
−
*[[Manuals/calci/LONGITUDE | LONGITUDE]]
+
*[[Manuals/calci/NODE | NODE]]
−
*[[Manuals/calci/LOOPMEDIA | LOOPMEDIA]]
+
*[[Manuals/calci/NODES | NODES]]
−
*[[Manuals/calci/LOWERCASE | LOWERCASE]]
+
*[[Manuals/calci/NODESX | NODESX]]
−
*[[Manuals/calci/LTE | LTE]]
+
*[[Manuals/calci/NODET | NODET]]
−
*[[Manuals/calci/LUDECOMPOSITION | LUDECOMPOSITION]]
+
*[[Manuals/calci/NODEX | NODEX]]
−
*[[Manuals/calci/LUDEV | LUDEV]]
+
*[[Manuals/calci/NONAME | NONAME]]
−
*[[Manuals/calci/LZ | LZ]]
+
*[[Manuals/calci/NONE | NONE]]
−
*[[Manuals/calci/LZWCOMPRESS | LZWCOMPRESS]]
+
*[[Manuals/calci/NUMERICARRAY | NUMERICARRAY]]
−
*[[Manuals/calci/LZWDECOMPRESS | LZWDECOMPRESS]]
+
*[[Manuals/calci/OBJ | OBJ]]
−
*[[Manuals/calci/MAKECANVAS | MAKECANVAS]]
+
*[[Manuals/calci/OBJECT | OBJECT]]
−
*[[Manuals/calci/MAKECOMPLEXIMINUS | MAKECOMPLEXIMINUS]]
+
*[[Manuals/calci/OFF | OFF]]
−
*[[Manuals/calci/MAKECOMPLEXIMINUSSIMPLE | MAKECOMPLEXIMINUSSIMPLE]]
+
*[[Manuals/calci/OFFSET | OFFSET]]
−
*[[Manuals/calci/MAKECOMPLEXIPLUS | MAKECOMPLEXIPLUS]]
+
*[[Manuals/calci/OK | OK]]
−
*[[Manuals/calci/MAKECOMPLEXISIMPLE | MAKECOMPLEXISIMPLE]]
+
*[[Manuals/calci/OLDX| OLDX]]
−
*[[Manuals/calci/MAKEFRACTION | MAKEFRACTION]]
+
*[[Manuals/calci/ON | ON]]
−
*[[Manuals/calci/MAKEFUNCTIONARRAY | MAKEFUNCTIONARRAY]]
+
*[[Manuals/calci/OPF | OPF]]
−
*[[Manuals/calci/MAKEFUNCTIONSIGNATURECALL | MAKEFUNCTIONSIGNATURECALL]]
+
*[[Manuals/calci/OPFSTR | OPFSTR]]
−
*[[Manuals/calci/MAKELISTS | MAKELISTS]]
+
*[[Manuals/calci/PFX | PFX]]
−
*[[Manuals/calci/MAKEMAP | MAKEMAP]]
+
*[[Manuals/calci/PIGEN | PIGEN]]
−
*[[Manuals/calci/MAKEPAIR | MAKEPAIR]]
+
*[[Manuals/calci/PIVOT | PIVOT]]
−
*[[Manuals/calci/MAKERSS | MAKERSS]]
+
*[[Manuals/calci/RADIALTREE | RADIALTREE]]
−
*[[Manuals/calci/MAKESUBTOTAL | MAKESUBTOTAL]]
+
*[[Manuals/calci/SQL | SQL]]
−
*[[Manuals/calci/MAKETOLZWIMAGE | MAKETOLZWIMAGE]]
+
*[[Manuals/calci/SYMBOLFILTER | SYMBOLFILTER]]
−
*[[Manuals/calci/MAKEUNITVALUE | MAKEUNITVALUE]]
+
*[[Manuals/calci/SYMBOLIC | SYMBOLIC]]
−
*[[Manuals/calci/MAKEZCIRCLE | MAKEZCIRCLE]]
+
*[[Manuals/calci/SYMBOLNUMBER | SYMBOLNUMBER]]
−
*[[Manuals/calci/MANDELBROT | MANDELBROT]]
+
*[[Manuals/calci/TABLE | TABLE]]
−
*[[Manuals/calci/MAP | MAP]]
+
*[[Manuals/calci/TABLEADDROW | TABLEADDROW]]
−
*[[Manuals/calci/MAPLISP | MAPLISP]]
+
*[[Manuals/calci/TABLEARRAY | TABLEARRAY]]
−
*[[Manuals/calci/MAPTABLE | MAPTABLE]]
+
*[[Manuals/calci/TABLES | TABLES]]
−
*[[Manuals/calci/MARKUNITNATURE | MARKUNITNATURE]]
+
*[[Manuals/calci/TABULATE | TABULATE]]
−
*[[Manuals/calci/MARQUEE | MARQUEE]]
+
*[[Manuals/calci/TABULATEFORPIVOT | TABULATEFORPIVOT]]
−
*[[Manuals/calci/MARS | MARS]]
+
*[[Manuals/calci/TAGS | TAGS]]
−
*[[Manuals/calci/MASS | MASS]]
+
*[[Manuals/calci/THING | THING]]
−
*[[Manuals/calci/MATRIXADD | MATRIXADD]]
+
*[[Manuals/calci/THINK | THINK]]
−
*[[Manuals/calci/MATRIXADJOINT | MATRIXADJOINT]]
+
*[[Manuals/calci/TRUTHY | TRUTHY]]
−
*[[Manuals/calci/MATRIXAPPENDCOLUMNS | MATRIXAPPENDCOLUMNS]]
+
*[[Manuals/calci/UNDERSTAND | UNDERSTAND]]
−
*[[Manuals/calci/MATRIXAPPENDROWS | MATRIXAPPENDROWS]]
+
*[[Manuals/calci/UNDERSTANDSTRING | UNDERSTANDSTRING]]
−
*[[Manuals/calci/MATRIXASSIGN | MATRIXASSIGN]]
+
*[[Manuals/calci/UNESCAPE | UNESCAPE]]
−
*[[Manuals/calci/MATRIXASSIGNOBJECT | MATRIXASSIGNOBJECT]]
+
*[[Manuals/calci/UNICODESYMBOL | UNICODESYMBOL]]
−
*[[Manuals/calci/MATRIXASSIGNTORIGHT | MATRIXASSIGNTORIGHT]]
+
*[[Manuals/calci/UNK | UNK]]
−
*[[Manuals/calci/MATRIXCLONE | MATRIXCLONE]]
+
*[[Manuals/calci/UNKNOWN | UNKNOWN]]
−
*[[Manuals/calci/MATRIXCOLUMN | MATRIXCOLUMN]]
+
*[[Manuals/calci/UNQUOTE | UNQUOTE]]
−
*[[Manuals/calci/MATRIXCOPY | MATRIXCOPY]]
+
*[[Manuals/calci/XDY | XDY]]
−
*[[Manuals/calci/MATRIXDECOMPOSE | MATRIXDECOMPOSE]]
+
*[[Manuals/calci/XML | XML]]
−
*[[Manuals/calci/MATRIXDETERMINANT | MATRIXDETERMINANT]]
+
*[[Manuals/calci/XMLCALL | XMLCALL]]
−
*[[Manuals/calci/MATRIXDIAGONAL | MATRIXDIAGONAL]]
+
*[[Manuals/calci/YES | YES]]
−
*[[Manuals/calci/MATRIXDIAGONALPRODUCT | MATRIXDIAGONALPRODUCT]]
+
*[[Manuals/calci/YUP | YUP]]
−
*[[Manuals/calci/MATRIXDIVIDE | MATRIXDIVIDE]]
+
 
−
*[[Manuals/calci/MATRIXDIVPARTS | MATRIXDIVPARTS]]
+
===Information2===
−
*[[Manuals/calci/MATRIXEQUAL | MATRIXEQUAL]]
+
*[[Manuals/calci/ACRONYM | ACRONYM]]
−
*[[Manuals/calci/MATRIXFLIP | MATRIXFLIP]]
+
*[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
−
*[[Manuals/calci/MATRIXIDENTITY | MATRIXIDENTITY]]
+
*[[Manuals/calci/BAHTTEXT | BAHTTEXT]]
−
*[[Manuals/calci/MATRIXINTDIV | MATRIXINTDIV]]
+
*[[Manuals/calci/BYID | BYID]]
−
*[[Manuals/calci/MATRIXINVERSE | MATRIXINVERSE]]
+
*[[Manuals/calci/CALLLISP | CALLLISP]]
−
*[[Manuals/calci/MATRIXJOIN | MATRIXJOIN]]
+
*[[Manuals/calci/CALLOPTION | CALLOPTION]]
−
*[[Manuals/calci/MATRIXLATTICEMERGE | MATRIXLATTICEMERGE]]
+
*[[Manuals/calci/CALLSQL | CALLSQL]]
−
*[[Manuals/calci/MATRIXMINUS | MATRIXMINUS]]
+
*[[Manuals/calci/CANVASIMAGE | CANVASIMAGE]]
−
*[[Manuals/calci/MATRIXMOD | MATRIXMOD]]
+
*[[Manuals/calci/COALESCE | COALESCE]]
−
*[[Manuals/calci/MATRIXMULTIPLY | MATRIXMULTIPLY]]
+
*[[Manuals/calci/CONTAINS | CONTAINS]]
−
*[[Manuals/calci/MATRIXNEGATE | MATRIXNEGATE]]
+
*[[Manuals/calci/CONTAINVISUALLY | CONTAINVISUALLY]]
−
*[[Manuals/calci/MATRIXNOTEQUAL | MATRIXNOTEQUAL]]
+
*[[Manuals/calci/EXPORTTO | EXPORTTO]]
−
*[[Manuals/calci/MATRIXPACK | MATRIXPACK]]
+
*[[Manuals/calci/EXPRESSMYOPINION | EXPRESSMYOPINION]]
−
*[[Manuals/calci/MATRIXPLUS | MATRIXPLUS]]
+
*[[Manuals/calci/EXPRESSUSERSOPINION | EXPRESSUSERSOPINION]]
−
*[[Manuals/calci/MATRIXPOWER | MATRIXPOWER]]
+
*[[Manuals/calci/MODEL | MODEL]]
−
*[[Manuals/calci/MATRIXPRODUCT | MATRIXPRODUCT]]
+
*[[Manuals/calci/OCCURANCES | OCCURANCES]]
−
*[[Manuals/calci/MATRIXRANK | MATRIXRANK]]
+
*[[Manuals/calci/PARTITIONP | PARTITIONP]]
−
*[[Manuals/calci/MATRIXREPLACECOLUMN | MATRIXREPLACECOLUMN]]
+
*[[Manuals/calci/PARTITIONTREE | PARTITIONTREE]]
−
*[[Manuals/calci/MATRIXREVERSE | MATRIXREVERSE]]
+
*[[Manuals/calci/PARTP | PARTP]]
−
*[[Manuals/calci/MATRIXROTATE | MATRIXROTATE]]
+
*[[Manuals/calci/PFX | PFX]]
−
*[[Manuals/calci/MATRIXROW | MATRIXROW]]
+
*[[Manuals/calci/READFROMLZWIMAGE | READFROMLZWIMAGE]]
−
*[[Manuals/calci/MATRIXSCALARADD | MATRIXSCALARADD]]
+
*[[Manuals/calci/SDIM | SDIM]]
−
*[[Manuals/calci/MATRIXSCALARDIVIDE | MATRIXSCALARDIVIDE]]
+
*[[Manuals/calci/SOSZ | SOSZ]]
−
*[[Manuals/calci/MATRIXSCALAREXP | MATRIXSCALAREXP]]
+
*[[Manuals/calci/SOT | SOT]]
−
*[[Manuals/calci/MATRIXSCALARLN | MATRIXSCALARLN]]
+
*[[Manuals/calci/SOV | SOV]]
−
*[[Manuals/calci/MATRIXSCALARLOG | MATRIXSCALARLOG]]
+
*[[Manuals/calci/SOW | SOW]]
−
*[[Manuals/calci/MATRIXSCALARMULTIPLY | MATRIXSCALARMULTIPLY]]
+
*[[Manuals/calci/SOWH | SOWH]]
−
*[[Manuals/calci/MATRIXSCALAROPERATION | MATRIXSCALAROPERATION]]
+
*[[Manuals/calci/SOZ | SOZ]]
−
*[[Manuals/calci/MATRIXSCALARPOWER | MATRIXSCALARPOWER]]
+
*[[Manuals/calci/TOSIMPLEARRAY | TOSIMPLEARRAY]]
−
*[[Manuals/calci/MATRIXSCALARSQRT | MATRIXSCALARSQRT]]
+
*[[Manuals/calci/TRIGGEREVENT | TRIGGEREVENT]]
−
*[[Manuals/calci/MATRIXSCALARSUBTRACT | MATRIXSCALARSUBTRACT]]
+
*[[Manuals/calci/TSV | TSV]]
−
*[[Manuals/calci/MATRIXSTRING | MATRIXSTRING]]
+
*[[Manuals/calci/TTYL | TTYL]]
−
*[[Manuals/calci/MATRIXSUBTRACT | MATRIXSUBTRACT]]
+
*[[Manuals/calci/URLEXPAND | URLEXPAND]]
−
*[[Manuals/calci/MATRIXSYMMETRIC | MATRIXSYMMETRIC]]
+
*[[Manuals/calci/URLFRAMEEXPAND | URLFRAMEEXPAND]]
−
*[[Manuals/calci/MATRIXTENSORPRODUCT | MATRIXTENSORPRODUCT]]
+
*[[Manuals/calci/URLLIST | URLLIST]]
−
*[[Manuals/calci/MATRIXTRACE | MATRIXTRACE]]
+
*[[Manuals/calci/URLOBJECT | URLOBJECT]]
−
*[[Manuals/calci/MATRIXTRANSPOSE | MATRIXTRANSPOSE]]
+
*[[Manuals/calci/URLS | URLS]]
−
*[[Manuals/calci/MATRIXTYPE | MATRIXTYPE]]
+
*[[Manuals/calci/WHOISUSER | WHOISUSER]]
−
*[[Manuals/calci/MATRIXWITH | MATRIXWITH]]
+
*[[Manuals/calci/XFUNCTIONAT | XFUNCTIONAT]]
−
*[[Manuals/calci/MATRIXZERO | MATRIXZERO]]
+
*[[Manuals/calci/XMLDEPTH | XMLDEPTH]]
−
*[[Manuals/calci/MAXIF | MAXIF]]
+
*[[Manuals/calci/XMLSET | XMLSET]]
−
*[[Manuals/calci/MCOLAGGREGATE | MCOLAGGREGATE]]
+
*[[Manuals/calci/XMLTOTABLE | XMLTOTABLE]]
−
*[[Manuals/calci/MCOLDUPLICATE | MCOLDUPLICATE]]
+
*[[Manuals/calci/XMLVALUES | XMLVALUES]]
−
*[[Manuals/calci/MCOLOP | MCOLOP]]
+
*[[Manuals/calci/XMY | XMY]]
−
*[[Manuals/calci/MCORREL | MCORREL]]
+
 
−
*[[Manuals/calci/MEDIANIF | MEDIANIF]]
+
===Logical===
−
*[[Manuals/calci/MEQUAL | MEQUAL]]
+
*[[Manuals/calci/BITAND | BITAND]]
−
*[[Manuals/calci/MERCURY | MERCURY]]
+
*[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
−
*[[Manuals/calci/MERGEIMAGES | MERGEIMAGES]]
+
*[[Manuals/calci/BITNOT | BITNOT]]
−
*[[Manuals/calci/MIDDLE | MIDDLE]]
+
*[[Manuals/calci/BITOR | BITOR]]
−
*[[Manuals/calci/MIDN | MIDN]]
+
*[[Manuals/calci/BITRSHIFT | BITRSHIFT]]
−
*[[Manuals/calci/MILLION | MILLION]]
+
*[[Manuals/calci/BITRSHIFTZ | BITRSHIFTZ]]
−
*[[Manuals/calci/MINIF | MINIF]]
+
*[[Manuals/calci/BITXOR | BITXOR]]
−
*[[Manuals/calci/MINMAX | MINMAX]]
+
*[[Manuals/calci/FALSE | FALSE]]
−
*[[Manuals/calci/MINUS | MINUS]]
+
*[[Manuals/calci/FALSEVALUE | FALSEVALUE]]
−
*[[Manuals/calci/MINUSOF | MINUSOF]]
+
*[[Manuals/calci/FALSEY | FALSEY]]
−
*[[Manuals/calci/MIXEDCASE | MIXEDCASE]]
+
*[[Manuals/calci/IF | IF]]
−
*[[Manuals/calci/MLANGUAGELOOKUP | MLANGUAGELOOKUP]]
+
*[[Manuals/calci/IFNULL | IFNULL]]
−
*[[Manuals/calci/MODBY | MODBY]]
+
*[[Manuals/calci/NOT | NOT]]
−
*[[Manuals/calci/MODEIF | MODEIF]]
+
*[[Manuals/calci/NOTOK | NOTOK]]
−
*[[Manuals/calci/MODEL | MODEL]]
+
*[[Manuals/calci/OR | OR]]
−
*[[Manuals/calci/MODWITH | MODWITH]]
+
*[[Manuals/calci/TRUE | TRUE]]
−
*[[Manuals/calci/MONTHEND | MONTHEND]]
+
*[[Manuals/calci/TRUEVALUE | TRUEVALUE]]
−
*[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]]
+
 
−
*[[Manuals/calci/MONTHS | MONTHS]]
+
===Database and List Management1===
−
*[[Manuals/calci/MONTHSTRING | MONTHSTRING]]
+
*[[Manuals/calci/DAVERAGE | DAVERAGE]]
−
*[[Manuals/calci/MOON | MOON]]
+
*[[Manuals/calci/DCOUNT | DCOUNT]]
−
*[[Manuals/calci/MOP | MOP]]
+
*[[Manuals/calci/DCOUNTA | DCOUNTA]]
−
*[[Manuals/calci/MOPWITH | MOPWITH]]
+
*[[Manuals/calci/DGET | DGET]]
−
*[[Manuals/calci/MOPWITHEQ | MOPWITHEQ]]
+
*[[Manuals/calci/DMAX | DMAX]]
−
*[[Manuals/calci/MOPWITHFEQ | MOPWITHFEQ]]
+
*[[Manuals/calci/DMIN | DMIN]]
−
*[[Manuals/calci/MOPWITHGT | MOPWITHGT]]
+
*[[Manuals/calci/DSTDEV | DSTDEV]]
−
*[[Manuals/calci/MOPWITHGTE | MOPWITHGTE]]
+
*[[Manuals/calci/DSTDEVP | DSTDEVP]]
−
*[[Manuals/calci/MOPWITHLT | MOPWITHLT]]
+
*[[Manuals/calci/DSUM | DSUM]]
−
*[[Manuals/calci/MOPWITHLTE | MOPWITHLTE]]
+
*[[Manuals/calci/DSV | DSV]]
−
*[[Manuals/calci/MOPWITHMOD | MOPWITHMOD]]
+
*[[Manuals/calci/DVAR | DVAR]]
−
*[[Manuals/calci/MOPWITHNE | MOPWITHNE]]
+
*[[Manuals/calci/DVARP | DVARP]]
−
*[[Manuals/calci/MOPWITHPOWER | MOPWITHPOWER]]
+
 
−
*[[Manuals/calci/MOPX | MOPX]]
+
===Database and List Management2===
−
*[[Manuals/calci/MPEARSON | MPEARSON]]
+
*[[Manuals/calci/DBPEDIA | DBPEDIA]]
−
*[[Manuals/calci/MROWAGGREGATE | MROWAGGREGATE]]
+
*[[Manuals/calci/DIAG | DIAG]]
−
*[[Manuals/calci/MROWDUPLICATE | MROWDUPLICATE]]
+
*[[Manuals/calci/DISPLAYXML | DISPLAYXML]]
−
*[[Manuals/calci/MROWOP | MROWOP]]
+
*[[Manuals/calci/DOBY | DOBY]]
−
*[[Manuals/calci/MRSQ | MRSQ]]
+
*[[Manuals/calci/DOCALLAFTER | DOCALLAFTER]]
−
*[[Manuals/calci/MULTIPLES | MULTIPLES]]
+
*[[Manuals/calci/DOEFFECT | DOEFFECT]]
−
*[[Manuals/calci/MULTIPLESOF | MULTIPLESOF]]
+
*[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
−
*[[Manuals/calci/MULTIPLESTWO | MULTIPLESTWO]]
+
 
−
*[[Manuals/calci/MULTIPLY | MULTIPLY]]
+
===Lookup and Reference1===
−
*[[Manuals/calci/MULTIPLYBY | MULTIPLYBY]]
+
*[[Manuals/calci/ADDRESS | ADDRESS]]
−
*[[Manuals/calci/MULTIPLYWITH | MULTIPLYWITH]]
+
*[[Manuals/calci/AGE | AGE]]
−
*[[Manuals/calci/NEGATE | NEGATE]]
+
*[[Manuals/calci/AREAS | AREAS]]
−
*[[Manuals/calci/NEGATIVE | NEGATIVE]]
+
*[[Manuals/calci/BEEP | BEEP]]
−
*[[Manuals/calci/NEPTUNE | NEPTUNE]]
+
*[[Manuals/calci/CHOOSE | CHOOSE]]
−
*[[Manuals/calci/NEWCALCI | NEWCALCI]]
+
*[[Manuals/calci/COLORS | COLORS]]
−
*[[Manuals/calci/NEWFUNCTIONNAME | NEWFUNCTIONNAME]]
+
*[[Manuals/calci/COLUMN | COLUMN]]
−
*[[Manuals/calci/NEXTPOWER | NEXTPOWER]]
+
*[[Manuals/calci/COLUMNS | COLUMNS]]
−
*[[Manuals/calci/NIL | NIL]]
+
*[[Manuals/calci/COLUMNWITH | COLUMNWITH]]
−
*[[Manuals/calci/NINTHOF | NINTHOF]]
+
*[[Manuals/calci/COLWITH | COLWITH]]
−
*[[Manuals/calci/NODE | NODE]]
+
*[[Manuals/calci/DONOTHING | DONOTHING]]
−
*[[Manuals/calci/NODES | NODES]]
+
*[[Manuals/calci/DOSQL | DOSQL]]
−
*[[Manuals/calci/NODESX | NODESX]]
+
*[[Manuals/calci/DROP | DROP]]
−
*[[Manuals/calci/NODET | NODET]]
+
*[[Manuals/calci/DUPLICATE | DUPLICATE]]
−
*[[Manuals/calci/NODEX | NODEX]]
+
*[[Manuals/calci/FIELDINDEX | FIELDINDEX]]
−
*[[Manuals/calci/NOK | NOK]]
+
*[[Manuals/calci/FILTER | FILTER]]
−
*[[Manuals/calci/NONAME | NONAME]]
+
*[[Manuals/calci/FORMULA | FORMULA]]
−
*[[Manuals/calci/NONE | NONE]]
+
*[[Manuals/calci/FORRESULTSONLY | FORRESULTSONLY]]
−
*[[Manuals/calci/NONFALSEVALUE | NONFALSEVALUE]]
+
*[[Manuals/calci/FUCTIONTOIMPLEMENT | FUCTIONTOIMPLEMENT]]
−
*[[Manuals/calci/NONNEGATIVE | NONNEGATIVE]]
+
*[[Manuals/calci/FUNC | FUNC]]
−
*[[Manuals/calci/NONPOSITIVE | NONPOSITIVE]]
+
*[[Manuals/calci/FUNCT | FUNCT]]
−
*[[Manuals/calci/NONZERO | NONZERO]]
+
*[[Manuals/calci/FUNCTIONFROMTEMPLATE | FUNCTIONFROMTEMPLATE]]
−
*[[Manuals/calci/NONZEROVALUE | NONZEROVALUE]]
+
*[[Manuals/calci/FUNCTIONOF | FUNCTIONOF]]
−
*[[Manuals/calci/NOPE | NOPE]]
+
*[[Manuals/calci/FUZZY | FUZZY]]
−
*[[Manuals/calci/NORMALDISTRIBUTED | NORMALDISTRIBUTED]]
+
*[[Manuals/calci/GETCOLUMN | GETCOLUMN]]
−
*[[Manuals/calci/NOTHING | NOTHING]]
+
*[[Manuals/calci/GETCONVERSION | GETCONVERSION]]
−
*[[Manuals/calci/NOTOK | NOTOK]]
+
*[[Manuals/calci/GETFUNCTION | GETFUNCTION]]
−
*[[Manuals/calci/NOW | NOW]]
+
*[[Manuals/calci/GETFUNCTIONSET | GETFUNCTIONSET]]
−
*[[Manuals/calci/NQUEENS | NQUEENS]]
+
*[[Manuals/calci/GETGPS | GETGPS]]
−
*[[Manuals/calci/NTHELEMENT | NTHELEMENT]]
+
*[[Manuals/calci/GETJSON | GETJSON]]
−
*[[Manuals/calci/NTHROOT | NTHROOT]]
+
*[[Manuals/calci/GETLINE | GETLINE]]
−
*[[Manuals/calci/NUB | NUB]]
+
*[[Manuals/calci/GETNUMBERTAIL | GETNUMBERTAIL]]
−
*[[Manuals/calci/NULL | NULL]]
+
*[[Manuals/calci/GETREALORCOMPLEX | GETREALORCOMPLEX]]
−
*[[Manuals/calci/NULLIF | NULLIF]]
+
*[[Manuals/calci/GETROW | GETROW]]
 +
*[[Manuals/calci/GETSERIES | GETSERIES]]
 +
*[[Manuals/calci/GMAP | GMAP]]
 +
*[[Manuals/calci/GOALSEEK | GOALSEEK]]
 +
*[[Manuals/calci/GROUP | GROUP]]
 +
*[[Manuals/calci/HLOOKUP | HLOOKUP]]
 +
*[[Manuals/calci/HVLOOKUP | HVLOOKUP]]
 +
*[[Manuals/calci/INDEX | INDEX]]
 +
*[[Manuals/calci/INDIRECT | INDIRECT]]
 +
*[[Manuals/calci/INFO | INFO]]
 +
*[[Manuals/calci/INTEG | INTEG]]
 +
*[[Manuals/calci/LISTCOLUMNLABELS | LISTCOLUMNLABELS]]
 +
*[[Manuals/calci/LISTCOLUMNS | LISTCOLUMNS]]
 +
*[[Manuals/calci/LISTROWS | LISTROWS]]
 +
*[[Manuals/calci/LISTUNIQUE | LISTUNIQUE]]
 +
*[[Manuals/calci/LISTV | LISTV]]
 +
*[[Manuals/calci/LOOKUP | LOOKUP]]
 +
*[[Manuals/calci/LOOPMEDIA | LOOPMEDIA]]
 +
*[[Manuals/calci/MLANGUAGELOOKUP | MLANGUAGELOOKUP]]
 
*[[Manuals/calci/NUMBEREIGHT | NUMBEREIGHT]]
 
*[[Manuals/calci/NUMBEREIGHT | NUMBEREIGHT]]
 
*[[Manuals/calci/NUMBERFIVE | NUMBERFIVE]]
 
*[[Manuals/calci/NUMBERFIVE | NUMBERFIVE]]
Line 1,089: Line 1,073:
 
*[[Manuals/calci/NUMBERTWO | NUMBERTWO]]
 
*[[Manuals/calci/NUMBERTWO | NUMBERTWO]]
 
*[[Manuals/calci/NUMBERZERO | NUMBERZERO]]
 
*[[Manuals/calci/NUMBERZERO | NUMBERZERO]]
−
*[[Manuals/calci/NUMERICARRAY | NUMERICARRAY]]
+
*[[Manuals/calci/ONE | ONE]]
−
*[[Manuals/calci/NUMS | NUMS]]
 
−
*[[Manuals/calci/NUMSCORE | NUMSCORE]]
 
−
*[[Manuals/calci/NVL | NVL]]
 
−
*[[Manuals/calci/OBJ | OBJ]]
 
−
*[[Manuals/calci/OBJECT | OBJECT]]
 
−
*[[Manuals/calci/OCCURANCES | OCCURANCES]]
 
−
*[[Manuals/calci/ODDS | ODDS]]
 
−
*[[Manuals/calci/ODDSET | ODDSET]]
 
−
*[[Manuals/calci/ODDSUPTO | ODDSUPTO]]
 
−
*[[Manuals/calci/OLDX | OLDX]]
 
 
*[[Manuals/calci/ONEBY | ONEBY]]
 
*[[Manuals/calci/ONEBY | ONEBY]]
−
*[[Manuals/calci/OPF | OPF]]
 
−
*[[Manuals/calci/OPFSTR | OPFSTR]]
 
−
*[[Manuals/calci/OPTIONSECURITY | OPTIONSECURITY]]
 
−
*[[Manuals/calci/ORDINAL | ORDINAL]]
 
−
*[[Manuals/calci/OSTYLE | OSTYLE]]
 
−
*[[Manuals/calci/OUTPUT | OUTPUT]]
 
−
*[[Manuals/calci/PACK | PACK]]
 
−
*[[Manuals/calci/PADZEROES | PADZEROES]]
 
 
*[[Manuals/calci/PARSE | PARSE]]
 
*[[Manuals/calci/PARSE | PARSE]]
 
*[[Manuals/calci/PARSELISP | PARSELISP]]
 
*[[Manuals/calci/PARSELISP | PARSELISP]]
Line 1,114: Line 1,080:
 
*[[Manuals/calci/PARSESQL | PARSESQL]]
 
*[[Manuals/calci/PARSESQL | PARSESQL]]
 
*[[Manuals/calci/PARSESTRINGWITHOUTPARANTHESIS | PARSESTRINGWITHOUTPARANTHESIS]]
 
*[[Manuals/calci/PARSESTRINGWITHOUTPARANTHESIS | PARSESTRINGWITHOUTPARANTHESIS]]
−
*[[Manuals/calci/PARTITIONP | PARTITIONP]]
 
−
*[[Manuals/calci/PARTITIONTREE | PARTITIONTREE]]
 
−
*[[Manuals/calci/PARTP | PARTP]]
 
 
*[[Manuals/calci/PASTECOLUMNS | PASTECOLUMNS]]
 
*[[Manuals/calci/PASTECOLUMNS | PASTECOLUMNS]]
 
*[[Manuals/calci/PASTEROWS | PASTEROWS]]
 
*[[Manuals/calci/PASTEROWS | PASTEROWS]]
−
*[[Manuals/calci/PATTERNDISTRIBUTED | PATTERNDISTRIBUTED]]
 
 
*[[Manuals/calci/PAUSE | PAUSE]]
 
*[[Manuals/calci/PAUSE | PAUSE]]
−
*[[Manuals/calci/PENTATE | PENTATE]]
+
*[[Manuals/calci/QUOTE | QUOTE]]
−
*[[Manuals/calci/PERCENTAGES | PERCENTAGES]]
+
*[[Manuals/calci/ROW | ROW]]
−
*[[Manuals/calci/PERFECTNUMBERS | PERFECTNUMBERS]]
+
*[[Manuals/calci/ROWS | ROWS]]
−
*[[Manuals/calci/PERMUTATIONS | PERMUTATIONS]]
+
*[[Manuals/calci/ROWWITH | ROWWITH]]
−
*[[Manuals/calci/PFX | PFX]]
+
*[[Manuals/calci/SMILE | SMILE]]
−
*[[Manuals/calci/PHONETIC | PHONETIC]]
+
*[[Manuals/calci/UNDEFINED | UNDEFINED]]
−
*[[Manuals/calci/PHONETICCODES | PHONETICCODES]]
+
*[[Manuals/calci/UPTO | UPTO]]
−
*[[Manuals/calci/PIECHART | PIECHART]]
+
*[[Manuals/calci/VLOOKUP | VLOOKUP]]
−
*[[Manuals/calci/PIGEN | PIGEN]]
+
*[[Manuals/calci/VLOOKUP#Examples | VLOOKUPExamples]]
−
*[[Manuals/calci/PIVOT | PIVOT]]
+
 
−
*[[Manuals/calci/PLOT | PLOT]]
+
===Lookup and Reference2===
−
*[[Manuals/calci/PLOTDEV | PLOTDEV]]
+
*[[Manuals/calci/ANALYZE | ANALYZE]]
−
*[[Manuals/calci/PLUSMINUS | PLUSMINUS]]
+
*[[Manuals/calci/ASSIGN | ASSIGN]]
−
*[[Manuals/calci/PLUTO | PLUTO]]
+
*[[Manuals/calci/ASYNCITERATE | ASYNCITERATE]]
−
*[[Manuals/calci/PMTLISTING | PMTLISTING]]
+
*[[Manuals/calci/ATTRTOPROP | ATTRTOPROP]]
−
*[[Manuals/calci/POINTAT | POINTAT]]
+
*[[Manuals/calci/CASE | CASE]]
−
*[[Manuals/calci/POISSONDISTRIBUTED | POISSONDISTRIBUTED]]
+
*[[Manuals/calci/CASEIF | CASEIF]]
−
*[[Manuals/calci/POLYGON | POLYGON]]
+
*[[Manuals/calci/CDR | CDR]]
−
*[[Manuals/calci/POP | POP]]
+
*[[Manuals/calci/EFFECTCOLORBOOK | EFFECTCOLORBOOK]]
−
*[[Manuals/calci/POSITIVE | POSITIVE]]
+
*[[Manuals/calci/EFFECTEDGEDETECTION | EFFECTEDGEDETECTION]]
−
*[[Manuals/calci/PRETTYPRINT | PRETTYPRINT]]
+
*[[Manuals/calci/EFFECTEDGEDETECTIONALGORITHM | EFFECTEDGEDETECTIONALGORITHM]]
−
*[[Manuals/calci/PRIMEFACTORS | PRIMEFACTORS]]
+
*[[Manuals/calci/EFFECTGLASS | EFFECTGLASS]]
−
*[[Manuals/calci/PRINT | PRINT]]
+
*[[Manuals/calci/EFFECTGLASSBOX | EFFECTGLASSBOX]]
−
*[[Manuals/calci/PRINTCONVERSION | PRINTCONVERSION]]
+
*[[Manuals/calci/EFFECTGLASSPATTERN | EFFECTGLASSPATTERN]]
−
*[[Manuals/calci/PRINTTAGS | PRINTTAGS]]
+
*[[Manuals/calci/EFFECTNEONLINES | EFFECTNEONLINES]]
−
*[[Manuals/calci/PRINTUNITTAGS | PRINTUNITTAGS]]
+
*[[Manuals/calci/EFFECTPATTERN | EFFECTPATTERN]]
−
*[[Manuals/calci/PRINTWITHUNITS | PRINTWITHUNITS]]
+
*[[Manuals/calci/EFFECTRIPPLES | EFFECTRIPPLES]]
−
*[[Manuals/calci/PRODUCTOF | PRODUCTOF]]
+
*[[Manuals/calci/GETCELLTD | GETCELLTD]]
−
*[[Manuals/calci/PROJECT | PROJECT]]
+
*[[Manuals/calci/GETLATLONG | GETLATLONG]]
−
*[[Manuals/calci/PROPTOATTR | PROPTOATTR]]
+
*[[Manuals/calci/GKMAPPING | GKMAPPING]]
−
*[[Manuals/calci/PUSH | PUSH]]
+
*[[Manuals/calci/PENTATE | PENTATE]]
−
*[[Manuals/calci/PUTOPTION | PUTOPTION]]
+
*[[Manuals/calci/QPIVOT | QPIVOT]]
−
*[[Manuals/calci/PVEQUATION | PVEQUATION]]
+
*[[Manuals/calci/QPIVOTINCUBE | QPIVOTINCUBE]]
−
*[[Manuals/calci/PVIF | PVIF]]
+
*[[Manuals/calci/SAFEEVAL | SAFEEVAL]]
−
*[[Manuals/calci/PVIFA | PVIFA]]
+
*[[Manuals/calci/STEPLOOP | STEPLOOP]]
−
*[[Manuals/calci/QPIVOT | QPIVOT]]
+
*[[Manuals/calci/TIMER | TIMER]]
−
*[[Manuals/calci/QPIVOTINCUBE | QPIVOTINCUBE]]
+
*[[Manuals/calci/TIMES | TIMES]]
−
*[[Manuals/calci/QRDECOMPOSITION | QRDECOMPOSITION]]
+
*[[Manuals/calci/TIMESTRING | TIMESTRING]]
−
*[[Manuals/calci/QRDEV | QRDEV]]
+
*[[Manuals/calci/TYPE | TYPE]]
−
*[[Manuals/calci/QUADRATIC | QUADRATIC]]
+
*[[Manuals/calci/TZ | TZ]]
−
*[[Manuals/calci/QUALITATIVEDESCRIPTION | QUALITATIVEDESCRIPTION]]
+
*[[Manuals/calci/XLBETWEEN | XLBETWEEN]]
−
*[[Manuals/calci/QUATERNION | QUATERNION]]
+
*[[Manuals/calci/XLRBETWEEN | XLRBETWEEN]]
−
*[[Manuals/calci/QUOTE | QUOTE]]
+
*[[Manuals/calci/XPY | XPY]]
−
*[[Manuals/calci/RADIALTREE | RADIALTREE]]
+
*[[Manuals/calci/XRBETWEEN | XRBETWEEN]]
−
*[[Manuals/calci/RADIANSLIST | RADIANSLIST]]
+
*[[Manuals/calci/XSY | XSY]]
−
*[[Manuals/calci/RANDINT | RANDINT]]
+
 
−
*[[Manuals/calci/RANDNUM | RANDNUM]]
+
===Text and Data1===
−
*[[Manuals/calci/RANDOMARRAY | RANDOMARRAY]]
+
*[[Manuals/calci/BADWORDS | BADWORDS]]
−
*[[Manuals/calci/RANDOMAT | RANDOMAT]]
+
*[[Manuals/calci/CHAR | CHAR]]
−
*[[Manuals/calci/RANDOMNUMBERSCORE | RANDOMNUMBERSCORE]]
+
*[[Manuals/calci/CHR | CHR]]
−
*[[Manuals/calci/RANDOMPHRASE | RANDOMPHRASE]]
+
*[[Manuals/calci/CLAUSES | CLAUSES]]
−
*[[Manuals/calci/RANDOMSELECT | RANDOMSELECT]]
+
*[[Manuals/calci/CLEAN | CLEAN]]
−
*[[Manuals/calci/RANDOMSELECTWITHMATCH | RANDOMSELECTWITHMATCH]]
+
*[[Manuals/calci/CLEAR | CLEAR]]
−
*[[Manuals/calci/RANDOMSET | RANDOMSET]]
+
*[[Manuals/calci/CLS | CLS]]
−
*[[Manuals/calci/RANDOMWITHIGNORE | RANDOMWITHIGNORE]]
+
*[[Manuals/calci/CODE | CODE]]
−
*[[Manuals/calci/RANDOMWITHIN | RANDOMWITHIN]]
+
*[[Manuals/calci/DEFAULT | DEFAULT]]
−
*[[Manuals/calci/RANGE | RANGE]]
+
*[[Manuals/calci/DEFAULTNUMBER | DEFAULTNUMBER]]
−
*[[Manuals/calci/RANGELOCATION | RANGELOCATION]]
+
*[[Manuals/calci/DEFAULTPROPER | DEFAULTPROPER]]
−
*[[Manuals/calci/RANKS | RANKS]]
+
*[[Manuals/calci/DEFUN | DEFUN]]
−
*[[Manuals/calci/RATIOS | RATIOS]]
+
*[[Manuals/calci/DES | DES]]
−
*[[Manuals/calci/RDF | RDF]]
+
*[[Manuals/calci/DESCRIBEFUNCTIONCALLMISSING | DESCRIBEFUNCTIONCALLMISSING]]
−
*[[Manuals/calci/READFROMLZWIMAGE | READFROMLZWIMAGE]]
+
*[[Manuals/calci/DEVARRAY | DEVARRAY]]
−
*[[Manuals/calci/RECIPROCAL | RECIPROCAL]]
+
*[[Manuals/calci/DIM | DIM]]
−
*[[Manuals/calci/RECIPROCALOF | RECIPROCALOF]]
+
*[[Manuals/calci/DIMENSIONS | DIMENSIONS]]
−
*[[Manuals/calci/RECTANGLE | RECTANGLE]]
+
*[[Manuals/calci/DIS | DIS]]
−
*[[Manuals/calci/RECURSIVEARRAY | RECURSIVEARRAY]]
+
*[[Manuals/calci/EIGHTHOF | EIGHTHOF]]
−
*[[Manuals/calci/REDIRECT | REDIRECT]]
+
*[[Manuals/calci/ESCAPE | ESCAPE]]
−
*[[Manuals/calci/REDIRECTFROM | REDIRECTFROM]]
+
*[[Manuals/calci/EXTRACTNUMBERS | EXTRACTNUMBERS]]
−
*[[Manuals/calci/REDIRECTTO | REDIRECTTO]]
+
*[[Manuals/calci/EXTRACTTEXT | EXTRACTTEXT]]
−
*[[Manuals/calci/REDUCEDROWECHELONFORM | REDUCEDROWECHELONFORM]]
+
*[[Manuals/calci/FAIL | FAIL]]
−
*[[Manuals/calci/REM | REM]]
+
*[[Manuals/calci/FIND | FIND]]
−
*[[Manuals/calci/REMAINDER | REMAINDER]]
+
*[[Manuals/calci/FINDB | FINDB]]
−
*[[Manuals/calci/REMOVECONVERSION | REMOVECONVERSION]]
+
*[[Manuals/calci/FINDUNIT | FINDUNIT]]
−
*[[Manuals/calci/REMOVENUMBERS | REMOVENUMBERS]]
+
*[[Manuals/calci/FIXCHARS | FIXCHARS]]
−
*[[Manuals/calci/REMOVETEXT | REMOVETEXT]]
+
*[[Manuals/calci/FIXED | FIXED]]
−
*[[Manuals/calci/REPEAT | REPEAT]]
+
*[[Manuals/calci/FIXEDBAD | FIXEDBAD]]
−
*[[Manuals/calci/REPEATCHAR | REPEATCHAR]]
+
*[[Manuals/calci/FOR | FOR]]
−
*[[Manuals/calci/REPLACEARRAY | REPLACEARRAY]]
+
*[[Manuals/calci/FORALL | FORALL]]
−
*[[Manuals/calci/REPLACEBAD | REPLACEBAD]]
+
*[[Manuals/calci/FOREACH | FOREACH]]
−
*[[Manuals/calci/RESETSEQ | RESETSEQ]]
+
*[[Manuals/calci/FORLOOP | FORLOOP]]
−
*[[Manuals/calci/RETVALUE | RETVALUE]]
+
*[[Manuals/calci/LEFTB | LEFTB]]
−
*[[Manuals/calci/REVERSE | REVERSE]]
+
*[[Manuals/calci/LEN | LEN]]
−
*[[Manuals/calci/RGB | RGB]]
+
*[[Manuals/calci/LENB | LENB]]
−
*[[Manuals/calci/RNG | RNG]]
+
*[[Manuals/calci/LETTERS | LETTERS]]
−
*[[Manuals/calci/ROMANOLD | ROMANOLD]]
+
*[[Manuals/calci/LOWER | LOWER]]
−
*[[Manuals/calci/ROOTNTH | ROOTNTH]]
+
*[[Manuals/calci/LOWERCASE | LOWERCASE]]
−
*[[Manuals/calci/ROOTNTHFUNCTION | ROOTNTHFUNCTION]]
+
*[[Manuals/calci/LZ | LZ]]
−
*[[Manuals/calci/ROOTTHETA | ROOTTHETA]]
+
*[[Manuals/calci/LZWCOMPRESS | LZWCOMPRESS]]
−
*[[Manuals/calci/ROOTTHETATOQUARDRANT | ROOTTHETATOQUARDRANT]]
+
*[[Manuals/calci/LZWDECOMPRESS | LZWDECOMPRESS]]
−
*[[Manuals/calci/ROUNDAT | ROUNDAT]]
+
*[[Manuals/calci/MID | MID]]
−
*[[Manuals/calci/ROWWITH | ROWWITH]]
+
*[[Manuals/calci/MIDB | MIDB]]
−
*[[Manuals/calci/RTD | RTD]]
+
*[[Manuals/calci/MIDDLE | MIDDLE]]
−
*[[Manuals/calci/SAFEEVAL | SAFEEVAL]]
+
*[[Manuals/calci/MIDN | MIDN]]
−
*[[Manuals/calci/SATURN | SATURN]]
+
*[[Manuals/calci/MIXEDCASE | MIXEDCASE]]
−
*[[Manuals/calci/SAYFOCUS | SAYFOCUS]]
+
*[[Manuals/calci/NOK | NOK]]
−
*[[Manuals/calci/SAYNUMBER | SAYNUMBER]]
+
*[[Manuals/calci/NONFALSEVALUE | NONFALSEVALUE]]
−
*[[Manuals/calci/SCALARPRODUCT | SCALARPRODUCT]]
+
*[[Manuals/calci/NONNEGATIVE | NONNEGATIVE]]
−
*[[Manuals/calci/SCRAMBLE | SCRAMBLE]]
+
*[[Manuals/calci/NONPOSITIVE | NONPOSITIVE]]
−
*[[Manuals/calci/SDIM | SDIM]]
+
*[[Manuals/calci/NONZERO | NONZERO]]
−
*[[Manuals/calci/SECH | SECH]]
+
*[[Manuals/calci/NONZEROVALUE | NONZEROVALUE]]
−
*[[Manuals/calci/SELECT | SELECT]]
+
*[[Manuals/calci/NOPE | NOPE]]
−
*[[Manuals/calci/SELECTONE | SELECTONE]]
+
*[[Manuals/calci/NOW | NOW]]
−
*[[Manuals/calci/SELF | SELF]]
+
*[[Manuals/calci/NULL | NULL]]
−
*[[Manuals/calci/SEMANTICSEARCH | SEMANTICSEARCH]]
+
*[[Manuals/calci/NULLIF | NULLIF]]
 +
*[[Manuals/calci/NUM | NUM]]
 +
*[[Manuals/calci/NUMBER | NUMBER]]
 +
*[[Manuals/calci/NVL | NVL]]
 +
*[[Manuals/calci/OSTYLE | OSTYLE]]
 +
*[[Manuals/calci/OUTPUT | OUTPUT]]
 +
*[[Manuals/calci/PACK | PACK]]
 +
*[[Manuals/calci/PADZEROES | PADZEROES]]
 +
*[[Manuals/calci/PHONETIC | PHONETIC]]
 +
*[[Manuals/calci/PHONETICCODES | PHONETICCODES]]
 +
*[[Manuals/calci/PRINT | PRINT]]
 +
*[[Manuals/calci/PRINTCONVERSION | PRINTCONVERSION]]
 +
*[[Manuals/calci/PRINTTAGS | PRINTTAGS]]
 +
*[[Manuals/calci/PRINTUNITTAGS | PRINTUNITTAGS]]
 +
*[[Manuals/calci/PRINTWITHUNITS | PRINTWITHUNITS]]
 +
*[[Manuals/calci/PROPER | PROPER]]
 +
*[[Manuals/calci/PUSH | PUSH]]
 +
*[[Manuals/calci/REMOVETEXT | REMOVETEXT]]
 +
*[[Manuals/calci/REPEATCHAR | REPEATCHAR]]
 +
*[[Manuals/calci/REPLACE | REPLACE]]
 +
*[[Manuals/calci/REPLACEARRAY | REPLACEARRAY]]
 +
*[[Manuals/calci/REPLACEB | REPLACEB]]
 +
*[[Manuals/calci/REPLACEBAD | REPLACEBAD]]
 +
*[[Manuals/calci/REPT | REPT]]
 +
*[[Manuals/calci/REVERSE | REVERSE]]
 +
*[[Manuals/calci/RIGHTB | RIGHTB]]
 +
*[[Manuals/calci/RTD | RTD]]
 +
*[[Manuals/calci/SEARCH | SEARCH]]
 +
*[[Manuals/calci/SEARCHB | SEARCHB]]
 +
*[[Manuals/calci/SearchBoxSpace | SearchBoxSpace]]
 
*[[Manuals/calci/SEQ | SEQ]]
 
*[[Manuals/calci/SEQ | SEQ]]
−
*[[Manuals/calci/SERIESOF | SERIESOF]]
+
*[[Manuals/calci/SETVALUESTRING | SETVALUESTRING]]
−
*[[Manuals/calci/SERIESSTR | SERIESSTR]]
 
−
*[[Manuals/calci/SERIESTERMS | SERIESTERMS]]
 
−
*[[Manuals/calci/SETCONVERSION | SETCONVERSION]]
 
−
*[[Manuals/calci/SETVALUE | SETVALUE]]
 
−
*[[Manuals/calci/SETVALUESTRING | SETVALUESTRING]]
 
 
*[[Manuals/calci/SETWHOISUSER | SETWHOISUSER]]
 
*[[Manuals/calci/SETWHOISUSER | SETWHOISUSER]]
−
*[[Manuals/calci/SEVENTHOF | SEVENTHOF]]
 
−
*[[Manuals/calci/SEVERAL | SEVERAL]]
 
−
*[[Manuals/calci/SHAPE | SHAPE]]
 
−
*[[Manuals/calci/SHOW | SHOW]]
 
−
*[[Manuals/calci/SHOWARRAY | SHOWARRAY]]
 
−
*[[Manuals/calci/SIGMA | SIGMA]]
 
−
*[[Manuals/calci/SIGMAOF | SIGMAOF]]
 
−
*[[Manuals/calci/SINC | SINC]]
 
−
*[[Manuals/calci/SINCP | SINCP]]
 
−
*[[Manuals/calci/SINH | SINH]]
 
−
*[[Manuals/calci/SIXTHOF | SIXTHOF]]
 
−
*[[Manuals/calci/SIZE | SIZE]]
 
−
*[[Manuals/calci/SKEWSYMMETRIC | SKEWSYMMETRIC]]
 
 
*[[Manuals/calci/SLIDERCONTROL | SLIDERCONTROL]]
 
*[[Manuals/calci/SLIDERCONTROL | SLIDERCONTROL]]
−
*[[Manuals/calci/SMALLLETTERS | SMALLLETTERS]]
+
*[[Manuals/calci/SO | SO]]
−
*[[Manuals/calci/SMILE | SMILE]]
 
 
*[[Manuals/calci/SOB | SOB]]
 
*[[Manuals/calci/SOB | SOB]]
 
*[[Manuals/calci/SOC | SOC]]
 
*[[Manuals/calci/SOC | SOC]]
Line 1,256: Line 1,228:
 
*[[Manuals/calci/SOLT | SOLT]]
 
*[[Manuals/calci/SOLT | SOLT]]
 
*[[Manuals/calci/SOLTWH | SOLTWH]]
 
*[[Manuals/calci/SOLTWH | SOLTWH]]
−
*[[Manuals/calci/SOLUTIONS | SOLUTIONS]]
 
 
*[[Manuals/calci/SOME | SOME]]
 
*[[Manuals/calci/SOME | SOME]]
−
*[[Manuals/calci/SOR | SOR]]
+
*[[Manuals/calci/SPELLDIGIT | SPELLDIGIT]]
−
*[[Manuals/calci/SORT | SORT]]
+
*[[Manuals/calci/SPELLINTEGER | SPELLINTEGER]]
−
*[[Manuals/calci/SORTING | SORTING]]
+
*[[Manuals/calci/SPELLNUMBER | SPELLNUMBER]]
−
*[[Manuals/calci/SOSZ | SOSZ]]
+
*[[Manuals/calci/SPELLTEENS | SPELLTEENS]]
−
*[[Manuals/calci/SOT | SOT]]
 
−
*[[Manuals/calci/SOUNDEX | SOUNDEX]]
 
−
*[[Manuals/calci/SOUNDSLIKE | SOUNDSLIKE]]
 
−
*[[Manuals/calci/SOV | SOV]]
 
−
*[[Manuals/calci/SOW | SOW]]
 
−
*[[Manuals/calci/SOWH | SOWH]]
 
−
*[[Manuals/calci/SOZ | SOZ]]
 
−
*[[Manuals/calci/SPEEDOFLIGHT | SPEEDOFLIGHT]]
 
−
*[[Manuals/calci/SPELLDIGIT | SPELLDIGIT]]
 
−
*[[Manuals/calci/SPELLINTEGER | SPELLINTEGER]]
 
−
*[[Manuals/calci/SPELLNUMBER | SPELLNUMBER]]
 
−
*[[Manuals/calci/SPELLTEENS | SPELLTEENS]]
 
 
*[[Manuals/calci/SPELLTENS | SPELLTENS]]
 
*[[Manuals/calci/SPELLTENS | SPELLTENS]]
−
*[[Manuals/calci/SPLIT | SPLIT]]
 
−
*[[Manuals/calci/SPLITTEXT | SPLITTEXT]]
 
−
*[[Manuals/calci/SPREAD | SPREAD]]
 
−
*[[Manuals/calci/SPREADSHEETS | SPREADSHEETS]]
 
−
*[[Manuals/calci/SQL | SQL]]
 
−
*[[Manuals/calci/SQUARES | SQUARES]]
 
−
*[[Manuals/calci/SSTR | SSTR]]
 
 
*[[Manuals/calci/STANDARDPHONETICCODES | STANDARDPHONETICCODES]]
 
*[[Manuals/calci/STANDARDPHONETICCODES | STANDARDPHONETICCODES]]
−
*[[Manuals/calci/STAR | STAR]]
 
−
*[[Manuals/calci/STARS | STARS]]
 
−
*[[Manuals/calci/STATIC | STATIC]]
 
−
*[[Manuals/calci/STDEVIF | STDEVIF]]
 
−
*[[Manuals/calci/STDEVPIF | STDEVPIF]]
 
−
*[[Manuals/calci/STEMANDLEAFPLOT | STEMANDLEAFPLOT]]
 
−
*[[Manuals/calci/STEPLOOP | STEPLOOP]]
 
 
*[[Manuals/calci/STRIKETHROUGH | STRIKETHROUGH]]
 
*[[Manuals/calci/STRIKETHROUGH | STRIKETHROUGH]]
 
*[[Manuals/calci/STRINGTOARRAY | STRINGTOARRAY]]
 
*[[Manuals/calci/STRINGTOARRAY | STRINGTOARRAY]]
−
*[[Manuals/calci/STYLECELL | STYLECELL]]
 
 
*[[Manuals/calci/SUBSCRIPT | SUBSCRIPT]]
 
*[[Manuals/calci/SUBSCRIPT | SUBSCRIPT]]
−
*[[Manuals/calci/SUBSET | SUBSET]]
+
*[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]]
 
*[[Manuals/calci/SUBSTRINGCOUNT | SUBSTRINGCOUNT]]
 
*[[Manuals/calci/SUBSTRINGCOUNT | SUBSTRINGCOUNT]]
−
*[[Manuals/calci/SUBTRACT | SUBTRACT]]
 
−
*[[Manuals/calci/SUBTRACTBY | SUBTRACTBY]]
 
−
*[[Manuals/calci/SUBTRACTFROM | SUBTRACTFROM]]
 
−
*[[Manuals/calci/SUBTRACTWITH | SUBTRACTWITH]]
 
−
*[[Manuals/calci/SUMBY | SUMBY]]
 
−
*[[Manuals/calci/SUMFACTORS | SUMFACTORS]]
 
−
*[[Manuals/calci/SUMOF | SUMOF]]
 
−
*[[Manuals/calci/SUMOFSQUARES | SUMOFSQUARES]]
 
−
*[[Manuals/calci/SUMWITH | SUMWITH]]
 
−
*[[Manuals/calci/SUN | SUN]]
 
−
*[[Manuals/calci/SUNBURST | SUNBURST]]
 
−
*[[Manuals/calci/SUPERLOGARITHM | SUPERLOGARITHM]]
 
 
*[[Manuals/calci/SUPERSCRIPT | SUPERSCRIPT]]
 
*[[Manuals/calci/SUPERSCRIPT | SUPERSCRIPT]]
−
*[[Manuals/calci/SUPERSET | SUPERSET]]
+
*[[Manuals/calci/TEXT | TEXT]]
−
*[[Manuals/calci/SUPPORTEDUNITS | SUPPORTEDUNITS]]
+
*[[Manuals/calci/UNDERLINE | UNDERLINE]]
−
*[[Manuals/calci/SURFACEGRAPH | SURFACEGRAPH]]
+
*[[Manuals/calci/UPPER | UPPER]]
−
*[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
+
*[[Manuals/calci/UPPERCASE | UPPERCASE]]
−
*[[Manuals/calci/SVF | SVF]]
+
*[[Manuals/calci/VALUE | VALUE]]
−
*[[Manuals/calci/SYMBOLFILTER | SYMBOLFILTER]]
+
*[[Manuals/calci/VALUEITSELF | VALUEITSELF]]
−
*[[Manuals/calci/SYMBOLIC | SYMBOLIC]]
+
*[[Manuals/calci/VOID | VOID]]
−
*[[Manuals/calci/SYMBOLNUMBER | SYMBOLNUMBER]]
+
*[[Manuals/calci/WRITE | WRITE]]
−
*[[Manuals/calci/SearchBoxSpace | SearchBoxSpace]]
+
*[[Manuals/calci/WRITELN | WRITELN]]
−
*[[Manuals/calci/TABLE | TABLE]]
+
*[[Manuals/calci/WS | WS]]
−
*[[Manuals/calci/TABLEADDROW | TABLEADDROW]]
+
 
−
*[[Manuals/calci/TABLEARRAY | TABLEARRAY]]
+
===Text and Data2===
−
*[[Manuals/calci/TABLES | TABLES]]
+
*[[Manuals/calci/CHECKFACT | CHECKFACT]]
−
*[[Manuals/calci/TABULATE | TABULATE]]
+
*[[Manuals/calci/COLLECTION | COLLECTION]]
−
*[[Manuals/calci/TABULATEFORPIVOT | TABULATEFORPIVOT]]
+
*[[Manuals/calci/CONCAT | CONCAT]]
−
*[[Manuals/calci/TAGS | TAGS]]
+
*[[Manuals/calci/CONCATENATE | CONCATENATE]]
−
*[[Manuals/calci/TANH | TANH]]
+
*[[Manuals/calci/CONCATSTRINGTOARRAY | CONCATSTRINGTOARRAY]]
−
*[[Manuals/calci/TENSORPRODUCT | TENSORPRODUCT]]
+
*[[Manuals/calci/EXACT | EXACT]]
−
*[[Manuals/calci/TENTHOF | TENTHOF]]
+
*[[Manuals/calci/FORX | FORX]]
−
*[[Manuals/calci/TERMSOFENDEARMENT | TERMSOFENDEARMENT]]
+
*[[Manuals/calci/FORXX | FORXX]]
−
*[[Manuals/calci/TESTARRAY | TESTARRAY]]
+
*[[Manuals/calci/FORXXCOMBINATORIAL | FORXXCOMBINATORIAL]]
−
*[[Manuals/calci/TESTDIV | TESTDIV]]
+
*[[Manuals/calci/FORY | FORY]]
−
*[[Manuals/calci/TESTMAX | TESTMAX]]
+
*[[Manuals/calci/LFN | LFN]]
−
*[[Manuals/calci/TESTMAXWORKS | TESTMAXWORKS]]
+
*[[Manuals/calci/MARKUNITNATURE | MARKUNITNATURE]]
−
*[[Manuals/calci/TETRA | TETRA]]
+
*[[Manuals/calci/MARQUEE | MARQUEE]]
−
*[[Manuals/calci/TETRAHEDRON | TETRAHEDRON]]
+
*[[Manuals/calci/NOTHING | NOTHING]]
−
*[[Manuals/calci/TETRAHEDRONDEV | TETRAHEDRONDEV]]
+
*[[Manuals/calci/NUB | NUB]]
−
*[[Manuals/calci/TETRATE | TETRATE]]
+
*[[Manuals/calci/PRETTYPRINT | PRETTYPRINT]]
−
*[[Manuals/calci/TEVALX | TEVALX]]
+
*[[Manuals/calci/PROPTOATTR | PROPTOATTR]]
−
*[[Manuals/calci/THEREDOESNOTEXIST | THEREDOESNOTEXIST]]
+
*[[Manuals/calci/RESETSEQ | RESETSEQ]]
−
*[[Manuals/calci/THEREEXISTS | THEREEXISTS]]
+
*[[Manuals/calci/RETVALUE | RETVALUE]]
−
*[[Manuals/calci/THEREEXISTSONE | THEREEXISTSONE]]
+
*[[Manuals/calci/SPLIT | SPLIT]]
−
*[[Manuals/calci/THETAINDEGREES | THETAINDEGREES]]
+
*[[Manuals/calci/SPLITTEXT | SPLITTEXT]]
−
*[[Manuals/calci/THETAS | THETAS]]
+
*[[Manuals/calci/SS | SS]]
−
*[[Manuals/calci/THINK | THINK]]
+
*[[Manuals/calci/SSTR | SSTR]]
−
*[[Manuals/calci/THIRDOF | THIRDOF]]
+
*[[Manuals/calci/STYLECELL | STYLECELL]]
−
*[[Manuals/calci/THOUSAND | THOUSAND]]
+
 
−
*[[Manuals/calci/THROTTLE | THROTTLE]]
+
===Matrix Functions1===
−
*[[Manuals/calci/TIMER | TIMER]]
+
*[[Manuals/calci/ADJ | ADJ]]
−
*[[Manuals/calci/TIMES | TIMES]]
+
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL]]
−
*[[Manuals/calci/TIMESTRING | TIMESTRING]]
+
*[[Manuals/calci/ANTIDIAGONALWITH | ANTIDIAGONALWITH]]
−
*[[Manuals/calci/TODATE | TODATE]]
+
*[[Manuals/calci/BLOCKDIAGONAL| BLOCKDIAGONAL]]
−
*[[Manuals/calci/TODAY | TODAY]]
+
*[[Manuals/calci/CONTOURS | CONTOURS]]
−
*[[Manuals/calci/TOMONTH |
+
*[[Manuals/calci/DIAGONALFILL | DIAGONALFILL]]
 +
*[[Manuals/calci/DIAGONALMATRIX | DIAGONALMATRIX]]
 +
*[[Manuals/calci/DIAGONALWITH | DIAGONALWITH]]
 +
*[[Manuals/calci/EYE | EYE]]
 +
*[[Manuals/calci/HADAMARD | HADAMARD]]
 +
*[[Manuals/calci/hadamard | hadamard]]
 +
*[[Manuals/calci/HADAMARDPRODUCT | HADAMARDPRODUCT]]
 +
*[[Manuals/calci/HANKEL | HANKEL]]
 +
*[[Manuals/calci/hankel | hankel]]
 +
*[[Manuals/calci/IM | IM]]
 +
*[[Manuals/calci/INVERSE | INVERSE]]
 +
*[[Manuals/calci/KEEPCOLUMNS | KEEPCOLUMNS]]
 +
*[[Manuals/calci/MATRIX | MATRIX]]
 +
*[[Manuals/calci/MATRIXADD | MATRIXADD]]
 +
*[[Manuals/calci/MATRIXADJOINT
 
*[[Manuals/calci/ZVisibleListx | ZVisibleListx]]
 
*[[Manuals/calci/ZVisibleListx | ZVisibleListx]]
 +
*[[Manuals/calci/ZWidth | ZWidth]]
 +
*[[Manuals/calci/ZWizParentPointer | ZWizParentPointer]]
 
*[[Manuals/calci/ZWO | ZWO]]
 
*[[Manuals/calci/ZWO | ZWO]]
−
*[[Manuals/calci/ZWidth | ZWidth]]
+
*[[Manuals/calci/ZWrap | ZWrap]]
−
*[[Manuals/calci/ZWizParentPointer | ZWizParentPointer]]
+
*[[Manuals/calci/ZWrapCaption | ZWrapCaption]]
−
*[[Manuals/calci/ZWrap | ZWrap]]
+
*[[Manuals/calci/Zx | Zx]]
−
*[[Manuals/calci/ZWrapCaption | ZWrapCaption]]
+
*[[Manuals/calci/ZxOfArray | ZxOfArray]]
 
*[[Manuals/calci/ZZoom | ZZoom]]
 
*[[Manuals/calci/ZZoom | ZZoom]]
−
*[[Manuals/calci/ZeroIfTooLow | ZeroIfTooLow]]
 
−
*[[Manuals/calci/ZeroPad | ZeroPad]]
 
−
*[[Manuals/calci/ZoomAndPanZoomyBy | ZoomAndPanZoomyBy]]
 
−
*[[Manuals/calci/ZoomMinus | ZoomMinus]]
 
−
*[[Manuals/calci/ZoomNone | ZoomNone]]
 
−
*[[Manuals/calci/ZoomPlus | ZoomPlus]]
 
−
*[[Manuals/calci/ZoomVariable | ZoomVariable]]
 
−
*[[Manuals/calci/ZoomableCircle | ZoomableCircle]]
 
−
*[[Manuals/calci/ZoomableTreeByCount | ZoomableTreeByCount]]
 
−
*[[Manuals/calci/ZoomableTreeBySize | ZoomableTreeBySize]]
 
−
*[[Manuals/calci/ZoomableTreeCore | ZoomableTreeCore]]
 
−
*[[Manuals/calci/ZoomyActive | ZoomyActive]]
 
−
*[[Manuals/calci/ZoomyControlWrapper | ZoomyControlWrapper]]
 
−
*[[Manuals/calci/ZoomyCurrentStep | ZoomyCurrentStep]]
 
−
*[[Manuals/calci/ZoomyDefaults | ZoomyDefaults]]
 
−
*[[Manuals/calci/ZoomyList | ZoomyList]]
 
−
*[[Manuals/calci/ZoomyToNextCube | ZoomyToNextCube]]
 
−
*[[Manuals/calci/Zx | Zx]]
 
−
*[[Manuals/calci/ZxOfArray | ZxOfArray]]
 
−
*[[Manuals/calci/filegeometry | filegeometry]]
 
−
*[[Manuals/calci/globalz3unitsymbols | globalz3unitsymbols]]
 
−
*[[Manuals/calci/globalz3unitsymbolsstring | globalz3unitsymbolsstring]]
 
−
 
−
 
−
 
−
*[[ Z3 | << Z3 Home ]]
 

Latest revision as of 18:32, 19 September 2021

LIST OF ALL FUNCTIONS

Statistical Functions1

Statistical Functions2

Math1

Math2

Date and Time1

Date and Time2

Engineering1

Engineering2

Financial1

Financial2

Geometry and Graph1

Geometry and Graph2

Information1

Information2

Logical

Database and List Management1

Database and List Management2

Lookup and Reference1

Lookup and Reference2

Text and Data1

Text and Data2

Matrix Functions1

Matrix Functions2

Other Functions1

Other Functions2

Physics & other related functions

Special Z3 Functions

Retrieved from "http://wiki.zcubes.com/index.php?title=Z_API_Functions&oldid=216746"