Excel-compatible functions
The NExS engine supports 323 Excel-compatible functions (as of 2026-10-18). They are listed by their Excel names.
A
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ADDRESS
- ALARM
- ANCHORARRAY
- AND
- ANNOTATE
- ARRAYTOTEXT
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
C
- CAVG
- CCOUNT
- CEIL
- CEILING
- CELL
- CELLREF
- CHAR
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CMAX
- CMIN
- CODE
- COL
- COLUMN
- COLUMNS
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONVERT
- CORREL
- COS
- COSH
- COUNT
- COUNTA
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CSTD
- CSTDS
- CSUM
- CTERM
- CUMIPMT
- CUMPRINC
- CVAR
- CVARS
D
- DATE
- DATEVALUE
- DAY
- DAYS
- DAYS360
- DB
- DDB
- DEGREES
- DET
- DFT
- DISC
- DOLLARDE
- DOLLARFR
- DOT
- DROP
- DURATION
E
- EDATE
- EFFECT
- EIGEN
- EOMONTH
- ERF
- ERFC
- EXACT
- EXP
- EXPAND
F
- F
- F.TEST
- FACT
- FALSE
- FFT
- FILEEXISTS
- FILTER
- FIND
- FLOOR
- FORECAST
- FORECAST.LINEAR
- FORMAT
- FRAC
- FREQUENCY
- FTEST
- FV
- FVSCHEDULE
G
- GAMMA
- GEOMEAN
- GRAND
- GROWTH
H
- HARMEAN
- HEXTONUM
- HLOOKUP
- HOUR
- HSTACK
I
- IF
- IFERROR
- IFNA
- IFS
- IMAGE
- INDEX
- INDIRECT
- INIT
- INT
- INTERP2D
- INTERP3D
- INTERSECT
- INTRATE
- INVDFT
- INVERT
- INVFFT
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISLOGICAL
- ISNA
- ISNUMBER
- ISSTRING
- ISTEXT
L
- LARGE
- LEFT
- LEN
- LINCOEF
- LINEST
- LINFIT
- LLS
- LN
- LNGAMMA
- LOG
- LOG10
- LOG2
- LOGEST
- LOOKUP
- LOWER
M
- MATCH
- MAX
- MAXIFS
- MDETERM
- MDURATION
- MEDIAN
- MESSAGE
- MID
- MIN
- MINIFS
- MINUTE
- MINVERSE
- MIRR
- MMUL
- MMULT
- MOD
- MODE
- MODE.SNGL
- MONTH
- MSQ
- MUNIT
N
- N
- NA
- NAND
- NETWORKDAYS
- NOMINAL
- NOR
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- NOW
- NPER
- NPV
- NUMTOHEX
O
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OFFSET
- OR
P
- PERCENTILE
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.INC
- PERMUT
- PI
- PLS
- PMT
- POLY
- POLYCOEF
- POLYFIT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PRODUCT
- PROPER
- PTTEST
- PV
Q
- QUARTILE
- QUARTILE.INC
R
- RADIANS
- RAND
- RANDARRAY
- RANGEREF
- RANK
- RANK.AVG
- RANK.EQ
- RATE
- RECEIVED
- REGEX
- REPLACE
- REPT
- RIGHT
- RMS
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
S
- S
- SALARM
- SEARCH
- SECOND
- SEQUENCE
- SIGMOID
- SIN
- SINH
- SLN
- SMALL
- SORT
- SORTBY
- SQRT
- SSE
- SSQ
- STANDARDIZE
- STDEV
- STDEV.P
- STDEV.S
- STDEVP
- STRING
- STRLEN
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SYD
T
- T
- T.TEST
- TAKE
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TERM
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TIME
- TIMEVALUE
- TOCOL
- TODAY
- TOROW
- TRANSPOSE
- TREND
- TRIM
- TRUE
- TRUNC
- TTEST
- TTEST2EV
- TTEST2UV
U
- UNIQUE
- UPPER
V
- VALUE
- VAR
- VAR.P
- VAR.S
- VARP
- VDB
- VECLEN
- VLOOKUP
- VSTACK
- VSUM
W
- WEEKDAY
- WORKDAY
- WRAPCOLS
- WRAPROWS
X
- XIRR
- XLOOKUP
- XMATCH
- XNPV
- XOR
- XVALUE
Y
- YEAR
- YEARFRAC
- YIELD
- YIELDDISC
- YIELDMAT
Z
- Z.TEST
- ZTEST