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:

## 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.)