FormulaEngineer — A Highly Accurate Excel Formula Engine with support for 315+ Excel functions — explore the complete list new · v1.0.1

Supported functions

318 Excel functions, organized by family.

Every function below is implemented and tested against real-world workbooks.

Lookup & Reference

24 functions covering lookups, references, dynamic arrays, and spill semantics.

ADDRESS
AREAS
CHOOSE
CHOOSECOLS
CHOOSEROWS
COLUMN
COLUMNS
COUNTBLANK
FILTER
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
SEQUENCE
SORT
TRANSPOSE
UNIQUE
VLOOKUP
XLOOKUP

Financial

43 functions covering loans, investments, depreciation, securities, and yield calculations.

ACCRINT
ACCRINTM
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
PDURATION
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT

Statistical

54 functions covering aggregates, distributions, forecasting, correlation, and rank.

AGGREGATE
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BINOM.DIST
BINOM.INV
CONFIDENCE.NORM
CONFIDENCE.T
CORREL
COUNT
COUNTA
COUNTIF
COUNTIFS
FORECAST
FORECAST.LINEAR
FREQUENCY
LARGE
MAX
MAXIFS
MEDIAN
MIN
MINIFS
MODE
MODE.MULT
MODE.SNGL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
POISSON.DIST
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
SMALL
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA
SUBTOTAL
T.DIST
T.INV
VAR
VAR.P
VAR.S
VARA
VARPA

Math & Trig

45 functions covering arithmetic, rounding, powers, factorials, trigonometry, and basic random.

ABS
ACOS
ASIN
ATAN
CEILING
CEILING.MATH
CEILING.PRECISE
COS
COT
CSC
DEGREES
EVEN
EXP
FACT
FLOOR
FLOOR.MATH
FLOOR.PRECISE
INT
LN
LOG
LOG10
MMULT
MOD
MROUND
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
SEC
SIGN
SIN
SQRT
SUM
SUMIF
SUMIFS
SUMPRODUCT
TAN
TRUNC

Text

40 functions covering concatenation, substring, search, case, number parsing, and split.

CHAR
CLEAN
CODE
CONCAT
CONCATENATE
DOLLAR
EXACT
FIND
FINDB
FIXED
FORMULATEXT
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
NUMBERVALUE
PROPER
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTAFTER
TEXTBEFORE
TEXTJOIN
TEXTSPLIT
TRIM
UNICHAR
UNICODE
UPPER
USDOLLAR
VALUE

Date & Time

25 functions covering serial dates, business days, ISO weeks, and date math.

DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
HOUR
ISOWEEKNUM
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC

Logical

11 functions covering conditionals, boolean operations, and error handling.

AND
FALSE
IF
IFERROR
IFNA
IFS
NOT
OR
SWITCH
TRUE
XOR

Information

19 functions covering type checks, cell metadata, error introspection, and sheet info.

CELL
ERROR.TYPE
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
N
NA
SHEET
SHEETS
TYPE

Database

12 functions for criteria-based aggregation across structured data tables.

DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP

Engineering

45 functions covering unit conversion, base conversion (binary/hex/octal), bitwise operations, and complex number arithmetic.

BIN2DEC
BIN2HEX
BIN2OCT
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
OCT2BIN
OCT2DEC
OCT2HEX
Don't see a function you need? Email nasrullahkazmi@nasvelocityexcel.com with the function name and a sample use case. We prioritize new function support based on customer demand.