Difference between revisions of "Z API Functions"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | == | + | ==LIST OF ALL FUNCTIONS== |
+ | ==STATISTICAL FUNCTIONS1== | ||
+ | *[[Manuals/calci/AVEDEV | AVEDEV]] | ||
+ | *[[Manuals/calci/AVERAGE | AVERAGE]] | ||
+ | *[[Manuals/calci/AVERAGEA | AVERAGEA]] | ||
+ | *[[Manuals/calci/AVERAGEBOTTOM | AVERAGEBOTTOM]] | ||
+ | *[[Manuals/calci/AVERAGEIF | AVERAGEIF]] | ||
+ | *[[Manuals/calci/AVERAGEMIDDLE | AVERAGEMIDDLE]] | ||
+ | *[[Manuals/calci/AVERAGETOP | AVERAGETOP]] | ||
+ | *[[Manuals/calci/AVG | AVG]] | ||
+ | *[[Manuals/calci/BETA | BETA]] | ||
+ | *[[Manuals/calci/BETWEEN | BETWEEN]] | ||
+ | *[[Manuals/calci/BETWEENCORE | BETWEENCORE]] | ||
+ | *[[Manuals/calci/BINOM | BINOM]] | ||
+ | *[[Manuals/calci/BINOMIAL | BINOMIAL]] | ||
+ | *[[Manuals/calci/BINOMIALCOEFFICIENT | BINOMIALCOEFFICIENT]] | ||
+ | *[[Manuals/calci/CONFIDENCE | CONFIDENCE]] | ||
+ | *[[Manuals/calci/COUNT | COUNT]] | ||
+ | *[[Manuals/calci/COUNTA | COUNTA]] | ||
+ | *[[Manuals/calci/DECREASING | DECREASING]] | ||
+ | *[[Manuals/calci/DECREMENT | DECREMENT]] | ||
+ | *[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]] | ||
+ | *[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]] | ||
+ | *[[Manuals/calci/COUNTBLANK | COUNTBLANK]] | ||
+ | *[[Manuals/calci/COUNTIF | COUNTIF]] | ||
+ | *[[Manuals/calci/COVAR | COVAR]] | ||
+ | *[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]] | ||
+ | *[[Manuals/Manuals/calci/DET | DET]] | ||
+ | *[[Manuals/calci/DEVSQ | DEVSQ]] | ||
+ | *[[Manuals/calci/FEQ | FEQ]] | ||
+ | *[[Manuals/calci/FINV | FINV]] | ||
+ | *[[Manuals/calci/FISHER | FISHER]] | ||
+ | *[[Manuals/calci/FISHERINV | FISHERINV]] | ||
+ | *[[Manuals/calci/FLOYDSTRIANGLE | FLOYDSTRIANGLE]] | ||
+ | *[[Manuals/calci/FREQUENCY | FREQUENCY]] | ||
+ | *[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST]] | ||
+ | *[[Manuals/calci/FTEST | FTEST]] | ||
+ | *[[Manuals/calci/FTESTANALYSIS | FTESTANALYSIS]] | ||
+ | *[[Manuals/calci/GAMMADIST | GAMMADIST]] | ||
+ | *[[Manuals/calci/GAMMAFUNCTION | GAMMAFUNCTION]] | ||
+ | *[[Manuals/calci/GAMMAINV | GAMMAINV]] | ||
+ | *[[Manuals/calci/GAMMALN | GAMMALN]] | ||
+ | *[[Manuals/calci/GEOMEAN | GEOMEAN]] | ||
+ | *[[Manuals/calci/HARMEAN | HARMEAN]] | ||
+ | *[[Manuals/calci/HARMONICSERIES | HARMONICSERIES]] | ||
+ | *[[Manuals/calci/HYPGEOM | HYPGEOM]] | ||
+ | *[[Manuals/calci/HYPGEOMDIST | HYPGEOMDIST]] | ||
+ | *[[Manuals/calci/KRONECKERPRODUCT | KRONECKERPRODUCT]] | ||
+ | *[[Manuals/calci/KURT | KURT]] | ||
+ | *[[Manuals/calci/LAMDASELF | LAMDASELF]] | ||
+ | *[[Manuals/calci/LARGE | LARGE]] | ||
+ | *[[Manuals/calci/LAST | LAST]] | ||
+ | *[[Manuals/calci/LIST | LIST]] | ||
+ | *[[Manuals/calci/LISTALL | LISTALL]] | ||
+ | *[[Manuals/calci/LOGINV | LOGINV]] | ||
+ | *[[Manuals/calci/MAX | MAX]] | ||
+ | *[[Manuals/calci/MAXA | MAXA]] | ||
+ | *[[Manuals/calci/MAXIF | MAXIF]] | ||
+ | *[[Manuals/calci/MEAN | MEAN]] | ||
+ | *[[Manuals/calci/MEDIAN | MEDIAN]] | ||
+ | *[[Manuals/calci/MEDIANIF | MEDIANIF]] | ||
+ | *[[Manuals/calci/MEQUAL | MEQUAL]] | ||
+ | *[[Manuals/calci/MIN | MIN]] | ||
+ | *[[Manuals/calci/MINA | MINA]] | ||
+ | *[[Manuals/calci/MINIF | MINIF]] | ||
+ | *[[Manuals/calci/MINMAX | MINMAX]] | ||
+ | *[[Manuals/calci/MODE | MODE]] | ||
+ | *[[Manuals/calci/MODEIF | MODEIF]] | ||
+ | *[[Manuals/calci/MRSQ | MRSQ]] | ||
+ | *[[Manuals/calci/NEGBINOM | NEGBINOM]] | ||
+ | *[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST]] | ||
+ | *[[Manuals/calci/PASCALTRIANGLE | PASCALTRIANGLE]] | ||
+ | *[[Manuals/calci/PEARSON | PEARSON]] | ||
+ | *[[Manuals/calci/PERCENT | PERCENT]] | ||
+ | *[[Manuals/calci/PERCENTAGES | PERCENTAGES]] | ||
+ | *[[Manuals/calci/PERCENTILE | PERCENTILE]] | ||
+ | *[[Manuals/calci/PERCENTRANK | PERCENTRANK]] | ||
+ | *[[Manuals/calci/PERFECTNUMBERS | PERFECTNUMBERS]] | ||
+ | *[[Manuals/calci/PERMUT | PERMUT]] | ||
+ | *[[Manuals/calci/PERMUTATIONS | PERMUTATIONS]] | ||
+ | *[[Manuals/calci/PROB | PROB]] | ||
+ | *[[Manuals/calci/QUARTILE | QUARTILE]] | ||
+ | *[[Manuals/calci/QUATERNION | QUATERNION]] | ||
+ | *[[Manuals/calci/RANK | RANK]] | ||
+ | *[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE]] | ||
+ | *[[Manuals/calci/RANKS | RANKS]] | ||
+ | *[[Manuals/calci/RATIOS | RATIOS]] | ||
+ | *[[Manuals/calci/RECIPROCAL | RECIPROCAL]] | ||
+ | *[[Manuals/calci/RECIPROCALOF | RECIPROCALOF]] | ||
+ | *[[Manuals/calci/RSQ | RSQ]] | ||
+ | *[[Manuals/calci/SMALL | SMALL]] | ||
+ | *[[Manuals/calci/SMALLLETTERS | SMALLLETTERS]] | ||
+ | *[[Manuals/calci/STANDARDIZE | STANDARDIZE]] | ||
+ | *[[Manuals/calci/STDEV | STDEV]] | ||
+ | *[[Manuals/calci/STDEVA | STDEVA]] | ||
+ | *[[Manuals/calci/STDEVIF | STDEVIF]] | ||
+ | *[[Manuals/calci/STDEVP | STDEVP]] | ||
+ | *[[Manuals/calci/STDEVPA | STDEVPA]] | ||
+ | *[[Manuals/calci/STDEVPIF | STDEVPIF]] | ||
+ | *[[Manuals/calci/TDIST | TDIST]] | ||
+ | *[[Manuals/calci/TINV | TINV]] | ||
+ | *[[Manuals/calci/TOP | TOP]] | ||
+ | *[[Manuals/calci/TOPN | TOPN]] | ||
+ | *[[Manuals/calci/TOQUARTER | TOQUARTER]] | ||
+ | *[[Manuals/calci/TRIM | TRIM]] | ||
+ | *[[Manuals/calci/TRIMARRAY | TRIMARRAY]] | ||
+ | *[[Manuals/calci/TRIMMEAN | TRIMMEAN]] | ||
+ | *[[Manuals/calci/VAR | VAR]] | ||
+ | *[[Manuals/calci/VARA | VARA]] | ||
+ | *[[Manuals/calci/VARIF | VARIF]] | ||
+ | *[[Manuals/calci/VARP | VARP]] | ||
+ | *[[Manuals/calci/VARPA | VARPA]] | ||
+ | *[[Manuals/calci/VARPIF | VARPIF]] | ||
+ | *[[Manuals/calci/VARS | VARS]] | ||
+ | *[[Manuals/calci/XBETWEEN | XBETWEEN]] | ||
− | *[[ | + | ==STATISTICAL FUNCTIONS2== |
− | *[[ | + | *[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]] |
− | + | *[[Manuals/calci/BETADIST | BETADIST]] | |
− | + | *[[Manuals/calci/BETADISTX | BETADISTX]] | |
− | + | *[[Manuals/calci/BETAFUNCTION | BETAFUNCTION]] | |
+ | *[[Manuals/calci/BETAINV | BETAINV]] | ||
+ | *[[Manuals/calci/BINOMDIST | BINOMDIST]] | ||
+ | *[[Manuals/calci/BINOMIALDISTRIBUTED | BINOMIALDISTRIBUTED]] | ||
+ | *[[Manuals/calci/BINOMIALPROBABILTY | BINOMIALPROBABILTY]] | ||
+ | *[[Manuals/calci/BINOMIALSERIES | BINOMIALSERIES]] | ||
+ | *[[Manuals/calci/CHIDIST | CHIDIST]] | ||
+ | *[[Manuals/calci/CHIINV | CHIINV]] | ||
+ | *[[Manuals/calci/CHITEST | CHITEST]] | ||
+ | *[[Manuals/calci/CORREL | CORREL]] | ||
+ | *[[Manuals/calci/CORRELATIONDATAANALYSIS | CORRELATIONDATAANALYSIS]] | ||
+ | *[[Manuals/calci/CRITBINOM | CRITBINOM]] | ||
+ | *[[Manuals/calci/DISCRETEDISTRIBUTED | DISCRETEDISTRIBUTED]] | ||
+ | *[[Manuals/calci/EXPONDIST | EXPONDIST]] | ||
+ | *[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING]] | ||
+ | *[[Manuals/calci/FDIST | FDIST]] | ||
+ | *[[Manuals/calci/FORECAST | FORECAST]] | ||
+ | *[[Manuals/calci/GROWTH | GROWTH]] | ||
+ | *[[Manuals/calci/HISTOGRAM | HISTOGRAM]] | ||
+ | *[[Manuals/calci/KFUNCTION | KFUNCTION]] | ||
+ | *[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST]] | ||
+ | *[[Manuals/calci/KSTESTCORE | KSTESTCORE]] | ||
+ | *[[Manuals/calci/KSTESTEXPONENTIAL | KSTESTEXPONENTIAL]] | ||
+ | *[[Manuals/calci/KSTESTNORMAL | KSTESTNORMAL]] | ||
+ | *[[Manuals/calci/LEVENESTEST | LEVENESTEST]] | ||
+ | *[[Manuals/calci/LEVENESTESTOLD | LEVENESTESTOLD]] | ||
+ | *[[Manuals/calci/LINEST | LINEST]] | ||
+ | *[[Manuals/calci/LINKEDLIST | LINKEDLIST]] | ||
+ | *[[Manuals/calci/LINKNODE | LINKNODE]] | ||
+ | *[[Manuals/calci/LISPLIST | LISPLIST]] | ||
+ | *[[Manuals/calci/LOGNORMDIST | LOGNORMDIST]] | ||
+ | *[[Manuals/calci/MANNWHITNEYUTEST | MANNWHITNEYUTEST]] | ||
+ | *[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST]] | ||
+ | *[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE]] | ||
+ | *[[Manuals/calci/MPEARSON | MPEARSON]] | ||
+ | *[[Manuals/calci/MULTIPLEREGRESSIONANALYSIS | MULTIPLEREGRESSIONANALYSIS]] | ||
+ | *[[Manuals/calci/NORMALDISTRIBUTED | NORMALDISTRIBUTED]] | ||
+ | *[[Manuals/calci/NORMDIST | NORMDIST]] | ||
+ | *[[Manuals/calci/NORMINV | NORMINV]] | ||
+ | *[[Manuals/calci/NORMSDIST | NORMSDIST]] | ||
+ | *[[Manuals/calci/NORMSINV | NORMSINV]] | ||
+ | *[[Manuals/calci/PATTERNDISTRIBUTED | PATTERNDISTRIBUTED]] | ||
+ | *[[Manuals/calci/POISSON | POISSON]] | ||
+ | *[[Manuals/calci/POISSONDISTRIBUTED | POISSONDISTRIBUTED]] | ||
+ | *[[Manuals/calci/REGRESSIONANALYSIS | REGRESSIONANALYSIS]] | ||
+ | *[[Manuals/calci/REPEAT | REPEAT]] | ||
+ | *[[Manuals/calci/SAMPLING | SAMPLING]] | ||
+ | *[[Manuals/calci/SIGNTEST | SIGNTEST]] | ||
+ | *[[Manuals/calci/SKEW | SKEW]] | ||
+ | *[[Manuals/calci/SKEWSYMMETRIC | SKEWSYMMETRIC]] | ||
+ | *[[Manuals/calci/STATIC | STATIC]] | ||
+ | *[[Manuals/calci/STATS | STATS]] | ||
+ | *[[Manuals/calci/STEYX | STEYX]] | ||
+ | *[[Manuals/calci/TREND | TREND]] | ||
+ | *[[Manuals/calci/TTEST | TTEST]] | ||
+ | *[[Manuals/calci/TTESTPAIRED | TTESTPAIRED]] | ||
+ | *[[Manuals/calci/TTESTTWOSAMPLESEQUALVARIANCES | TTESTTWOSAMPLESEQUALVARIANCES]] | ||
+ | *[[Manuals/calci/TTESTTWOSAMPLESUNEQUALVARIANCES | TTESTTWOSAMPLESUNEQUALVARIANCES]] | ||
+ | *[[Manuals/calci/UNIFORMDISTRIBUTED | UNIFORMDISTRIBUTED]] | ||
+ | *[[Manuals/calci/WEIBULL | WEIBULL]] | ||
+ | *[[Manuals/calci/WILCOXONSIGNEDRANKTEST | WILCOXONSIGNEDRANKTEST]] | ||
+ | *[[Manuals/calci/ZTEST | ZTEST]] | ||
+ | *[[Manuals/calci/ZTESTTWOSAMPLEFORMEANS | ZTESTTWOSAMPLEFORMEANS]] | ||
+ | ==MATH1== | ||
*[[Manuals/calci/ABS | ABS]] | *[[Manuals/calci/ABS | ABS]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ACOS | ACOS]] | *[[Manuals/calci/ACOS | ACOS]] | ||
*[[Manuals/calci/ACOSH | ACOSH]] | *[[Manuals/calci/ACOSH | ACOSH]] | ||
− | |||
*[[Manuals/calci/SUM | ADD]] | *[[Manuals/calci/SUM | ADD]] | ||
*[[Manuals/calci/ADDBY | ADDBY]] | *[[Manuals/calci/ADDBY | ADDBY]] | ||
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]] | *[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]] | ||
− | |||
*[[Manuals/calci/ADDFACT | ADDFACT]] | *[[Manuals/calci/ADDFACT | ADDFACT]] | ||
− | |||
− | |||
*[[Manuals/calci/ADDWITH | ADDWITH]] | *[[Manuals/calci/ADDWITH | ADDWITH]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ANGLE | ANGLE]] | *[[Manuals/calci/ANGLE | ANGLE]] | ||
*[[Manuals/calci/ANGLEAT | ANGLEAT]] | *[[Manuals/calci/ANGLEAT | ANGLEAT]] | ||
*[[Manuals/calci/ANGLES | ANGLES]] | *[[Manuals/calci/ANGLES | ANGLES]] | ||
*[[Manuals/calci/ANGLESLIST | ANGLESLIST]] | *[[Manuals/calci/ANGLESLIST | ANGLESLIST]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ANTILOG | ANTILOG]] | *[[Manuals/calci/ANTILOG | ANTILOG]] | ||
− | + | *[[Manuals/calci/ARITHMETICSERIES |ARITHMETICSERIES]] | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | *[[Manuals/calci/ARITHMETICSERIES | ARITHMETICSERIES | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ASCENDING | ASCENDING]] | *[[Manuals/calci/ASCENDING | ASCENDING]] | ||
*[[Manuals/calci/ASIN | ASIN]] | *[[Manuals/calci/ASIN | ASIN]] | ||
*[[Manuals/calci/ASINH | ASINH]] | *[[Manuals/calci/ASINH | ASINH]] | ||
− | |||
− | |||
*[[Manuals/calci/ATAN | ATAN]] | *[[Manuals/calci/ATAN | ATAN]] | ||
*[[Manuals/calci/ATANH | ATANH]] | *[[Manuals/calci/ATANH | ATANH]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/BASETHETA | BASETHETA]] | *[[Manuals/calci/BASETHETA | BASETHETA]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/CAL | CAL]] | *[[Manuals/calci/CAL | CAL]] | ||
*[[Manuals/calci/CALC | CALC]] | *[[Manuals/calci/CALC | CALC]] | ||
*[[Manuals/calci/CALCULATE | CALCULATE]] | *[[Manuals/calci/CALCULATE | CALCULATE]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/CAR | CAR]] | *[[Manuals/calci/CAR | CAR]] | ||
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]] | *[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]] | ||
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]] | *[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/CEILING | CEILING]] | *[[Manuals/calci/CEILING | CEILING]] | ||
*[[Manuals/calci/CEILINGAT | CEILINGAT]] | *[[Manuals/calci/CEILINGAT | CEILINGAT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/CIS | CIS]] | *[[Manuals/calci/CIS | CIS]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/COMBIN | COMBIN]] | *[[Manuals/calci/COMBIN | COMBIN]] | ||
*[[Manuals/calci/COMBINATIONS | COMBINATIONS]] | *[[Manuals/calci/COMBINATIONS | COMBINATIONS]] | ||
− | |||
− | |||
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]] | *[[Manuals/calci/COMPLEMENT | COMPLEMENT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/COS | COS]] | *[[Manuals/calci/COS | COS]] | ||
*[[Manuals/calci/COSEC | COSEC]] | *[[Manuals/calci/COSEC | COSEC]] | ||
Line 200: | Line 221: | ||
*[[Manuals/calci/COTAN | COTAN]] | *[[Manuals/calci/COTAN | COTAN]] | ||
*[[Manuals/calci/COTH | COTH]] | *[[Manuals/calci/COTH | COTH]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/CROSSPRODUCT | CROSSPRODUCT]] | *[[Manuals/calci/CROSSPRODUCT | CROSSPRODUCT]] | ||
*[[Manuals/calci/CSCH | CSCH]] | *[[Manuals/calci/CSCH | CSCH]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/CUBEROOT | CUBEROOT]] | *[[Manuals/calci/CUBEROOT | CUBEROOT]] | ||
*[[Manuals/calci/CUBES | CUBES]] | *[[Manuals/calci/CUBES | CUBES]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/CYCLEWITHIN | CYCLEWITHIN]] | *[[Manuals/calci/CYCLEWITHIN | CYCLEWITHIN]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DCOS | DCOS]] | *[[Manuals/calci/DCOS | DCOS]] | ||
*[[Manuals/calci/DCOSEC | DCOSEC]] | *[[Manuals/calci/DCOSEC | DCOSEC]] | ||
*[[Manuals/calci/DCOTAN | DCOTAN]] | *[[Manuals/calci/DCOTAN | DCOTAN]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DECIMAL | DECIMAL]] | *[[Manuals/calci/DECIMAL | DECIMAL]] | ||
*[[Manuals/calci/DECIMALPART | DECIMALPART]] | *[[Manuals/calci/DECIMALPART | DECIMALPART]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DEG | DEG]] | *[[Manuals/calci/DEG | DEG]] | ||
*[[Manuals/calci/DEGREES | DEGREES]] | *[[Manuals/calci/DEGREES | DEGREES]] | ||
*[[Manuals/calci/DEGREESLIST | DEGREESLIST]] | *[[Manuals/calci/DEGREESLIST | DEGREESLIST]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/DESCENDING | DESCENDING]] | *[[Manuals/calci/DESCENDING | DESCENDING]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DIFFERENCE | DIFFERENCE]] | *[[Manuals/calci/DIFFERENCE | DIFFERENCE]] | ||
*[[Manuals/calci/DIGITS | DIGITS]] | *[[Manuals/calci/DIGITS | DIGITS]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DISTINCT | DISTINCT]] | *[[Manuals/calci/DISTINCT | DISTINCT]] | ||
*[[Manuals/calci/DISTINCTSET | DISTINCTSET]] | *[[Manuals/calci/DISTINCTSET | DISTINCTSET]] | ||
Line 299: | Line 245: | ||
*[[Manuals/calci/DIVISIONOF | DIVISIONOF]] | *[[Manuals/calci/DIVISIONOF | DIVISIONOF]] | ||
*[[Manuals/calci/DIVPARTS | DIVPARTS]] | *[[Manuals/calci/DIVPARTS | DIVPARTS]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DOTPRODUCT | DOTPRODUCT]] | *[[Manuals/calci/DOTPRODUCT | DOTPRODUCT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DSEC | DSEC]] | *[[Manuals/calci/DSEC | DSEC]] | ||
*[[Manuals/calci/DSIN | DSIN]] | *[[Manuals/calci/DSIN | DSIN]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DTAN | DTAN]] | *[[Manuals/calci/DTAN | DTAN]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/DYADIC | DYADIC]] | *[[Manuals/calci/DYADIC | DYADIC]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ELEMENTAT | ELEMENTAT]] | *[[Manuals/calci/ELEMENTAT | ELEMENTAT]] | ||
*[[Manuals/calci/ELEMENTDIS | ELEMENTDIS]] | *[[Manuals/calci/ELEMENTDIS | ELEMENTDIS]] | ||
*[[Manuals/calci/ELEMENTINARRAY | ELEMENTINARRAY]] | *[[Manuals/calci/ELEMENTINARRAY | ELEMENTINARRAY]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/EQ | EQ]] | *[[Manuals/calci/EQ | EQ]] | ||
*[[Manuals/calci/EQS | EQS]] | *[[Manuals/calci/EQS | EQS]] | ||
*[[Manuals/calci/EQUATION | EQUATION]] | *[[Manuals/calci/EQUATION | EQUATION]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/EVEN | EVEN]] | *[[Manuals/calci/EVEN | EVEN]] | ||
*[[Manuals/calci/EVENS | EVENS]] | *[[Manuals/calci/EVENS | EVENS]] | ||
Line 380: | Line 261: | ||
*[[Manuals/calci/EVENSUPTO | EVENSUPTO]] | *[[Manuals/calci/EVENSUPTO | EVENSUPTO]] | ||
*[[Manuals/calci/EVERYSET | EVERYSET]] | *[[Manuals/calci/EVERYSET | EVERYSET]] | ||
− | |||
− | |||
*[[Manuals/calci/EXP | EXP]] | *[[Manuals/calci/EXP | EXP]] | ||
*[[Manuals/calci/EXPOF | EXPOF]] | *[[Manuals/calci/EXPOF | EXPOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/FACT | FACT]] | *[[Manuals/calci/FACT | FACT]] | ||
*[[Manuals/calci/FACTDOUBLE | FACTDOUBLE]] | *[[Manuals/calci/FACTDOUBLE | FACTDOUBLE]] | ||
Line 398: | Line 268: | ||
*[[Manuals/calci/FACTS | FACTS]] | *[[Manuals/calci/FACTS | FACTS]] | ||
*[[Manuals/calci/FACTUNTIL | FACTUNTIL]] | *[[Manuals/calci/FACTUNTIL | FACTUNTIL]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/FIBONACCI | FIBONACCI]] | *[[Manuals/calci/FIBONACCI | FIBONACCI]] | ||
*[[Manuals/calci/FIBONNACI | FIBONNACI]] | *[[Manuals/calci/FIBONNACI | FIBONNACI]] | ||
− | |||
*[[Manuals/calci/FIFTHOF | FIFTHOF]] | *[[Manuals/calci/FIFTHOF | FIFTHOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/FLOOR | FLOOR]] | *[[Manuals/calci/FLOOR | FLOOR]] | ||
*[[Manuals/calci/FLOORAT | FLOORAT]] | *[[Manuals/calci/FLOORAT | FLOORAT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS]] | *[[Manuals/calci/FOURIERANALYSIS | FOURIERANALYSIS]] | ||
*[[Manuals/calci/FOURTHOF | FOURTHOF]] | *[[Manuals/calci/FOURTHOF | FOURTHOF]] | ||
*[[Manuals/calci/FOURTHROOT | FOURTHROOT]] | *[[Manuals/calci/FOURTHROOT | FOURTHROOT]] | ||
− | |||
*[[Manuals/calci/FRACTION | FRACTION]] | *[[Manuals/calci/FRACTION | FRACTION]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/GCD | GCD]] | *[[Manuals/calci/GCD | GCD]] | ||
*[[Manuals/calci/GCV | GCV]] | *[[Manuals/calci/GCV | GCV]] | ||
− | |||
*[[Manuals/calci/GE | GE]] | *[[Manuals/calci/GE | GE]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/GEOMETRICSERIES | GEOMETRICSERIES]] | *[[Manuals/calci/GEOMETRICSERIES | GEOMETRICSERIES]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/GOLDENANGLE | GOLDENANGLE]] | *[[Manuals/calci/GOLDENANGLE | GOLDENANGLE]] | ||
*[[Manuals/calci/GOLDENRATIO | GOLDENRATIO]] | *[[Manuals/calci/GOLDENRATIO | GOLDENRATIO]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/GREEK | GREEK]] | *[[Manuals/calci/GREEK | GREEK]] | ||
*[[Manuals/calci/GREEKARRAY | GREEKARRAY]] | *[[Manuals/calci/GREEKARRAY | GREEKARRAY]] | ||
*[[Manuals/calci/GREEKS | GREEKS]] | *[[Manuals/calci/GREEKS | GREEKS]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/GT | GT]] | *[[Manuals/calci/GT | GT]] | ||
*[[Manuals/calci/GTE | GTE]] | *[[Manuals/calci/GTE | GTE]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/HALFOF | HALFOF]] | *[[Manuals/calci/HALFOF | HALFOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/HUNDRED | HUNDRED]] | *[[Manuals/calci/HUNDRED | HUNDRED]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/INCREASING | INCREASING]] | *[[Manuals/calci/INCREASING | INCREASING]] | ||
*[[Manuals/calci/INCREMENT | INCREMENT]] | *[[Manuals/calci/INCREMENT | INCREMENT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/INSET | INSET]] | *[[Manuals/calci/INSET | INSET]] | ||
*[[Manuals/calci/INT | INT]] | *[[Manuals/calci/INT | INT]] | ||
*[[Manuals/calci/INTDIV | INTDIV]] | *[[Manuals/calci/INTDIV | INTDIV]] | ||
− | |||
*[[Manuals/calci/INTEGERDIVISION | INTEGERDIVISION]] | *[[Manuals/calci/INTEGERDIVISION | INTEGERDIVISION]] | ||
*[[Manuals/calci/INTEGERS | INTEGERS]] | *[[Manuals/calci/INTEGERS | INTEGERS]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/INTERSECTION | INTERSECTION]] | *[[Manuals/calci/INTERSECTION | INTERSECTION]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ITHPRIME | ITHPRIME]] | *[[Manuals/calci/ITHPRIME | ITHPRIME]] | ||
− | |||
*[[Manuals/calci/JOIN | JOIN]] | *[[Manuals/calci/JOIN | JOIN]] | ||
*[[Manuals/calci/JOINSET | JOINSET]] | *[[Manuals/calci/JOINSET | JOINSET]] | ||
*[[Manuals/calci/JPARTITION | JPARTITION]] | *[[Manuals/calci/JPARTITION | JPARTITION]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/LB | LB]] | *[[Manuals/calci/LB | LB]] | ||
*[[Manuals/calci/LBSTAR | LBSTAR]] | *[[Manuals/calci/LBSTAR | LBSTAR]] | ||
*[[Manuals/calci/LCM | LCM]] | *[[Manuals/calci/LCM | LCM]] | ||
*[[Manuals/calci/LE | LE]] | *[[Manuals/calci/LE | LE]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/LGSTAR | LGSTAR]] | *[[Manuals/calci/LGSTAR | LGSTAR]] | ||
− | |||
− | |||
*[[Manuals/calci/LINEAREQUATION | LINEAREQUATION]] | *[[Manuals/calci/LINEAREQUATION | LINEAREQUATION]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/LISTPRIMES | LISTPRIMES]] | *[[Manuals/calci/LISTPRIMES | LISTPRIMES]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/LN | LN]] | *[[Manuals/calci/LN | LN]] | ||
*[[Manuals/calci/LNSTAR | LNSTAR]] | *[[Manuals/calci/LNSTAR | LNSTAR]] | ||
− | |||
− | |||
*[[Manuals/calci/LOG | LOG]] | *[[Manuals/calci/LOG | LOG]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/LOGSTAR | LOGSTAR]] | *[[Manuals/calci/LOGSTAR | LOGSTAR]] | ||
*[[Manuals/calci/LOGVALUES | LOGVALUES]] | *[[Manuals/calci/LOGVALUES | LOGVALUES]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/LT | LT]] | *[[Manuals/calci/LT | LT]] | ||
*[[Manuals/calci/LTE | LTE]] | *[[Manuals/calci/LTE | LTE]] | ||
*[[Manuals/calci/LUCAS | LUCAS]] | *[[Manuals/calci/LUCAS | LUCAS]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/MAKEPAIR | MAKEPAIR]] | *[[Manuals/calci/MAKEPAIR | MAKEPAIR]] | ||
− | |||
*[[Manuals/calci/MAKESUBTOTAL | MAKESUBTOTAL]] | *[[Manuals/calci/MAKESUBTOTAL | MAKESUBTOTAL]] | ||
− | |||
*[[Manuals/calci/MAKEUNITVALUE | MAKEUNITVALUE]] | *[[Manuals/calci/MAKEUNITVALUE | MAKEUNITVALUE]] | ||
− | *[[Manuals/calci/ | + | *[[Manuals/calci/MAKEFRACTION | MAKEFRACTION]] |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/MINUS | MINUS]] | *[[Manuals/calci/MINUS | MINUS]] | ||
*[[Manuals/calci/MINUSOF | MINUSOF]] | *[[Manuals/calci/MINUSOF | MINUSOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/MOD | MOD]] | *[[Manuals/calci/MOD | MOD]] | ||
*[[Manuals/calci/MODBY | MODBY]] | *[[Manuals/calci/MODBY | MODBY]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/MODWITH | MODWITH]] | *[[Manuals/calci/MODWITH | MODWITH]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/MOP | MOP]] | *[[Manuals/calci/MOP | MOP]] | ||
*[[Manuals/calci/MOPWITH | MOPWITH]] | *[[Manuals/calci/MOPWITH | MOPWITH]] | ||
Line 878: | Line 338: | ||
*[[Manuals/calci/MOPWITHPOWER | MOPWITHPOWER]] | *[[Manuals/calci/MOPWITHPOWER | MOPWITHPOWER]] | ||
*[[Manuals/calci/MOPX | MOPX]] | *[[Manuals/calci/MOPX | MOPX]] | ||
− | |||
− | |||
*[[Manuals/calci/MROUND | MROUND]] | *[[Manuals/calci/MROUND | MROUND]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/MULTINOMIAL | MULTINOMIAL]] | *[[Manuals/calci/MULTINOMIAL | MULTINOMIAL]] | ||
− | |||
*[[Manuals/calci/MULTIPLES | MULTIPLES]] | *[[Manuals/calci/MULTIPLES | MULTIPLES]] | ||
*[[Manuals/calci/MULTIPLESOF | MULTIPLESOF]] | *[[Manuals/calci/MULTIPLESOF | MULTIPLESOF]] | ||
Line 893: | Line 346: | ||
*[[Manuals/calci/MULTIPLYBY | MULTIPLYBY]] | *[[Manuals/calci/MULTIPLYBY | MULTIPLYBY]] | ||
*[[Manuals/calci/MULTIPLYWITH | MULTIPLYWITH]] | *[[Manuals/calci/MULTIPLYWITH | MULTIPLYWITH]] | ||
− | |||
− | |||
*[[Manuals/calci/NEG | NEG]] | *[[Manuals/calci/NEG | NEG]] | ||
*[[Manuals/calci/NEGATE | NEGATE]] | *[[Manuals/calci/NEGATE | NEGATE]] | ||
*[[Manuals/calci/NEGATIVE | NEGATIVE]] | *[[Manuals/calci/NEGATIVE | NEGATIVE]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/NEXTPOWER | NEXTPOWER]] | *[[Manuals/calci/NEXTPOWER | NEXTPOWER]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/NTH | NTH]] | *[[Manuals/calci/NTH | NTH]] | ||
*[[Manuals/calci/NTHELEMENT | NTHELEMENT]] | *[[Manuals/calci/NTHELEMENT | NTHELEMENT]] | ||
*[[Manuals/calci/NTHROOT | NTHROOT]] | *[[Manuals/calci/NTHROOT | NTHROOT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/NUMS | NUMS]] | *[[Manuals/calci/NUMS | NUMS]] | ||
*[[Manuals/calci/NUMSCORE | NUMSCORE]] | *[[Manuals/calci/NUMSCORE | NUMSCORE]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ODD | ODD]] | *[[Manuals/calci/ODD | ODD]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ODDS | ODDS]] | *[[Manuals/calci/ODDS | ODDS]] | ||
*[[Manuals/calci/ODDSET | ODDSET]] | *[[Manuals/calci/ODDSET | ODDSET]] | ||
*[[Manuals/calci/ODDSUPTO | ODDSUPTO]] | *[[Manuals/calci/ODDSUPTO | ODDSUPTO]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ORDINAL | ORDINAL]] | *[[Manuals/calci/ORDINAL | ORDINAL]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/PLUSMINUS | PLUSMINUS]] | *[[Manuals/calci/PLUSMINUS | PLUSMINUS]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/POSITIVE | POSITIVE]] | *[[Manuals/calci/POSITIVE | POSITIVE]] | ||
*[[Manuals/calci/POWER | POWER]] | *[[Manuals/calci/POWER | POWER]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/PRIMEFACTORS | PRIMEFACTORS]] | *[[Manuals/calci/PRIMEFACTORS | PRIMEFACTORS]] | ||
*[[Manuals/calci/PRIMES | PRIMES]] | *[[Manuals/calci/PRIMES | PRIMES]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/PRODUCT | PRODUCT]] | *[[Manuals/calci/PRODUCT | PRODUCT]] | ||
*[[Manuals/calci/PRODUCTOF | PRODUCTOF]] | *[[Manuals/calci/PRODUCTOF | PRODUCTOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/QUADRATIC | QUADRATIC]] | *[[Manuals/calci/QUADRATIC | QUADRATIC]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/QUOTIENT | QUOTIENT]] | *[[Manuals/calci/QUOTIENT | QUOTIENT]] | ||
*[[Manuals/calci/RAD | RAD]] | *[[Manuals/calci/RAD | RAD]] | ||
− | |||
− | |||
*[[Manuals/calci/RADIANSLIST | RADIANSLIST]] | *[[Manuals/calci/RADIANSLIST | RADIANSLIST]] | ||
*[[Manuals/calci/RAND | RAND]] | *[[Manuals/calci/RAND | RAND]] | ||
Line 1,071: | Line 375: | ||
*[[Manuals/calci/RANDINT | RANDINT]] | *[[Manuals/calci/RANDINT | RANDINT]] | ||
*[[Manuals/calci/RANDNUM | RANDNUM]] | *[[Manuals/calci/RANDNUM | RANDNUM]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/REM | REM]] | *[[Manuals/calci/REM | REM]] | ||
*[[Manuals/calci/REMAINDER | REMAINDER]] | *[[Manuals/calci/REMAINDER | REMAINDER]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/ROMAN | ROMAN]] | *[[Manuals/calci/ROMAN | ROMAN]] | ||
*[[Manuals/calci/ROMANOLD | ROMANOLD]] | *[[Manuals/calci/ROMANOLD | ROMANOLD]] | ||
Line 1,129: | Line 387: | ||
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] | ||
*[[Manuals/calci/ROUNDUP | ROUNDUP]] | *[[Manuals/calci/ROUNDUP | ROUNDUP]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SCALARPRODUCT | SCALARPRODUCT]] | *[[Manuals/calci/SCALARPRODUCT | SCALARPRODUCT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SEC | SEC]] | *[[Manuals/calci/SEC | SEC]] | ||
*[[Manuals/calci/SECH | SECH]] | *[[Manuals/calci/SECH | SECH]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SERIES | SERIES]] | *[[Manuals/calci/SERIES | SERIES]] | ||
*[[Manuals/calci/SERIESOF | SERIESOF]] | *[[Manuals/calci/SERIESOF | SERIESOF]] | ||
Line 1,161: | Line 398: | ||
*[[Manuals/calci/SETCONVERSION | SETCONVERSION]] | *[[Manuals/calci/SETCONVERSION | SETCONVERSION]] | ||
*[[Manuals/calci/SETVALUE | SETVALUE]] | *[[Manuals/calci/SETVALUE | SETVALUE]] | ||
− | |||
− | |||
*[[Manuals/calci/SEVENTHOF | SEVENTHOF]] | *[[Manuals/calci/SEVENTHOF | SEVENTHOF]] | ||
*[[Manuals/calci/SEVERAL | SEVERAL]] | *[[Manuals/calci/SEVERAL | SEVERAL]] | ||
− | |||
− | |||
− | |||
*[[Manuals/calci/SIGMA | SIGMA]] | *[[Manuals/calci/SIGMA | SIGMA]] | ||
*[[Manuals/calci/SIGMAOF | SIGMAOF]] | *[[Manuals/calci/SIGMAOF | SIGMAOF]] | ||
*[[Manuals/calci/SIGN | SIGN]] | *[[Manuals/calci/SIGN | SIGN]] | ||
− | |||
*[[Manuals/calci/SIN | SIN]] | *[[Manuals/calci/SIN | SIN]] | ||
*[[Manuals/calci/SINC | SINC]] | *[[Manuals/calci/SINC | SINC]] | ||
Line 1,177: | Line 408: | ||
*[[Manuals/calci/SINH | SINH]] | *[[Manuals/calci/SINH | SINH]] | ||
*[[Manuals/calci/SIXTHOF | SIXTHOF]] | *[[Manuals/calci/SIXTHOF | SIXTHOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SLOG | SLOG]] | *[[Manuals/calci/SLOG | SLOG]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SORTING | SORTING]] | *[[Manuals/calci/SORTING | SORTING]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SQRT | SQRT]] | *[[Manuals/calci/SQRT | SQRT]] | ||
*[[Manuals/calci/SQRTPI | SQRTPI]] | *[[Manuals/calci/SQRTPI | SQRTPI]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SUBSET | SUBSET]] | *[[Manuals/calci/SUBSET | SUBSET]] | ||
− | |||
− | |||
*[[Manuals/calci/SUBTOTAL | SUBTOTAL]] | *[[Manuals/calci/SUBTOTAL | SUBTOTAL]] | ||
*[[Manuals/calci/SUBTRACT | SUBTRACT]] | *[[Manuals/calci/SUBTRACT | SUBTRACT]] | ||
Line 1,259: | Line 425: | ||
*[[Manuals/calci/SUMOFSQUARES | SUMOFSQUARES]] | *[[Manuals/calci/SUMOFSQUARES | SUMOFSQUARES]] | ||
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT]] | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/SUPERLOGARITHM | SUPERLOGARITHM]] | *[[Manuals/calci/SUPERLOGARITHM | SUPERLOGARITHM]] | ||
− | |||
*[[Manuals/calci/SUPERSET | SUPERSET]] | *[[Manuals/calci/SUPERSET | SUPERSET]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/TAN | TAN]] | *[[Manuals/calci/TAN | TAN]] | ||
*[[Manuals/calci/TANH | TANH]] | *[[Manuals/calci/TANH | TANH]] | ||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/TEN | TEN]] | *[[Manuals/calci/TEN | TEN]] | ||
− | |||
*[[Manuals/calci/TENTHOF | TENTHOF]] | *[[Manuals/calci/TENTHOF | TENTHOF]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/THETAINDEGREES | THETAINDEGREES]] | *[[Manuals/calci/THETAINDEGREES | THETAINDEGREES]] | ||
*[[Manuals/calci/THETAS | THETAS]] | *[[Manuals/calci/THETAS | THETAS]] | ||
− | |||
− | |||
*[[Manuals/calci/THIRDOF | THIRDOF]] | *[[Manuals/calci/THIRDOF | THIRDOF]] | ||
*[[Manuals/calci/THOUSAND | THOUSAND]] | *[[Manuals/calci/THOUSAND | THOUSAND]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/TRILLION | TRILLION]] | *[[Manuals/calci/TRILLION | TRILLION]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/TRUNC | TRUNC]] | *[[Manuals/calci/TRUNC | TRUNC]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/UNION | UNION]] | *[[Manuals/calci/UNION | UNION]] | ||
*[[Manuals/calci/UNIQUE | UNIQUE]] | *[[Manuals/calci/UNIQUE | UNIQUE]] | ||
Line 1,380: | Line 458: | ||
*[[Manuals/calci/UNITOP | UNITOP]] | *[[Manuals/calci/UNITOP | UNITOP]] | ||
*[[Manuals/calci/UNITPOWER | UNITPOWER]] | *[[Manuals/calci/UNITPOWER | UNITPOWER]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/VECTORDIRECTPRODUCT | VECTORDIRECTPRODUCT]] | *[[Manuals/calci/VECTORDIRECTPRODUCT | VECTORDIRECTPRODUCT]] | ||
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]] | *[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 13:34, 14 November 2016
LIST OF ALL FUNCTIONS
STATISTICAL FUNCTIONS1
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEBOTTOM
- AVERAGEIF
- AVERAGEMIDDLE
- AVERAGETOP
- AVG
- BETA
- BETWEEN
- BETWEENCORE
- BINOM
- BINOMIAL
- BINOMIALCOEFFICIENT
- CONFIDENCE
- COUNT
- COUNTA
- DECREASING
- DECREMENT
- DESCRIBENUMBER
- DESCRIPTIVESTATISTICS
- COUNTBLANK
- COUNTIF
- COVAR
- COVARIANCEDATAANALYSIS
- DET
- DEVSQ
- FEQ
- FINV
- FISHER
- FISHERINV
- FLOYDSTRIANGLE
- FREQUENCY
- FRIEDMANTEST
- FTEST
- FTESTANALYSIS
- GAMMADIST
- GAMMAFUNCTION
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- HARMONICSERIES
- HYPGEOM
- HYPGEOMDIST
- KRONECKERPRODUCT
- KURT
- LAMDASELF
- LARGE
- LAST
- LIST
- LISTALL
- LOGINV
- MAX
- MAXA
- MAXIF
- MEAN
- MEDIAN
- MEDIANIF
- MEQUAL
- MIN
- MINA
- MINIF
- MINMAX
- MODE
- MODEIF
- MRSQ
- NEGBINOM
- NEGBINOMDIST
- PASCALTRIANGLE
- PEARSON
- PERCENT
- PERCENTAGES
- PERCENTILE
- PERCENTRANK
- PERFECTNUMBERS
- PERMUT
- PERMUTATIONS
- PROB
- QUARTILE
- QUATERNION
- RANK
- RANKANDPERCENTILE
- RANKS
- RATIOS
- RECIPROCAL
- RECIPROCALOF
- RSQ
- SMALL
- SMALLLETTERS
- STANDARDIZE
- STDEV
- STDEVA
- STDEVIF
- STDEVP
- STDEVPA
- STDEVPIF
- TDIST
- TINV
- TOP
- TOPN
- TOQUARTER
- TRIM
- TRIMARRAY
- TRIMMEAN
- VAR
- VARA
- VARIF
- VARP
- VARPA
- VARPIF
- VARS
- XBETWEEN
STATISTICAL FUNCTIONS2
- BERNOULLIDISTRIBUTED
- BETADIST
- BETADISTX
- BETAFUNCTION
- BETAINV
- BINOMDIST
- BINOMIALDISTRIBUTED
- BINOMIALPROBABILTY
- BINOMIALSERIES
- CHIDIST
- CHIINV
- CHITEST
- CORREL
- CORRELATIONDATAANALYSIS
- CRITBINOM
- DISCRETEDISTRIBUTED
- EXPONDIST
- EXPONENTIALSMOOTHING
- FDIST
- FORECAST
- GROWTH
- HISTOGRAM
- KFUNCTION
- KRUSKALWALLISTEST
- KSTESTCORE
- KSTESTEXPONENTIAL
- KSTESTNORMAL
- LEVENESTEST
- LEVENESTESTOLD
- LINEST
- LINKEDLIST
- LINKNODE
- LISPLIST
- LOGNORMDIST
- MANNWHITNEYUTEST
- MOODSMEDIANTEST
- MOVINGAVERAGE
- MPEARSON
- MULTIPLEREGRESSIONANALYSIS
- NORMALDISTRIBUTED
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PATTERNDISTRIBUTED
- POISSON
- POISSONDISTRIBUTED
- REGRESSIONANALYSIS
- REPEAT
- SAMPLING
- SIGNTEST
- SKEW
- SKEWSYMMETRIC
- STATIC
- STATS
- STEYX
- TREND
- TTEST
- TTESTPAIRED
- TTESTTWOSAMPLESEQUALVARIANCES
- TTESTTWOSAMPLESUNEQUALVARIANCES
- UNIFORMDISTRIBUTED
- WEIBULL
- WILCOXONSIGNEDRANKTEST
- ZTEST
- ZTESTTWOSAMPLEFORMEANS
MATH1
- ABS
- ACOS
- ACOSH
- ADD
- ADDBY
- ADDCLAUSE
- ADDFACT
- ADDWITH
- ANGLE
- ANGLEAT
- ANGLES
- ANGLESLIST
- ANTILOG
- ARITHMETICSERIES
- ASCENDING
- ASIN
- ASINH
- ATAN
- ATANH
- BASETHETA
- CAL
- CALC
- CALCULATE
- CAR
- CARTESIANPRODUCT
- CARTESIANPRODUCTWITHOUTFLATTEN
- CEILING
- CEILINGAT
- CIS
- COMBIN
- COMBINATIONS
- COMPLEMENT
- COS
- COSEC
- COSH
- COTAN
- COTH
- CROSSPRODUCT
- CSCH
- CUBEROOT
- CUBES
- CYCLEWITHIN
- DCOS
- DCOSEC
- DCOTAN
- DECIMAL
- DECIMALPART
- DEG
- DEGREES
- DEGREESLIST
- DESCENDING
- DIFFERENCE
- DIGITS
- DISTINCT
- DISTINCTSET
- DIVIDE
- DIVIDEBY
- DIVIDEWITH
- DIVISION
- DIVISIONOF
- DIVPARTS
- DOTPRODUCT
- DSEC
- DSIN
- DTAN
- DYADIC
- ELEMENTAT
- ELEMENTDIS
- ELEMENTINARRAY
- EQ
- EQS
- EQUATION
- EVEN
- EVENS
- EVENSET
- EVENSUPTO
- EVERYSET
- EXP
- EXPOF
- FACT
- FACTDOUBLE
- FACTORIAL
- FACTS
- FACTUNTIL
- FIBONACCI
- FIBONNACI
- FIFTHOF
- FLOOR
- FLOORAT
- FOURIERANALYSIS
- FOURTHOF
- FOURTHROOT
- FRACTION
- GCD
- GCV
- GE
- GEOMETRICSERIES
- GOLDENANGLE
- GOLDENRATIO
- GREEK
- GREEKARRAY
- GREEKS
- GT
- GTE
- HALFOF
- HUNDRED
- INCREASING
- INCREMENT
- INSET
- INT
- INTDIV
- INTEGERDIVISION
- INTEGERS
- INTERSECTION
- ITHPRIME
- JOIN
- JOINSET
- JPARTITION
- LB
- LBSTAR
- LCM
- LE
- LGSTAR
- LINEAREQUATION
- LISTPRIMES
- LN
- LNSTAR
- LOG
- LOGSTAR
- LOGVALUES
- LT
- LTE
- LUCAS
- MAKEPAIR
- MAKESUBTOTAL
- MAKEUNITVALUE
- MAKEFRACTION
- MINUS
- MINUSOF
- MOD
- MODBY
- MODWITH
- MOP
- MOPWITH
- MOPWITHEQ
- MOPWITHFEQ
- MOPWITHGT
- MOPWITHGTE
- MOPWITHLT
- MOPWITHLTE
- MOPWITHMOD
- MOPWITHNE
- MOPWITHPOWER
- MOPX
- MROUND
- MULTINOMIAL
- MULTIPLES
- MULTIPLESOF
- MULTIPLESTWO
- MULTIPLY
- MULTIPLYBY
- MULTIPLYWITH
- NEG
- NEGATE
- NEGATIVE
- NEXTPOWER
- NTH
- NTHELEMENT
- NTHROOT
- NUMS
- NUMSCORE
- ODD
- ODDS
- ODDSET
- ODDSUPTO
- ORDINAL
- PLUSMINUS
- POSITIVE
- POWER
- PRIMEFACTORS
- PRIMES
- PRODUCT
- PRODUCTOF
- QUADRATIC
- QUOTIENT
- RAD
- RADIANSLIST
- RAND
- RANDBETWEEN
- RANDINT
- RANDNUM
- REM
- REMAINDER
- ROMAN
- ROMANOLD
- ROOTNTH
- ROOTNTHFUNCTION
- ROOTTHETA
- ROOTTHETATOQUARDRANT
- ROUND
- ROUNDAT
- ROUNDDOWN
- ROUNDUP
- SCALARPRODUCT
- SEC
- SECH
- SERIES
- SERIESOF
- SERIESSTR
- SERIESSUM
- SERIESTERMS
- SET
- SETCONVERSION
- SETVALUE
- SEVENTHOF
- SEVERAL
- SIGMA
- SIGMAOF
- SIGN
- SIN
- SINC
- SINCP
- SINH
- SIXTHOF
- SLOG
- SORTING
- SQRT
- SQRTPI
- SUBSET
- SUBTOTAL
- SUBTRACT
- SUBTRACTBY
- SUBTRACTFROM
- SUBTRACTWITH
- SUM
- SUMBY
- SUMFACTORS
- SUMIF
- SUMOF
- SUMOFSQUARES
- SUMPRODUCT
- SUPERLOGARITHM
- SUPERSET
- TAN
- TANH
- TEN
- TENTHOF
- THETAINDEGREES
- THETAS
- THIRDOF
- THOUSAND
- TRILLION
- TRUNC
- UNION
- UNIQUE
- UNIQUESET
- UNIQUESUBSTRINGS
- UNITADD
- UNITDIVIDE
- UNITEQ
- UNITEQS
- UNITEXPRESSION
- UNITGE
- UNITGT
- UNITIFY
- UNITLE
- UNITLT
- UNITMINUS
- UNITMOD
- UNITMULTIPLY
- UNITNE
- UNITNES
- UNITOP
- UNITPOWER
- VECTORDIRECTPRODUCT
- VECTORPRODUCT