Difference between revisions of "Z API Functions"
Jump to navigation
Jump to search
| Line 1,009: | Line 1,009: | ||
*[[Manuals/calci/GETCONVERSION | GETCONVERSION]] | *[[Manuals/calci/GETCONVERSION | GETCONVERSION]] | ||
*[[Manuals/calci/GETFUNCTION | GETFUNCTION]] | *[[Manuals/calci/GETFUNCTION | GETFUNCTION]] | ||
| − | + | *[[Manuals/calci/GETFUNCTIONSET | GETFUNCTIONSET]] | |
| − | + | *[[Manuals/calci/GETGPS | GETGPS]] | |
| − | + | *[[Manuals/calci/GETJSON | GETJSON]] | |
| − | + | *[[Manuals/calci/GETLINE | GETLINE]] | |
| − | + | *[[Manuals/calci/GETNUMBERTAIL | GETNUMBERTAIL]] | |
| − | + | *[[Manuals/calci/GETREALORCOMPLEX | GETREALORCOMPLEX]] | |
| − | + | *[[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/NUMBERFIVE | NUMBERFIVE]] | |
| − | + | *[[Manuals/calci/NUMBERFOUR | NUMBERFOUR]] | |
| − | + | *[[Manuals/calci/NUMBERNINE | NUMBERNINE]] | |
| − | + | *[[Manuals/calci/NUMBERONE | NUMBERONE]] | |
| − | + | *[[Manuals/calci/NUMBERSEVEN | NUMBERSEVEN]] | |
| − | + | *[[Manuals/calci/NUMBERSIX | NUMBERSIX]] | |
| − | + | *[[Manuals/calci/NUMBERTEN | NUMBERTEN]] | |
| − | + | *[[Manuals/calci/NUMBERTHREE | NUMBERTHREE]] | |
| − | + | *[[Manuals/calci/NUMBERTWO | NUMBERTWO]] | |
| − | + | *[[Manuals/calci/NUMBERZERO | NUMBERZERO]] | |
| − | + | *[[Manuals/calci/ONE | ONE]] | |
| − | + | *[[Manuals/calci/ONEBY | ONEBY]] | |
| − | + | *[[Manuals/calci/PARSE | PARSE]] | |
| − | + | *[[Manuals/calci/PARSELISP | PARSELISP]] | |
| − | + | *[[Manuals/calci/PARSENUMBER | PARSENUMBER]] | |
| − | + | *[[Manuals/calci/PARSESQL | PARSESQL]] | |
| − | + | *[[Manuals/calci/PARSESTRINGWITHOUTPARANTHESIS | PARSESTRINGWITHOUTPARANTHESIS]] | |
| − | + | *[[Manuals/calci/PASTECOLUMNS | PASTECOLUMNS]] | |
| − | + | *[[Manuals/calci/PASTEROWS | PASTEROWS]] | |
| − | + | *[[Manuals/calci/PAUSE | PAUSE]] | |
| − | + | *[[Manuals/calci/QUOTE | QUOTE]] | |
| − | + | *[[Manuals/calci/ROW | ROW]] | |
| − | + | *[[Manuals/calci/ROWS | ROWS]] | |
| − | + | *[[Manuals/calci/ROWWITH | ROWWITH]] | |
| − | + | *[[Manuals/calci/SMILE | SMILE]] | |
| − | + | *[[Manuals/calci/UNDEFINED | UNDEFINED]] | |
| − | + | *[[Manuals/calci/UPTO | UPTO]] | |
| − | + | *[[Manuals/calci/VLOOKUP | VLOOKUP]] | |
| − | + | ==Lookup and Reference2== | |
| − | + | *[[Manuals/calci/ANALYZE | ANALYZE]] | |
| − | Lookup and Reference2 | + | *[[Manuals/calci/ASSIGN | ASSIGN]] |
| − | + | *[[Manuals/calci/ASYNCITERATE | ASYNCITERATE]] | |
| − | + | *[[Manuals/calci/ATTRTOPROP | ATTRTOPROP]] | |
| − | + | *[[Manuals/calci/CASE | CASE]] | |
| − | + | *[[Manuals/calci/CASEIF | CASEIF]] | |
| − | + | *[[Manuals/calci/CDR | CDR]] | |
| − | + | *[[Manuals/calci/EFFECTCOLORBOOK | EFFECTCOLORBOOK]] | |
| − | + | *[[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/GETCELLTD | GETCELLTD]] | |
| − | + | *[[Manuals/calci/GETLATLONG | GETLATLONG]] | |
| − | + | *[[Manuals/calci/GKMAPPING | GKMAPPING]] | |
| − | + | *[[Manuals/calci/PENTATE | PENTATE]] | |
| − | + | *[[Manuals/calci/QPIVOT | QPIVOT]] | |
| − | + | *[[Manuals/calci/QPIVOTINCUBE | QPIVOTINCUBE]] | |
| − | + | *[[Manuals/calci/SAFEEVAL | SAFEEVAL]] | |
| − | + | *[[Manuals/calci/STEPLOOP | STEPLOOP]] | |
| − | + | *[[Manuals/calci/TIMER | TIMER]] | |
| − | + | *[[Manuals/calci/TIMES | TIMES]] | |
| − | + | *[[Manuals/calci/TIMESTRING | TIMESTRING]] | |
| − | + | *[[Manuals/calci/TYPE | TYPE]] | |
| − | + | *[[Manuals/calci/TZ | TZ]] | |
| − | + | *[[Manuals/calci/XLBETWEEN | XLBETWEEN]] | |
| − | + | *[[Manuals/calci/XLRBETWEEN | XLRBETWEEN]] | |
| − | + | *[[Manuals/calci/XPY | XPY]] | |
| − | + | *[[Manuals/calci/XRBETWEEN | XRBETWEEN]] | |
| − | + | *[[Manuals/calci/XSY | XSY]] | |
| − | + | ==Text and Data1== | |
| − | + | *[[Manuals/calci/BADWORDS | BADWORDS]] | |
| − | + | *[[Manuals/calci/CHAR | CHAR]] | |
| − | Text and Data1 | + | *[[Manuals/calci/CHR | CHR]] |
| − | + | *[[Manuals/calci/CLAUSES | CLAUSES]] | |
| − | + | *[[Manuals/calci/CLEAN | CLEAN]] | |
| − | + | *[[Manuals/calci/CLEAR | CLEAR]] | |
| − | + | *[[Manuals/calci/CLS | CLS]] | |
| − | + | *[[Manuals/calci/CODE | CODE]] | |
| − | + | *[[Manuals/calci/DEFAULT | DEFAULT]] | |
| − | + | *[[Manuals/calci/DEFAULTNUMBER | DEFAULTNUMBER]] | |
| − | + | *[[Manuals/calci/DEFAULTPROPER | DEFAULTPROPER]] | |
| − | + | *[[Manuals/calci/DEFUN | DEFUN]] | |
| − | + | *[[Manuals/calci/DES | DES]] | |
| − | + | *[[Manuals/calci/DESCRIBEFUNCTIONCALLMISSING | DESCRIBEFUNCTIONCALLMISSING]] | |
| − | + | *[[Manuals/calci/DEVARRAY | DEVARRAY]] | |
| − | + | *[[Manuals/calci/DIM | DIM]] | |
| − | + | *[[Manuals/calci/DIMENSIONS | DIMENSIONS]] | |
| − | + | *[[Manuals/calci/DIS | DIS]] | |
| − | + | *[[Manuals/calci/EIGHTHOF | EIGHTHOF]] | |
| − | + | *[[Manuals/calci/ESCAPE | ESCAPE]] | |
| − | + | *[[Manuals/calci/EXTRACTNUMBERS | EXTRACTNUMBERS]] | |
| − | + | *[[Manuals/calci/EXTRACTTEXT | EXTRACTTEXT]] | |
| − | + | *[[Manuals/calci/FAIL | FAIL]] | |
| − | + | *[[Manuals/calci/FIND | FIND]] | |
| − | + | *[[Manuals/calci/FINDB | FINDB]] | |
| − | + | *[[Manuals/calci/FINDUNIT | FINDUNIT]] | |
| − | + | *[[Manuals/calci/FIXCHARS | FIXCHARS]] | |
| − | + | *[[Manuals/calci/FIXED | FIXED]] | |
| − | + | *[[Manuals/calci/FIXEDBAD | FIXEDBAD]] | |
| − | + | *[[Manuals/calci/FOR | FOR]] | |
| − | + | *[[Manuals/calci/FORALL | FORALL]] | |
| − | + | *[[Manuals/calci/FOREACH | FOREACH]] | |
| − | + | *[[Manuals/calci/FORLOOP | FORLOOP]] | |
| − | + | *[[Manuals/calci/LEFTB | LEFTB]] | |
| − | + | *[[Manuals/calci/LEN | LEN]] | |
| − | + | *[[Manuals/calci/LENB | LENB]] | |
| − | + | *[[Manuals/calci/LETTERS | LETTERS]] | |
| − | + | *[[Manuals/calci/LOWER | LOWER]] | |
| − | + | *[[Manuals/calci/LOWERCASE | LOWERCASE]] | |
| − | + | *[[Manuals/calci/LZ | LZ]] | |
| − | + | *[[Manuals/calci/LZWCOMPRESS | LZWCOMPRESS]] | |
| − | + | *[[Manuals/calci/LZWDECOMPRESS | LZWDECOMPRESS]] | |
| − | + | *[[Manuals/calci/MID | MID]] | |
| − | + | *[[Manuals/calci/MIDB | MIDB]] | |
| − | + | *[[Manuals/calci/MIDDLE | MIDDLE]] | |
| − | + | *[[Manuals/calci/MIDN | MIDN]] | |
| − | + | *[[Manuals/calci/MIXEDCASE | MIXEDCASE]] | |
| − | + | *[[Manuals/calci/NOK | NOK]] | |
| − | + | *[[Manuals/calci/NONFALSEVALUE | NONFALSEVALUE]] | |
| − | + | *[[Manuals/calci/NONNEGATIVE | NONNEGATIVE]] | |
| − | + | *[[Manuals/calci/NONPOSITIVE | NONPOSITIVE]] | |
| − | |||
| − | |||
| − | |||
NON ZERO - *[[Manuals/calci/NONZERO | NONZERO]] | NON ZERO - *[[Manuals/calci/NONZERO | NONZERO]] | ||
NON ZERO VALUE - *[[Manuals/calci/NONZEROVALUE | NONZEROVALUE]] | NON ZERO VALUE - *[[Manuals/calci/NONZEROVALUE | NONZEROVALUE]] | ||
Revision as of 15:53, 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
ENGINEERING2
FINANCIAL1
- ACCRINT
- AMORLINC
- CAGR
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DOLLAR
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- EFFECTBULGE
- EURO
- EUROCONVERT
- FV
- FVIF
- FVIFA
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- LOGEST
- MDURATION
- MIRR
- NPER
- NPV
- PMT
- PMTLISTING
- PPMT
- PV
- PVEQUATION
- PVIF
- PVIFA
- RATE
- RECEIVED
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- USDOLLAR
- XNPV
FINANCIAL2
- ACCRINTM
- AMORDEGRC
- NOMINAL
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OPTIONSECURITY
- PRICE
- PRICEDISC
- PRICEMAT
- PUTOPTION
- SLN
- SYD
- VDB
- XIRR
- YIELD
- YIELDDISC
- YIELDMAT
- YMXC
GEOMETRY AND GRAPH1
- BARCHART
- BARHIERARCHY
- CHORDDIAGRAM
- CHORDMATRIXDIAGRAM
- CIRCLE
- CIRCLEPACKING
- CIRCLEWITHTEXT
- CUBE
- CUBEDEV
- CURVE
- DRAW
- DRAWDATACURVE
- DRAWSHAPE
- EDGEBUNDLING
- ELLIPSE
- FROMTOGEOMETRIC
- FRACTAL
- GEOMETRY
- GRAPH
- HYPOTENUSE
- INQUADRANT
- INQUADRANTSIGN
- INQUADRANTTHETA
- INTERCEPT
- LINE
- LISSAJOUS
- LISSAJOUSCURVE
- MAKEZCIRCLE
- MANDELBROT
- PIECHART
- PLOT
- POINT
- POINTAT
- POLYGON
- RECTANGLE
- SHAPE
- SLOPE
- SOR
- SORT
- SPHERE
- SQUARES
- STAR
- STARS
- TETRA
- TETRAHEDRON
- TETRAHEDRONDEV
- TRIANGLE
- XYPOINT
GEOMETRY AND GRAPH2
- BUBBLECHART
- CLOSEDCURVE
- CLUSTERDENDROGRAM
- DRAGON
- FD
- FDZ
- filegeometry
- PLOTDEV
- STEMANDLEAFPLOT
- SURFACEGRAPH
- SURFACEGRAPHCORE
- TORUS
INFORMATION1
- APPLY
- APPLYFUNCTIONTOALLELEMENTS
- APPLYFUNCTIONTOELEMENTS
- APPLYFUNCTIONTORANGE
- APPLYOF
- APPLYTOALLKEYS
- APPLYTOKEYS
- ATOZ
- BADWORDS
- BG
- BILLION
- BOLD
- BOTTOM
- BOTTOMN
- CALENDARPLOT
- CAPITALLETTERS
- CELL
- COMMENTGET
- COMPARE
- CONS
- CONST
- CONSTANTS
- DE
- DECLARE
- DECR
- EXEC
- FORMATRANGE
- FORMATWITHRANGES
- GDIM
- GOALSEEK
- GOTO
- GOV
- HEART
- HREF
- HTML
- HYPERLINK
- IN
- INARRAY
- INCR
- ISARRAY
- ISARRAYORSUCH
- ISARRAYORSUCHNOTSTRING
- ISATOMICSYMBOL
- ISBLANK
- ISBOOLEAN
- ISCOMPLEX
- ISELEMENTLIKECOMPLEX
- ISEMPTY
- ISEQUATION
- ISERR
- ISERROR
- ISEVEN
- ISFUNCTION
- ISFUNCTIONSYMBOL
- ISIGNOREINDEX
- ISINARRAY
- ISLAMBDAEQUATION
- ISLEAPYEAR
- ISLIKELYTYPE
- ISLOCATION
- ISLOGICAL
- ISLOWER
- ISMONTH
- ISNA
- ISNONTEXT
- ISNULL
- ISNULLLIKE
- ISNUMBER
- ISNUMBERSYMBOLS
- ISOBJECT
- ISODD
- ISOPERATORSYMBOL
- ISPERFECTNUMBER
- ISPOINTLIKE
- ISPRIME
- ISRANGEOBJECT
- ISREF
- ISREGEXP
- ISSAME
- ISSTRING
- ISSUBSET
- ISSUPERSET
- ISTEXT
- ISVECTOR
- ISVECTORSIZE
- ITALIC
- JIS
- KEYINARRAY
- KEYS
- KEYTAGS
- KNOW
- LAZYOBJECT
- LAZYRANGE
- LAZYSERIES
- LIKE
- LOAD
- LOADSEMANTICINFO
- LOL
- MAP
- MAPLISP
- MAPTABLE
- MATCH
- MILLION
- MROWAGGREGATE
- MROWDUPLICATE
- MROWOP
- NA
- NE
- NES
- NEST
- NIL
- NINTHOF
- NO
- NODE
- NODES
- NODESX
- NODET
- NODEX
- NONAME
- NONE
- NUMERICARRAY
- OBJ
- OBJECT
- OFF
- OFFSET
- OK
- OLDX
- ON
- OPF
- OPFSTR
- PFX
- PIGEN
- PIVOT
- RADIALTREE
- SQL
- SYMBOLFILTER
- SYMBOLIC
- SYMBOLNUMBER
- TABLE
- TABLEADDROW
- TABLEARRAY
- TABLES
- TABULATE
- TABULATEFORPIVOT
- TAGS
- THING
- THINK
- TRUTHY
- UNDERSTAND
- UNDERSTANDSTRING
- UNESCAPE
- UNICODESYMBOL
- UNK
- UNKNOWN
- UNQUOTE
- XDY
- XML
- XMLCALL
- YES
- YUP
INFORMATION2
- ACRONYM
- APOLOGIZE
- BAHTTEXT
- BYID
- CALLLISP
- CALLOPTION
- CALLSQL
- CANVASIMAGE
- COALESCE
- CONTAINS
- CONTAINVISUALLY
- EXPORTTO
- EXPRESSMYOPINION
- EXPRESSUSERSOPINION
- MODEL
- OCCURANCES
- PARTITIONP
- PARTITIONTREE
- PARTP
- PFX
- READFROMLZWIMAGE
- SDIM
- SOSZ
- SOT
- SOV
- SOW
- SOWH
- SOZ
- TOSIMPLEARRAY
- TRIGGEREVENT
- TSV
- TTYL
- URLEXPAND
- URLFRAMEEXPAND
- URLLIST
- URLOBJECT
- URLS
- WHOISUSER
- XFUNCTIONAT
- XMLDEPTH
- XMLSET
- XMLTOTABLE
- XMLVALUES
- XMY
LOGICAL1
- BITAND
- BITLSHIFT
- BITNOT
- BITOR
- BITRSHIFT
- BITRSHIFTZ
- BITXOR
- FALSE
- FALSEVALUE
- FALSEY
- IF
- IFNULL
- NOT
- NOTOK
- OR
- TRUE
- TRUEVALUE
DATABASE AND LIST MANAGEMENT1
DATABASE AND LIST MANAGEMENT2
LOOKUP AND REFERENCE1
- ADDRESS
- AGE
- AREAS
- BEEP
- CHOOSE
- COLORS
- COLUMN
- COLUMNS
- COLUMNWITH
- COLWITH
- DONOTHING
- DOSQL
- DROP
- DUPLICATE
- FIELDINDEX
- FILTER
- FORMULA
- FORRESULTSONLY
- FUCTIONTOIMPLEMENT
- FUNC
- FUNCT
- FUNCTIONFROMTEMPLATE
- FUNCTIONOF
- FUZZY
- GETCOLUMN
- GETCONVERSION
- GETFUNCTION
- GETFUNCTIONSET
- GETGPS
- GETJSON
- GETLINE
- GETNUMBERTAIL
- GETREALORCOMPLEX
- GETROW
- GETSERIES
- GMAP
- GOALSEEK
- GROUP
- HLOOKUP
- HVLOOKUP
- INDEX
- INDIRECT
- INFO
- INTEG
- LISTCOLUMNLABELS
- LISTCOLUMNS
- LISTROWS
- LISTUNIQUE
- LISTV
- LOOKUP
- LOOPMEDIA
- MLANGUAGELOOKUP
- NUMBEREIGHT
- NUMBERFIVE
- NUMBERFOUR
- NUMBERNINE
- NUMBERONE
- NUMBERSEVEN
- NUMBERSIX
- NUMBERTEN
- NUMBERTHREE
- NUMBERTWO
- NUMBERZERO
- ONE
- ONEBY
- PARSE
- PARSELISP
- PARSENUMBER
- PARSESQL
- PARSESTRINGWITHOUTPARANTHESIS
- PASTECOLUMNS
- PASTEROWS
- PAUSE
- QUOTE
- ROW
- ROWS
- ROWWITH
- SMILE
- UNDEFINED
- UPTO
- VLOOKUP
Lookup and Reference2
- ANALYZE
- ASSIGN
- ASYNCITERATE
- ATTRTOPROP
- CASE
- CASEIF
- CDR
- EFFECTCOLORBOOK
- EFFECTEDGEDETECTION
- EFFECTEDGEDETECTIONALGORITHM
- EFFECTGLASS
- EFFECTGLASSBOX
- EFFECTGLASSPATTERN
- EFFECTNEONLINES
- EFFECTPATTERN
- EFFECTRIPPLES
- GETCELLTD
- GETLATLONG
- GKMAPPING
- PENTATE
- QPIVOT
- QPIVOTINCUBE
- SAFEEVAL
- STEPLOOP
- TIMER
- TIMES
- TIMESTRING
- TYPE
- TZ
- XLBETWEEN
- XLRBETWEEN
- XPY
- XRBETWEEN
- XSY
Text and Data1
- BADWORDS
- CHAR
- CHR
- CLAUSES
- CLEAN
- CLEAR
- CLS
- CODE
- DEFAULT
- DEFAULTNUMBER
- DEFAULTPROPER
- DEFUN
- DES
- DESCRIBEFUNCTIONCALLMISSING
- DEVARRAY
- DIM
- DIMENSIONS
- DIS
- EIGHTHOF
- ESCAPE
- EXTRACTNUMBERS
- EXTRACTTEXT
- FAIL
- FIND
- FINDB
- FINDUNIT
- FIXCHARS
- FIXED
- FIXEDBAD
- FOR
- FORALL
- FOREACH
- FORLOOP
- LEFTB
- LEN
- LENB
- LETTERS
- LOWER
- LOWERCASE
- LZ
- LZWCOMPRESS
- LZWDECOMPRESS
- MID
- MIDB
- MIDDLE
- MIDN
- MIXEDCASE
- NOK
- NONFALSEVALUE
- NONNEGATIVE
- NONPOSITIVE
NON ZERO - * NONZERO NON ZERO VALUE - * NONZEROVALUE NOPE - * NOPE NOW - * NOW NULL - * NULL NULL IF - * NULLIF NUM - * NUM NUMBER - * NUMBER NVL - * NVL OSTYLE - * OSTYLE OUTPUT - * OUTPUT PACK - * PACK PADZEROES - * PADZEROES PHONETIC - * PHONETIC PHONETIC CODES - * PHONETICCODES PRINT - * PRINT PRINT CONVERSION - * PRINTCONVERSION PRINTTAGS - * PRINTTAGS PRINT UNIT TAGS - * PRINTUNITTAGS PRINT WITH UNITS - * PRINTWITHUNITS PROPER - * PROPER PUSH - * PUSH REMOVE TEXT - * REMOVETEXT REPEAT CHAR - * REPEATCHAR REPLACE - * REPLACE REPLACE ARRAY - * REPLACEARRAY REPLACEB - * REPLACEB REPLACE BAD - * REPLACEBAD REPT - * REPT REVERSE - * REVERSE RIGHTB - * RIGHTB RTD - * RTD SEARCH - * SEARCH SEARCHB - * SEARCHB SEARCH BOX SPACE - * SearchBoxSpace SEQ - * SEQ SET VALUE STRING - * SETVALUESTRING SET WHOISUSER - * SETWHOISUSER SLIDER CONTROL - * SLIDERCONTROL SO - * SO SOB - * SOB SOC - * SOC SOH - * SOH SOI - * SOI SOL - * SOL SOLT - * SOLT SOLTWH - * SOLTWH