• Learn
  • Blog
  • Pricing
  • About
  • Sign in

Feature: 244 formula functions

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

« A major update is coming! Feature: The function browser »