Difference between revisions of "Z API Functions"
Jump to navigation
Jump to search
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==LIST OF ALL FUNCTIONS== | ==LIST OF ALL FUNCTIONS== | ||
===Statistical Functions1=== | ===Statistical Functions1=== | ||
| + | *[[Manuals/calci/Average, AverageA, AverageX Example| Example]] | ||
*[[Manuals/calci/z3console| z3console]] | *[[Manuals/calci/z3console| z3console]] | ||
*[[Manuals/calci/Examples | Examples of Java and z3 programs]] | *[[Manuals/calci/Examples | Examples of Java and z3 programs]] | ||
| Line 22: | Line 23: | ||
*[[Manuals/calci/COUNT | COUNT]] | *[[Manuals/calci/COUNT | COUNT]] | ||
*[[Manuals/calci/COUNTA | COUNTA]] | *[[Manuals/calci/COUNTA | COUNTA]] | ||
| + | *[[Manuals/calci/COUNTBLANK | COUNTBLANK]] | ||
| + | *[[Manuals/calci/COUNTIF | COUNTIF]] | ||
| + | *[[Manuals/calci/COVAR | COVAR]] | ||
| + | *[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]] | ||
*[[Manuals/calci/DECREASING | DECREASING]] | *[[Manuals/calci/DECREASING | DECREASING]] | ||
*[[Manuals/calci/DECREMENT | DECREMENT]] | *[[Manuals/calci/DECREMENT | DECREMENT]] | ||
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]] | *[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]] | ||
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]] | *[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]] | ||
| − | *[[ | + | *[[Manuals/calci/DET | DET]] |
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/DEVSQ | DEVSQ]] | *[[Manuals/calci/DEVSQ | DEVSQ]] | ||
*[[Manuals/calci/FEQ | FEQ]] | *[[Manuals/calci/FEQ | FEQ]] | ||
| Line 213: | Line 214: | ||
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]] | *[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]] | ||
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]] | *[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]] | ||
| + | *[[Manuals/calci/CAR | CDR]] | ||
*[[Manuals/calci/CEILING | CEILING]] | *[[Manuals/calci/CEILING | CEILING]] | ||
*[[Manuals/calci/CEILINGAT | CEILINGAT]] | *[[Manuals/calci/CEILINGAT | CEILINGAT]] | ||
| Line 806: | Line 808: | ||
*[[Manuals/calci/ISERROR | ISERROR]] | *[[Manuals/calci/ISERROR | ISERROR]] | ||
*[[Manuals/calci/ISEVEN | ISEVEN]] | *[[Manuals/calci/ISEVEN | ISEVEN]] | ||
| + | *[[Manuals/calci/ISFALSE | ISFALSE]] | ||
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]] | *[[Manuals/calci/ISFUNCTION | ISFUNCTION]] | ||
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]] | *[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]] | ||
| Line 839: | Line 842: | ||
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]] | *[[Manuals/calci/ISSUPERSET | ISSUPERSET]] | ||
*[[Manuals/calci/ISTEXT | ISTEXT]] | *[[Manuals/calci/ISTEXT | ISTEXT]] | ||
| + | *[[Manuals/calci/ISTRUE | ISTRUE]] | ||
*[[Manuals/calci/ISVECTOR | ISVECTOR]] | *[[Manuals/calci/ISVECTOR | ISVECTOR]] | ||
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]] | *[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]] | ||
Latest revision as of 19:32, 19 September 2021
LIST OF ALL FUNCTIONS
Statistical Functions1
- Example
- z3console
- Examples of Java and z3 programs
- Engineering Examples in z3
- Linear Programming in z3
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEBOTTOM
- AVERAGEIF
- AVERAGEMIDDLE
- AVERAGETOP
- AVG
- BETA
- BETWEEN
- BETWEENCORE
- BINOM
- BINOMIAL
- BINOMIALCOEFFICIENT
- CONFIDENCE
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COVAR
- COVARIANCEDATAANALYSIS
- DECREASING
- DECREMENT
- DESCRIBENUMBER
- DESCRIPTIVESTATISTICS
- 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
- 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
- CDR
- CEILING
- CEILINGAT
- CIS
- COMBIN
- COMBINATIONS
- COMPLEMENT
- COS
- COSExamples
- 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
- SINExamples
- 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
- AGINGINDAYS
- 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
- MOMENT
- 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
- ISCOMPOSITE
- ISELEMENTLIKECOMPLEX
- ISEMPTY
- ISEQUATION
- ISERR
- ISERROR
- ISEVEN
- ISFALSE
- ISFUNCTION
- ISFUNCTIONSYMBOL
- ISIGNOREINDEX
- ISINARRAY
- ISINTEGER
- Safe Integer
- 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
- ISTRUE
- 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
Logical
- 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
- VLOOKUPExamples
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
Text and Data2
- CHECKFACT
- COLLECTION
- CONCAT
- CONCATENATE
- CONCATSTRINGTOARRAY
- EXACT
- FORX
- FORXX
- FORXXCOMBINATORIAL
- FORY
- LFN
- MARKUNITNATURE
- MARQUEE
- NOTHING
- NUB
- PRETTYPRINT
- PROPTOATTR
- RESETSEQ
- RETVALUE
- SPLIT
- SPLITTEXT
- SS
- SSTR
- STYLECELL
Matrix Functions1
- ADJ
- ANTIDIAGONAL
- ANTIDIAGONALWITH
- BLOCKDIAGONAL
- CONTOURS
- DIAGONALFILL
- DIAGONALMATRIX
- DIAGONALWITH
- EYE
- HADAMARD
- hadamard
- HADAMARDPRODUCT
- HANKEL
- hankel
- IM
- INVERSE
- KEEPCOLUMNS
- MATRIX
- MATRIXADD
- MATRIXADJOINT
- MATRIXAPPENDCOLUMNS
- MATRIXAPPENDROWS
- MATRIXASSIGN
- MATRIXASSIGNOBJECT
- MATRIXASSIGNTORIGHT
- MATRIXCLONE
- MATRIXCOLUMN
- MATRIXCOPY
- MATRIXDECOMPOSE
- MATRIXDETERMINANT
- MATRIXDIAGONAL
- MATRIXDIAGONALPRODUCT
- MATRIXDIVIDE
- MATRIXDIVPARTS
- MATRIXEQUAL
- MATRIXFLIP
- MATRIXIDENTITY
- MATRIXINTDIV
- MATRIXINVERSE
- MATRIXJOIN
- MATRIXLATTICEMERGE
- MATRIXMINUS
- MATRIXMOD
- MATRIXMULTIPLY
- MATRIXNEGATE
- MATRIXNOTEQUAL
- MATRIXPACK
- MATRIXPLUS
- MATRIXPOWER
- MATRIXPRODUCT
- MATRIXRANK
- MATRIXREPLACECOLUMN
- MATRIXREVERSE
- MATRIXROTATE
- MATRIXROW
- MATRIXSCALARADD
- MATRIXSCALARDIVIDE
- MATRIXSCALAREXP
- MATRIXSCALARLN
- MATRIXSCALARLOG
- MATRIXSCALARMULTIPLY
- MATRIXSCALAROPERATION
- MATRIXSCALARPOWER
- MATRIXSCALARSQRT
- MATRIXSCALARSUBTRACT
- MATRIXSTRING
- MATRIXSUBTRACT
- MATRIXSYMMETRIC
- MATRIXTRACE
- MATRIXTRANSPOSE
- MATRIXTYPE
- MATRIXWITH
- MATRIXZERO
- MCORREL
- MDETERM
- MINVERSE
- MMULT
- SIZE
- SKEWSYMMETRIC
- SPREAD
- SPREADSHEETS
- SVF
- TESTARRAY
- TESTDIV
- TESTMAX
- TESTMAXWORKS
- TRACE
- TRANSPOSE
Matrix Functions2
- CHOLESKY
- CHOLESKYFACTORIZATION
- EIGENVALUES
- EXTENT
- LUDECOMPOSITION
- LUDEV
- MATRIXTENSORPRODUCT
- MCOLAGGREGATE
- MCOLDUPLICATE
- MCOLOP
- QRDECOMPOSITION
- QRDEV
- REDUCEDROWECHELONFORM
- SVD
- TENSORPRODUCT
Other Functions1
- ARRAY
- ARRAYFY
- ARRAYIFY
- ARRAYMAKE
- ARRAYPRINT
- ARRAYSIZE
- ARRAYTOCALCI
- ARRAYTOSTRING
- ASARRAY
- ASC
- CSV
- DEAL
- DECK
- GENERATEBOOLEAN
- GENERATEGRAPH
- GENERATEINTEGER
- GENERATENATURAL
- GENERATENEGATIVE
- GENERATENEGATIVEINTEGER
- GENERATENEGATIVENONZEROINTEGER
- GENERATENEGZEROPOS
- GENERATENUMBER
- GENERATEPOSITIVE
- GENERATEPOSITIVEINTEGER
- GENERATEPOSITIVENONZEROINTEGER
- GENERATESERIESSTRING
- GENERATESUDOKU
- GENERATEZERO
- globalz3unitsymbols
- globalz3unitsymbolsstring
- IMAGE
- IMAGEURL
- IMG
- ITERATE
- ITERATENR
- MAGICSQUARE
- MAKECANVAS
- MAKEFUNCTIONARRAY
- MAKEFUNCTIONSIGNATURECALL
- MAKELISTS
- MAKEMAP
- MAKERSS
- MAKETOLZWIMAGE
- MERGEIMAGES
- POP
- PROJECT
- RANDOM
- RANDOMARRAY
- RANDOMAT
- RANDOMNUMBERGENERATION
- RANDOMNUMBERSCORE
- RANDOMPHRASE
- RANDOMSELECT
- RANDOMSELECTWITHMATCH
- RANDOMSET
- RANDOMWITHIGNORE
- RANDOMWITHIN
- RANGE
- RANGELOCATION
- RGB
- RNG
- SAYFOCUS
- SAYNUMBER
- SCRAMBLE
- SHOW
- SHOWARRAY
- SOLUTIONS
- SUPPORTEDUNITS
- TERMSOFENDEARMENT
- THEREDOESNOTEXIST
- THEREEXISTS
- THEREEXISTSONE
- THROTTLE
- TOWERSOFHANOI
- WH
- WHATCASE
- WHILE
- WITHIN
- WORDPROBLEM
Other Functions2
- ANOVASINGLEFACTOR
- ANOVATWOFACTORWITHOUTREPLICATION
- ANOVATWOFACTORWITHREPLICATION
- ARBIT
- BIRTHDAYPROBABILITY
- COLLAPSIBLEINDENTEDTREE
- COLLAPSIBLETREE
- CSSA
- FORDOFUNCTIONS
- NQUEENS
- RECURSIVEARRAY
- REDIRECT
- REDIRECTFROM
- REDIRECTTO
- SELECT
- SELECTONE
- SELF
- SEMANTICSEARCH
- TEVALX
- TREELIST
- TREEMAPBYCOUNT
- TREEMAPBYSIZE
- ACCELERATIONDUETOGRAVITY
- DISTANCE
- EARTH
- EB
- EFFECTDISPLACEMENT
- ELBOWEDENDOGRAM
- JUPITER
- LATITUDE
- LONGITUDE
- MARS
- MASS
- MERCURY
- MOON
- NEPTUNE
- PLUTO
- RDF
- SATURN
- SOUNDEX
- SOUNDSLIKE
- SPEEDOFLIGHT
- SUN
- SUNBURST
- URANUS
- VENUS
Special Z3 Functions
- Z3
- Z3A
- Z3AB
- Z3AM
- Z3D
- Z3Hint
- Z3K
- Z3KM
- Z3P
- Z3PM
- Z3R
- Z3RM
- Z3S
- Z3SM
- Z3StoreResidualAnimationParameters
- Z3T
- Z3TM
- ZAddBanner
- ZAddBlock
- ZAddCaption
- ZAddColumns
- ZAddToPath
- ZAlertBox
- ZANGLE
- ZAnyObject
- ZAnyObjectx
- ZAppear
- ZAppend
- ZAppendx
- ZAPPLY
- ZApplyScript
- ZApplyStyles
- ZApplyToGroup
- ZArray
- ZAttachBGToTransform
- ZAttributesToSelection
- ZAutoBackgroundResize
- ZAutoRecover
- ZAutoRecoverLink
- ZAutoRecoverList
- ZAutoSave
- ZBNU
- ZBNUS
- ZBorderChange
- ZBorderHide
- ZBorderSet
- ZBorderShow
- ZBoxEdit
- ZBrowserFrame
- ZBTo
- ZBU
- ZBUTTON
- ZC
- ZCallModule
- ZChangeAttribute
- ZChangeStyleEnd
- ZChangeStyleStart
- ZChangeToLayer
- ZChangeValue
- ZCheckAndApplyToGroup
- ZCHECKBOX
- ZClear
- ZClearAllAutoSave
- ZClearAllSavedFiles
- ZClearAutoSave
- ZClearPath
- ZCO
- ZCombine
- ZCommandments
- ZCommentDiv
- ZCommentFrame
- ZCondenseLinks
- ZConfirmBox
- ZConnect
- ZContentObject
- ZContentObjectx
- ZContentSet
- ZContentx
- ZCopy
- ZCopyObject
- ZCount
- ZCoverObject
- ZCoverObjectx
- ZCoverPaddingSet
- ZCoverx
- ZCPOINTER
- ZCrazy
- ZCreateAnimationCube
- ZCreateFullWindow
- ZCS
- ZCubePart
- ZCubesHelpWindow
- ZCubesInLayer
- ZCubesThisBuild
- ZCubesThisVersion
- ZCubeWithHeader
- ZCubeWithHeaderx
- ZCubex
- ZCx
- ZCycle
- ZCycleSelectedBoxes
- ZDeleteObject
- ZDeletePointer
- ZDisappear
- ZDisconnect
- ZDisplayImageListOnBulge
- ZDisplayImageOnObject
- ZDistributeEvents
- ZDoPageTurn
- ZDoPageTurnBack
- ZDoubleQuote
- ZDuplicate
- ZEditBarIcon
- ZEditBarIconImage
- ZEditBarIconText
- ZEditBarStandard
- ZEditorIconPalette
- ZEditorIconPaletteTable
- ZEditPresentation
- ZElastic
- ZEmailZnotes
- ZEnableTab
- ZERO
- ZeroIfTooLow
- ZEROM
- ZeroPad
- ZEROS
- ZEROVALUE
- ZEscape
- ZEvaluateFormulae
- ZEvaluateVariable
- ZEventPseudoObject
- ZEventPseudoObjectToSend
- ZEventRegistrations
- ZExist
- ZExtract
- ZFigureCaption
- ZFileListingFrame
- ZFind
- ZFindLeftTop
- ZFindSimilarImages
- ZFit
- ZFLAT
- ZFooterHeight
- ZFooterObject
- ZGet
- ZGetAdjacentRegion
- ZGetAllChildren
- ZGetAllChildrenx
- ZGetAllIFramesInObjectx
- ZGetAnimationTag
- ZGetBookCurrentPage
- ZGetBoxType
- ZGetChildren
- ZGetChildrenx
- ZGetEvent
- ZGetEventx
- ZGetFooter
- ZGetIFrame
- ZGetIFrameInID
- ZGetIFrameInIDx
- ZGetIFrameInObject
- ZGetIFramex
- ZGetImages
- ZGetIsBook
- ZGetKeys
- ZGetLink
- ZGetLoneImage
- ZGetNoMove
- ZGetObject
- ZGetObjectFromID
- ZGetPaging
- ZGetParent
- ZGetParentx
- ZGetProperty
- ZGetSelection
- ZGetShowDecorations
- ZGetTransparent
- ZGetUserData
- ZGetVariableValue
- ZGetx
- ZGo
- ZGoMove
- ZGraph
- ZGridFrame
- ZGridSwitch
- ZGrow
- ZHasChildren
- ZHeader
- ZHeaderHeight
- ZHeaderObject
- ZHeadParent
- ZHeadParentx
- ZHeight
- ZHiddenList
- ZHiddenListx
- ZHide
- ZHideOverflow
- ZHideStatusMessage
- ZHTMLDecode
- ZHTMLEncode
- ZHYPOTENUSE
- ZId
- ZInfo
- ZInfoCount
- ZInZoom
- ZIsAncestor
- ZIsAnimationCube
- ZIsContainedIn
- ZIsDescendent
- ZIsSharedCube
- ZK
- ZKamiKaziBoxes
- ZKO
- ZKOx
- ZKx
- ZLeft
- ZList
- ZListAsSpaceID
- ZListx
- ZLoadAnimationTable
- ZLoadEventMapTable
- ZLocationRange
- ZLogout
- ZLOWLIGHT
- ZMake3DSceneCube
- ZMakeBook
- ZMakeCanvas
- ZMakeContentMoveable
- ZMakeCropWindow
- ZMakeCubeNormal
- ZMakeCubesInto3DCubes
- ZMakeCubesIntoRing
- ZMakeCubesIntoTabs
- ZMakeDockableWindow
- ZMakeFromTemplate
- ZMakeGhostWindow
- ZMakeHeap
- ZMakeLower
- ZMakeNoPopMenu
- ZMakeOriginalOrElastic
- ZMakeRaised
- ZMakeReadOnly
- ZMakeSpringBox
- ZMakeSystemBox
- ZMakeSystemBoxOnPanel
- ZMakeSystemBoxOnPanelOrReactivate
- ZMakeSystemBoxOnPanelWithObject
- ZMakeTabs
- ZMakeThisImageBackground
- ZMakeThisMiniZ
- ZMakeWindowLike
- ZMakeWindowOfSize
- ZMarquee
- ZMarqueeChange
- ZME
- ZMenuMainRootItem
- ZMenuSectionItem
- ZMenuSubBar
- ZMenuSubItem
- ZMergeSelectedBoxes
- ZNoEdge
- ZNoScroll
- ZO
- ZOB
- ZOBJECT
- ZObject
- ZObjectClass
- ZObjectList
- ZObjectListAllOrSelection
- ZOBJECTS
- ZObjectsClass
- ZObjectSettings
- ZObjectx
- ZOCover
- ZOf
- ZOOMABLECIRCLE
- ZoomableCircle
- ZOOMABLETREEBYCOUNT
- ZoomableTreeByCount
- ZOOMABLETREEBYSIZE
- ZoomableTreeBySize
- ZOOMABLETREECORE
- ZoomableTreeCore
- ZoomAndPanZoomyBy
- ZoomMinus
- ZoomNone
- ZoomPlus
- ZoomVariable
- ZoomyActive
- ZoomyControlWrapper
- ZoomyCurrentStep
- ZoomyDefaults
- ZoomyList
- ZoomyToNextCube
- ZOpacity
- ZOV
- ZPaddingSet
- ZPageGet
- ZPageGetSequence
- ZPageGetx
- ZPageSet
- ZPageSetx
- ZPointer
- ZPointerEvents
- ZPointerRegistrations
- ZPreserve3D
- ZPrint
- ZPrintCount
- ZPrintSelectedOneByOne
- ZPublishFrame
- ZPut
- ZRaiseEvent
- ZRandomTips
- ZRangeArea
- ZRangeArray
- ZRangeArrayForNotSpreadSheet
- ZRangeArrayValuesForNotSpreadSheet
- ZRangeValue
- ZReallySmall
- ZRedo
- ZRedo1
- ZRegisterBackgroundList
- ZRegisterBulgeList
- ZRegisterEventListener
- ZRegisterViewer
- ZRemove3DSceneCube
- ZRemoveColumns
- ZRemoveOuterMarquee
- ZRemovePaging
- ZRemovePreserve3D
- ZResetBackground
- ZResetParent
- ZResetPath
- ZResetReadOnly
- ZResizeElasticBox
- ZResources
- ZRestoreFromZCycleBin
- ZRotate
- ZRotateForImg
- ZSafeShow
- ZSaveLocalMHT
- ZSelectBox
- ZSelectChildren
- ZSelectColor
- ZSelectionCopy
- ZSelectionCut
- ZSelectionDelete
- ZSelectionPaste
- ZSet
- ZSetAnimationTag
- ZSetBackgroundImage
- ZSetBoxType
- ZSetBucket
- ZSetEvent
- ZSetEventx
- ZSetFooter
- ZSetFormatHeader
- ZSetFrameContent
- ZSetGrid
- ZSetHeader
- ZSetIFrame
- ZSetIntoObject
- ZSetNoConfirm
- ZSetNoEditMode
- ZSetNoMove
- ZSetNoMoveToggle
- ZSetObject
- ZSetPaging
- ZSetParent
- ZSetPointer
- ZSetProperty
- ZSetRollup
- ZSetSenderText
- ZSetStatusMessage
- ZSetUserData
- ZSetx
- ZShareStatus
- ZShow
- ZShowFooter
- ZShowHeader
- ZShowInFrame
- ZShowOverflow
- ZShowx
- ZSizeFit
- ZSmallConsoleIcon
- ZSmallHelpIcon
- ZSpaceFrameParent
- ZSpaceObjectParentForPaint
- ZSpaceParentPointer
- ZSpacePrint
- ZSpaceZoomIn
- ZSpaceZoomOut
- ZSRC
- ZStartSpecialEffect
- ZStopCrazyEffects
- ZSVGTemplate
- ZSwap
- ZSwitchTransparent
- ZT
- ZTABLE
- ZTABLEDIDNOTWORK
- ZTABLESIMPLE
- ZTEXT
- ZText
- ZTEXTBOX
- ZThing
- ZTimeDown
- ZTip
- ZToggleAlwaysEdit
- ZToggleAutoPlay
- ZToggleBucket
- ZToggleCalci
- ZToggleFlat
- ZToggleHideBox
- ZToggleKeepSize
- ZToggleReadOnly
- ZToggleRegisterViewer
- ZToggleRelativePositioning
- ZToggleScroll
- ZToggleTransparency
- ZToggleTransparent
- ZTop
- ZTranslation
- ZTranslationFrame
- ZTransparent
- ZType
- ZU
- ZUndo
- ZUndo1
- ZUnescape
- ZUNFLAT
- ZUnmerge
- ZUnselectableBox
- ZUnWrap
- ZURL
- ZURLX
- ZV
- ZVarSet
- ZVideoAutoPlay
- ZVisibleCount
- ZVisibleList
- ZVisibleListx
- ZWidth
- ZWizParentPointer
- ZWO
- ZWrap
- ZWrapCaption
- Zx
- ZxOfArray
- ZZoom