Zapof Functions Listed by Category

Math operation.

Binary operators

• + : plus
• - : minus
• / : divide
• * : multiply
• & : bitwise AND
• ^ : exponentiation

Comparison operators

• =  : equal
• <  : less than
• >  : greater than
• >= : greater than equal
• <> : not equal

Unary operators

• + : plus
• - : negation
• % : percent

Logical functions

The Logical functions allow boolean logic decisions.

AND, FALSE, IF, IFERROR, IFNA, NOT, OR, SWITCH, TRUE, XOR

Date & Time functions

The Date & Time functions are used to manipulate dates and times.

TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE, SECOND, DATE, DATETIME, DATEVALUE, TIME, TIMEVALUE, EOMONTH, EDATE, INTERVAL, WORKDAY, WORKDAY.INTL, NETWORKDAYS, NETWORKDAYS.INTL, DAYS, DAYS360, DAYSINMONTH, DAYSINYEAR, WEEKS, WEEKSINYEAR, WEEKNUM, ISOWEEKNUM, MONTHS, YEARS, ISLEAPYEAR, YEARFRAC

Text functions

The Text functions manipulate or return text.

• BASE, CHAR, CHARAT, CLEAN, CODE, CONCATENATE, DBCS, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, NUMBERVALUE, PROPER, REGEXEXTRACT, REGEXMATCH, REGEXREPLACE, REPLACE, REPT, RIGHT, SEARCH, SPLIT, SUBSTITUTE, T, TEXT, TRIM, UNICHAR, UNICODE, UPPER, VALUE, TEXTJOIN, TOEXPONENTIAL, ERROR.TEXT
• STARTSWITH, ENDSWITH, INDEXOF, LASTINDEXOF, PADSTART, PADEND, REPEAT, TRIMSTART, TRIMEND

Mathematical functions

The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.

• COS, SIN, TAN, COT, ACOS, ACOT, ASIN, ATAN, ATAN2, DEGREES, RADIANS, PI
• E.CONST, LN2.CONST, LN10.CONST, LOG2E.CONST, LOG10E.CONST, SQRT1_2.CONST
• COSH, SINH, TANH, COTH, ACOSH, ACOTH, ASINH, ATANH, CSC, CSCH, SEC, SECH
• TRUNC, ROUND, ROUNDDOWN, ROUNDUP, FROUND, CEILING, CEILING.MATH, CEILING.PRECISE, FLOOR, FLOOR.MATH, FLOOR.PRECISE, EVEN, ODD, MROUND, INT, QUOTIENT, MOD
• EXP, POWER, POW, LOG, LN, LOG10, LOG1P, LOG2, CBRT, CLZ32, EXPM1
• ABS, COMBIN, COMBINA, CONVERT, COUNTBLANK, COUNTIF, COUNTIFS, DELTA, ERF, ERFC, FACT, FACTDOUBLE, GCD,  GESTEP, ISEVEN, ISODD, LCM, MULTINOMIAL, PRODUCT, RAND, RANDBETWEEN, SERIESSUM, SIGN, SQRT, SQRTPI, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2
• BESSELI, BESSELJ, BESSELK, BESSELY,
• ADD, MINUS, DIVIDE, MULTIPLY, GT, GTE, LT, LTE, EQ, NE

Complex Number functions

The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.

COMPLEX, IMABS, IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN

Number Conversion functions

The Number Conversion functions convert numbers between forms.

• BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
• ARABIC, DECIMAL, ROMAN

Information functions

The Information functions return information about cells, such as whether they contain text or a formula, etc.

ERROR.TYPE, ISBLANK, ISBINARY, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, N, NA, TYPE

Lookup-reference functions

The Lookup-reference functions find values in tables, or cell references.

ARRAYLENGTH, CHOOSE, GETARRAYELEMENT, INDEX, INDIRECT, ISINARRAY, MATCH, OFFSET

Financial functions

The Financial functions provide common business calculations.

• DB, DDB, SLN, SYD
• CUMIPMT, CUMPRINC, FV, FVSCHEDULE, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, PV, RATE, RRI, XIRR, XNPV
• ACCRINT, EFFECT, NOMINAL, PDURATION, TBILLEQ, TBILLPRICE, TBILLYIELD
• DOLLARDE, DOLLARFR

Statistical functions

The Statistical functions provide statistical and probability calculations.

• AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, COLUMN.AT, COLUMNS, ROW.AT, ROWS, COUNTIN, COUNTIFS, COUNTUNIQUE, GEOMEAN, HARMEAN, MEDIAN, MODE, MODE.MULT, MODE.SNGL, TRIMMEAN
• DEVSQ, KURT, SKEW, SKEW.P, STDEV, STDEV.P, STDEV.S, STDEVA, STDEVPA, VAR, VAR.P, VAR.S, VARA, VARPA
• BETADIST, BETA.DIST, BETAINV, BETA.INV, BINOMDIST, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, CHISQDIST, CHISQ.DIST, CHISQ.DIST.RT, CHISQINV, CHISQ.INV, CHISQ.INV.RT, CHISQTEST, CHISQ.TEST, CONFIDENCE, CONFIDENCE.NORM, CONFIDENCE.T, EXPONDIST, EXPON.DIST, FDIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, FTEST, F.TEST, FISHER, FISHERINV, GAMMA, GAMMADIST, GAMMA.DIST, GAMMAINV, GAMMA.INV, GAMMALN, GAMMALN.PRECISE, GAUSS, HYPGEOMDIST, HYPGEOM.DIST, LOGINV, LOGNORMDIST, LOGNORM.DIST, LOGNORM.INV, NEGBINOMDIST, NEGBINOM.DIST, NORMDIST, NORM.DIST, NORMINV, NORM.INV, NORMSDIST, NORM.S.DIST, NORMSINV, NORM.S.INV, PERMUT, PERMUTATIONA, PHI, POISSON, POISSON.DIST, PROB, STANDARDIZE, TDIST, T.DIST, T.DIST.2T, T.DIST.RT, TINV, T.INV, T.INV.2T, TTEST, T.TEST, WEIBULL, WEIBULL.DIST, ZTEST, Z.TEST
• CORREL, COVAR, COVARIANCE, COVARIANCE.P, COVARIANCE.S, FORECAST, INTERCEPT, PEARSON, RSQ, SLOPE, STEYX
• LARGE, MAX, MAXA, MIN, MINA, PERCENTILE, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK, PERCENTRANK.EXC, PERCENTRANK.INC, QUARTILE, QUARTILE.EXC, QUARTILE.INC, RANK, RANK.AVG, RANK.EQ, SMALL
• AGGREGATE

Array functions

The Array functions operate on and return entire tables of data.

FREQUENCY, GROWTH, LINEST, LOGEST, MDETERM, MINVERSE, MMULT, MUNIT, TRANSPOSE, TREND

Engineering functions

The Engineering functions provide common engineering calculations.

BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR

Miscellaneous functions

UNIQUE, ARGS2ARRAY, JOIN, NUMBERS, EVAL, JSON.QUERY, JSON.TEXT, JSON.PARSE, JSON.GET, JSON.SET