• Learn
  • Blog
  • Pricing
  • About
  • Sign in

Functions

For a complete reference of all 279 functions supported by Calcapp, refer to the reference sidebar. These are the supported functions (those specific to Calcapp are in italics):

Color

ALPHA, BLUE, BRIGHTEN, BRIGHTNESS, COLOR, COLORSPIN, DARKEN, DEFAULTCOLOR, DESATURATE, DIM, GREEN, HSB, HSBA, HSBSATURATION, HSL, HSLA, HSLSATURATION, HUE, LIGHTEN, LIGHTNESS, RED, RGB, RGBA, SATURATE

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

ERROR.TYPE, BLANK, ISBLANK, ISDEFINED, ISERR, ISERROR, ISEVEN, ISNA, ISODD, N

Logical

TOLOGICAL, IF, CHOOSE, IFERROR, IFNA, TRUE, FALSE, AND, OR, XOR, NOT

Mathematical

TONUMBER, 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

TOTEXT, CHAR, CLEAN, CODE, CONCATENATE, EXACT, FIND, FIXED, FORMATFRACTION, FORMATNUMBER, FORMATPERCENTAGE, FORMATSCIENTIFIC, LEFT, LEN, LOWER, MID, PARSEFRACTION, PARSENUMBER, PARSEPERCENTAGE, PARSESCIENTIFIC, PROPER, REGEXEXTRACT, REGEXMATCH, REGEXREPLACE, 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