Excel Functions Reference

Formula Pro implements over 400 Excel functions. These work alongside Formula Pro custom functions in your formulas.

Categories

Math and Trigonometry

ABS, ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, CEILING, CEILING.MATH, COMBIN, COMBINA, COS, COSH, COT, COTH, DEGREES, EVEN, EXP, FACT, FLOOR, FLOOR.MATH, GCD, INT, LCM, LN, LOG, LOG10, MOD, ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, TAN, TANH, TRUNC, and more.

Example:

SUM(10, 20, 30)           → 60
ROUND(3.14159, 2)         → 3.14
IF({item's Count} > 5, "High", "Low")

Statistical

AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, MAX, MIN, MEDIAN, MODE.SNGL, STDEV.S, STDEV.P, VAR.S, VAR.P, PERCENTILE.INC, RANK.EQ, LARGE, SMALL, CORREL, LINEST, FORECAST, and more.

Example:

AVERAGE(5, 10, 15)        → 10
COUNTIF(range, "Done")     → count of "Done" values
MAX({item's Q1}, {item's Q2}, {item's Q3})

Date and Time

DATE, DATEVALUE, DAY, DAYS, EDATE, EOMONTH, HOUR, MINUTE, MONTH, NETWORKDAYS, NETWORKDAYS.INTL, NOW, TODAY, WEEKDAY, WEEKNUM, WORKDAY, WORKDAY.INTL, YEAR, YEARFRAC, DATEDIF, and more.

Example:

DATEVALUE("2025-03-09")   → serial date
NETWORKDAYS("2025-03-01", "2025-03-14")  → working days
TEXT(DATEVALUE({item's Date}), "YYYY-MM-DD")

Text

CHAR, CLEAN, CODE, CONCAT, CONCATENATE, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, TRIM, UPPER, VALUE, TEXTJOIN, and more.

Example:

CONCATENATE("Hello", " ", "World")  → "Hello World"
LEFT({item's Name}, 10)             → first 10 characters
TRIM({item's Notes})                → trim whitespace

Logical

AND, OR, NOT, IF, IFERROR, IFNA, IFS, TRUE, FALSE, XOR, SWITCH (Excel + Formula Pro enhanced).

Example:

IF({item's Status} = "Done", 1, 0)
AND({item's A} > 0, {item's B} < 100)

Lookup and Reference

CHOOSE, COLUMN, COLUMNS, INDEX, LOOKUP, MATCH, ROW, ROWS, TRANSPOSE, UNIQUE, SORT, and more.

Example:

INDEX(array, row, column)

Financial

PMT, PV, FV, NPV, IRR, RATE, NPER, IPMT, PPMT, SLN, SYD, DB, DDB, ACCRINT, DISC, PRICEDISC, YIELDDISC, and more.

Engineering

BIN2DEC, DEC2BIN, HEX2DEC, CONVERT, DELTA, ERF, ERFC, complex number functions (IMSUM, IMPRODUCT, etc.), and more.

---

Functions not implemented

Some Excel functions are not available (e.g., VLOOKUP, LAMBDA, LET, FILTER, XLOOKUP, INDIRECT, OFFSET, ADDRESS, FORMULATEXT, STOCKHISTORY, and various Cube/Web/Add-in functions). Use Formula Pro custom functions or alternative approaches where needed.