Difference between revisions of "Z API Functions"
Jump to navigation
Jump to search
| Line 1,150: | Line 1,150: | ||
*[[Manuals/calci/NONNEGATIVE | NONNEGATIVE]] | *[[Manuals/calci/NONNEGATIVE | NONNEGATIVE]] | ||
*[[Manuals/calci/NONPOSITIVE | NONPOSITIVE]] | *[[Manuals/calci/NONPOSITIVE | NONPOSITIVE]] | ||
| − | + | *[[Manuals/calci/NONZERO | NONZERO]] | |
| − | + | *[[Manuals/calci/NONZEROVALUE | NONZEROVALUE]] | |
| − | + | *[[Manuals/calci/NOPE | NOPE]] | |
| − | + | *[[Manuals/calci/NOW | NOW]] | |
| − | + | *[[Manuals/calci/NULL | NULL]] | |
| − | + | *[[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/SETVALUESTRING | SETVALUESTRING]] | |
| − | + | *[[Manuals/calci/SETWHOISUSER | SETWHOISUSER]] | |
| − | + | *[[Manuals/calci/SLIDERCONTROL | SLIDERCONTROL]] | |
| − | + | *[[Manuals/calci/SO | SO]] | |
| − | + | *[[Manuals/calci/SOB | SOB]] | |
| − | + | *[[Manuals/calci/SOC | SOC]] | |
| − | + | *[[Manuals/calci/SOH | SOH]] | |
| − | + | *[[Manuals/calci/SOI | SOI]] | |
| − | + | *[[Manuals/calci/SOL | SOL]] | |
| − | + | *[[Manuals/calci/SOLT | SOLT]] | |
| − | + | *[[Manuals/calci/SOLTWH | SOLTWH]] | |
*[[Manuals/calci/SOME | SOME]] | *[[Manuals/calci/SOME | SOME]] | ||
*[[Manuals/calci/SPELLDIGIT | SPELLDIGIT]] | *[[Manuals/calci/SPELLDIGIT | SPELLDIGIT]] | ||
Revision as of 15:00, 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
- NONZERO
- NONZEROVALUE
- NOPE
- NOW
- NULL
- NULLIF
- NUM
- NUMBER
- NVL
- OSTYLE
- OUTPUT
- PACK
- PADZEROES
- PHONETIC
- PHONETICCODES
- PRINTCONVERSION
- PRINTTAGS
- PRINTUNITTAGS
- PRINTWITHUNITS
- PROPER
- PUSH
- REMOVETEXT
- REPEATCHAR
- REPLACE
- REPLACEARRAY
- REPLACEB
- REPLACEBAD
- REPT
- REVERSE
- RIGHTB
- RTD
- SEARCH
- SEARCHB
- SearchBoxSpace
- SEQ
- SETVALUESTRING
- SETWHOISUSER
- SLIDERCONTROL
- SO
- SOB
- SOC
- SOH
- SOI
- SOL
- SOLT
- SOLTWH
- SOME
- SPELLDIGIT
- SPELLINTEGER
- SPELLNUMBER
- SPELLTEENS
- SPELLTENS
- STANDARDPHONETICCODES
- STRIKETHROUGH
- STRINGTOARRAY
- SUBSCRIPT
- SUBSTITUTE
- SUBSTRINGCOUNT
- SUPERSCRIPT
- TEXT
- UNDERLINE
- UPPER
- UPPERCASE
- VALUE
- VALUEITSELF
- VOID
- WRITE
- WRITELN
- WS