Zapof Functions Listed by Category

Math operation

Binary operators

Comparison operators

Unary operators

The Logical functions allow boolean logic decisions.

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

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

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
STARTSWITH, ENDSWITH, INDEXOF, LASTINDEXOF, PADSTART, PADEND, REPEAT, TRIMSTART, TRIMEND

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

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

The Number Conversion functions convert numbers between forms.

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

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

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

The Financial functions provide common business calculations.

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