Our upcoming release will feature significantly expanded support for formula functions. All in all, we will support 244 functions, ranging from text- and date-manipulation functions to functions in statistics, finance, engineering and trigonometry. If you’re used to a spreadsheet like Microsoft Excel, the new functions should be familiar. Here’s the complete list:
August 11, 2023 update: Calcapp now supports over 400 functions.
Original text:
Date and time
DATE, DAY, DAYS, DAYS360, EDATE, EOMONTH, HOUR, MINUTE, MONTH, NETWORKDAYS, NOW, SECOND, TIME, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR, YEARFRAC
Engineering
BESSELI, BESSELJ, BESSELK, BESSELY, BIN2DEC, BIN2HEX, BIN2OCT, BITAND, BINLSHIFT, BITOR, BINRSHIFT, BITXOR, COMPLEX, CONVERT, DEC2BIN, DEC2HEX, DEC2OCT, DELTA, ERF, ERFC, GESTEP, HEX2BIN, HEX2DEC, HEX2OCT, IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMCOSH, IMCOT, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN, OCT2BIN, OCT2DEC, OCT2HEX
Financial
CUMIPMT, CUMPRINC, DB, DDB, DOLLARDE, DOLLARFR, EFFECT, FV, IPMT, ISPMT, NOMINAL, NPER, NPV, PDURATION, PMT, PPMT, PV, RATE, RRI, SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD
Information
BLANK, ERROR.TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISODD, N
Logical
IF, IFERROR, IFNA, TRUE, FALSE, AND, OR, XOR, NOT
Mathematical
ABS, ARABIC, BASE, CEILING, CEILING.MATH, COMBIN, COMBINA, DECIMAL, DEGREES, EVEN, EXP, FACT, FACTDOUBLE, FLOOR, FLOOR.MATH, GCD, INT, LCM, LN, LOG, LOG10, MOD, MROUND, MULTINOMIAL, ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SQRT, SQRTPI, SUM, SUMSQ, TRUNC
Statistical
AVEDEV, AVERAGE, BETA.DIST, BETA.INV, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, CHISQ.DIST, CHISQ.INV, CONFIDENCE.NORM, CONFIDENCE.T, DEVSQ, EXPON.DIST, FISHER, FISHERINV, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMALN, GAMMALN.PRECISE, GAUSS, GEOMEAN, HARMEAN, HYPGEOM.DIST, KURT, LOGNORM.DIST, LOGNORM.INV, MAX, MEDIAN, MIN, NEGBINOM.DIST, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, PERMUT, PERMUTATIONA, PHI, POISSON.DIST, SKEW, SKEW.P, STANDARDIZE, STDEV.P, STDEV.S, T.DIST, T.INV, VAR.P, VAR.S, WEIBULL.DIST
Text
CHAR, CLEAN, CODE, CONCATENATE, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SUBSTITUTE, TRIM, UNICHAR, UNICODE, UPPER
Trigonometry
SIN, COS, TAN, COT, SEC, CSC, ASIN, ACOS, ATAN, ATAN2, ACOT, SINH, COSH, TANH, COTH, SECH, CSCH, ASINH, ACOSH, ATANH, ACOTH
All functions, along with documentation, will be available in the new function browser.
While the list above is quite comprehensive, there are a few popular functions that are missing. In particular, the VLOOKUP, HLOOKUP, MATCH and INDEX functions are not supported, nor are any other functions dealing with tabular data. Calcapp does not yet support tabular data. (You can approximate small tables today with nested IF functions, though such constructs quickly become unreadable.)