Difference between revisions of "Z API Functions"
Jump to navigation
Jump to search
(→MATH1) |
|||
| Line 208: | Line 208: | ||
*[[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]] | ||
| Line 602: | Line 460: | ||
*[[Manuals/calci/VECTORDIRECTPRODUCT | VECTORDIRECTPRODUCT]] | *[[Manuals/calci/VECTORDIRECTPRODUCT | VECTORDIRECTPRODUCT]] | ||
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]] | *[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]] | ||
| + | |||
| + | ==MATH2== | ||
| + | *[[Manuals/calci/ACKERMANN | ACKERMANN]] | ||
| + | *[[Manuals/calci/ADDINS | ADDINS]] | ||
| + | *[[Manuals/calci/ARITHMETICSERIESCORE | ARITHMETICSERIESCORE]] | ||
| + | *[[Manuals/calci/CREATEEQUATION | CREATEEQUATION]] | ||
| + | *[[Manuals/calci/CREATEFORMULA | CREATEFORMULA]] | ||
| + | *[[Manuals/calci/DELTA | DELTA]] | ||
| + | *[[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/CLOCK | CLOCK]] | ||
| + | *[[Manuals/calci/CALENDER | CALENDER]] | ||
| + | *[[Manuals/calci/DATE | DATE]] | ||
| + | *[[Manuals/calci/DATESERIAL | DATESERIAL]] | ||
| + | *[[Manuals/calci/DATESTRING | DATESTRING]] | ||
| + | *[[Manuals/calci/DATETOEXCEL | DATETOEXCEL]] | ||
| + | *[[Manuals/calci/DATETOJS | DATETOJS]] | ||
| + | *[[Manuals/calci/DATEVALUE | DATEVALUE]] | ||
| + | *[[Manuals/calci/DAY | DAY]] | ||
| + | *[[Manuals/calci/DAYINDEX | DAYINDEX]] | ||
| + | *[[Manuals/calci/DAYS | DAYS]] | ||
| + | *[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN]] | ||
| + | *[[Manuals/calci/DAYSBETWEENBASIS | DAYSBETWEENBASIS]] | ||
| + | *[[Manuals/calci/DAYSINYEAR | DAYSINYEAR]] | ||
| + | *[[Manuals/calci/DAYSINYEARTILLDATE | DAYSINYEARTILLDATE]] | ||
| + | *[[Manuals/calci/EDATE | EDATE]] | ||
| + | *[[Manuals/calci/EOMONTH | EOMONTH]] | ||
| + | *[[Manuals/calci/FORMATTIME | FORMATTIME]] | ||
| + | *[[Manuals/calci/FROMTO | FROMTO]] | ||
| + | *[[Manuals/calci/FROMTOADV | FROMTOADV]] | ||
| + | *[[Manuals/calci/GREGORIANDATE | GREGORIANDATE]] | ||
| + | *[[Manuals/calci/HOUR | HOUR]] | ||
| + | *[[Manuals/calci/JULIANDATE | JULIANDATE]] | ||
| + | *[[Manuals/calci/MINUTE | MINUTE]] | ||
| + | *[[Manuals/calci/MONTH | MONTH]] | ||
| + | *[[Manuals/calci/MONTHEND | MONTHEND]] | ||
| + | *[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]] | ||
| + | *[[Manuals/calci/MONTHS | MONTHS]] | ||
| + | *[[Manuals/calci/MONTHSTRING | MONTHSTRING]] | ||
| + | *[[Manuals/calci/NETWORKDAYS | NETWORKDAYS]] | ||
| + | *[[Manuals/calci/SECOND | SECOND]] | ||
| + | *[[Manuals/calci/TIME | TIME]] | ||
| + | *[[Manuals/calci/TODATE | TODATE]] | ||
| + | *[[Manuals/calci/TODAY | TODAY]] | ||
| + | *[[Manuals/calci/TOMONTH | TOMONTH]] | ||
| + | *[[Manuals/calci/TONUMBER | TONUMBER]] | ||
| + | *[[Manuals/calci/WEEKDAY | WEEKDAY]] | ||
| + | *[[Manuals/calci/WEEKNUM | WEEKNUM]] | ||
| + | *[[Manuals/calci/WORKDAY | WORKDAY]] | ||
| + | *[[Manuals/calci/YEAR | YEAR]] | ||
| + | *[[Manuals/calci/YEARBASIS | YEARBASIS]] | ||
| + | *[[Manuals/calci/YEARFRAC | YEARFRAC]] | ||
| + | ==DATE AND TIME2== | ||
| + | *[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]] | ||
| + | *[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]] | ||
| + | *[[Manuals/calci/TIMEVALUE | TIMEVALUE]] | ||
| + | ==ENGINEERING1== | ||
| + | *[[Manuals/calci/ARGS | ARGS]] | ||
| + | *[[Manuals/calci/ARGSONE | ARGSONE]] | ||
| + | *[[Manuals/calci/COMPLEX | COMPLEX]] | ||
| + | *[[Manuals/calci/COMPLEXNUM | COMPLEXNUM]] | ||
| + | *[[Manuals/calci/COMPLEXNUMBER | COMPLEXNUMBER]] | ||
| + | *[[Manuals/calci/CONVERT | CONVERT]] | ||
| + | *[[Manuals/calci/CONVERTCORE | CONVERTCORE]] | ||
| + | *[[Manuals/calci/ERF | ERF]] | ||
| + | *[[Manuals/calci/ERFC | ERFC]] | ||
| + | *[[Manuals/calci/ERROR | ERROR]] | ||
| + | *[[Manuals/calci/ERRORTYPE | ERRORTYPE]] | ||
| + | *[[Manuals/calci/ERRORTYPES | ERRORTYPES]] | ||
| + | *[[Manuals/calci/GESTEP | GESTEP]] | ||
| + | *[[Manuals/calci/GFUNCTION | GFUNCTION]] | ||
| + | *[[Manuals/calci/HEX | HEX]] | ||
| + | *[[Manuals/calci/IMABS | IMABS]] | ||
| + | *[[Manuals/calci/IMAGINARY | IMAGINARY]] | ||
| + | *[[Manuals/calci/IMARGUMENT | IMARGUMENT]] | ||
| + | *[[Manuals/calci/IMCONJUGATE | IMCONJUGATE]] | ||
| + | *[[Manuals/calci/IMCOS | IMCOS]] | ||
| + | *[[Manuals/calci/IMCOSH | IMCOSH]] | ||
| + | *[[Manuals/calci/IMCOT | IMCOT]] | ||
| + | *[[Manuals/calci/IMCOTH | IMCOTH]] | ||
| + | *[[Manuals/calci/IMCSC | IMCSC]] | ||
| + | *[[Manuals/calci/IMCSCH | IMCSCH]] | ||
| + | *[[Manuals/calci/IMDIV | IMDIV]] | ||
| + | *[[Manuals/calci/IMDIVTWO | IMDIVTWO]] | ||
| + | *[[Manuals/calci/IMEXP | IMEXP]] | ||
| + | *[[Manuals/calci/IMLN | IMLN]] | ||
| + | *[[Manuals/calci/IMLOG | IMLOG]] | ||
| + | *[[Manuals/calci/IMPOWER | IMPOWER]] | ||
| + | *[[Manuals/calci/IMPRODUCT | IMPRODUCT]] | ||
| + | *[[Manuals/calci/IMPRODUCTTWO | IMPRODUCTTWO]] | ||
| + | *[[Manuals/calci/IMREAL | IMREAL]] | ||
| + | *[[Manuals/calci/IMSEC | IMSEC]] | ||
| + | *[[Manuals/calci/IMSECH | IMSECH]] | ||
| + | *[[Manuals/calci/IMSIN | IMSIN]] | ||
| + | *[[Manuals/calci/IMSINH | IMSINH]] | ||
| + | *[[Manuals/calci/IMSQRT | IMSQRT]] | ||
| + | *[[Manuals/calci/IMSTRING | IMSTRING]] | ||
| + | *[[Manuals/calci/IMSUB | IMSUB]] | ||
| + | *[[Manuals/calci/IMSUBTWO | IMSUBTWO]] | ||
| + | *[[Manuals/calci/IMSUM | IMSUM]] | ||
| + | *[[Manuals/calci/IMSUMTWO | IMSUMTWO]] | ||
| + | *[[Manuals/calci/IMTAN | IMTAN]] | ||
| + | *[[Manuals/calci/IMTANH | IMTANH]] | ||
| + | *[[Manuals/calci/MAKECOMPLEXIMINUS | MAKECOMPLEXIMINUS]] | ||
| + | *[[Manuals/calci/MAKECOMPLEXIMINUSSIMPLE | MAKECOMPLEXIMINUSSIMPLE]] | ||
| + | *[[Manuals/calci/MAKECOMPLEXIPLUS | MAKECOMPLEXIPLUS]] | ||
| + | *[[Manuals/calci/MAKECOMPLEXISIMPLE | MAKECOMPLEXISIMPLE]] | ||
| + | *[[Manuals/calci/REMOVECONVERSION | REMOVECONVERSION]] | ||
| + | *[[Manuals/calci/REMOVENUMBERS | REMOVENUMBERS]] | ||
| + | *[[Manuals/calci/TOUNITS | TOUNITS]] | ||
| + | *[[Manuals/calci/UNITS | UNITS]] | ||
| + | *[[Manuals/calci/UNITSFAILTONULL | UNITSFAILTONULL]] | ||
| + | *[[Manuals/calci/UNITSOF | UNITSOF]] | ||
| + | ==ENGINEERING2== | ||
| + | *[[Manuals/calci/BESSELI | BESSELI]] | ||
| + | *[[Manuals/calci/BESSELJ | BESSELJ]] | ||
| + | *[[Manuals/calci/BESSELK | BESSELK]] | ||
| + | *[[Manuals/calci/BESSELY | BESSELY]] | ||
| + | *[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]] | ||
Revision as of 15:30, 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
MATH2
- ACKERMANN
- ADDINS
- ARITHMETICSERIESCORE
- CREATEEQUATION
- CREATEFORMULA
- DELTA
- DERIVATIVEOFFUNCTION
- ENFORCEINTEGER
- ENFORCENATURAL
- ENFORCENEGATIVE
- ENFORCENEGATIVEINTEGER
- ENFORCENEGZEROPOS
- ENFORCEPOSITIVE
- ENFORCEPOSITIVEINTEGER
- ENFORCETYPE
- ENFORCEZERO
- EVALX
- FLATTEN
- INTEGRATE
- INTEGRATEFOR
- INTEGRATEFORCORE
- INTEGRATEUNTIL
- INTS
- INTSTWO
- NEWCALCI
- NEWFUNCTIONNAME
- QUALITATIVEDESCRIPTION
- SUMSQ
- SUMWITH
- TETRATE
DATE AND TIME1
- ADDDATE
- CLOCK
- CALENDER
- DATE
- DATESERIAL
- DATESTRING
- DATETOEXCEL
- DATETOJS
- DATEVALUE
- DAY
- DAYINDEX
- DAYS
- DAYSBETWEEN
- DAYSBETWEENBASIS
- DAYSINYEAR
- DAYSINYEARTILLDATE
- EDATE
- EOMONTH
- FORMATTIME
- FROMTO
- FROMTOADV
- GREGORIANDATE
- HOUR
- JULIANDATE
- MINUTE
- MONTH
- MONTHEND
- MONTHENDLEAP
- MONTHS
- MONTHSTRING
- NETWORKDAYS
- SECOND
- TIME
- TODATE
- TODAY
- TOMONTH
- TONUMBER
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARBASIS
- YEARFRAC
DATE AND TIME2
ENGINEERING1
- ARGS
- ARGSONE
- COMPLEX
- COMPLEXNUM
- COMPLEXNUMBER
- CONVERT
- CONVERTCORE
- ERF
- ERFC
- ERROR
- ERRORTYPE
- ERRORTYPES
- GESTEP
- GFUNCTION
- HEX
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCOTH
- IMCSC
- IMCSCH
- IMDIV
- IMDIVTWO
- IMEXP
- IMLN
- IMLOG
- IMPOWER
- IMPRODUCT
- IMPRODUCTTWO
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSTRING
- IMSUB
- IMSUBTWO
- IMSUM
- IMSUMTWO
- IMTAN
- IMTANH
- MAKECOMPLEXIMINUS
- MAKECOMPLEXIMINUSSIMPLE
- MAKECOMPLEXIPLUS
- MAKECOMPLEXISIMPLE
- REMOVECONVERSION
- REMOVENUMBERS
- TOUNITS
- UNITS
- UNITSFAILTONULL
- UNITSOF