The Apache POI library supports the following functions:
- ABS
- ACOS
- ACOSH
- ADDRESS
- AND
- AREAS
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- BIN2DEC
- CEILING
- CHAR
- CHOOSE
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMPLEX
- CONCATENATE
- COS
- COSH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- DATE
- DAY
- DAYS360
- DEC2BIN
- DEC2HEX
- DEGREES
- DELTA
- DEVSQ
- DGET
- DMAX
- DMIN
- DOLLAR
- DSUM
- EDATE
- EOMONTH
- ERROR.TYPE
- EVEN
- EXACT
- EXP
- FACT
- FACTDOUBLE
- FALSE
- FIND
- FIXED
- FLOOR
- FREQUENCY
- FV
- GEOMEAN
- HEX2DEC
- HLOOKUP
- HOUR
- HYPERLINK
- IF
- IFERROR
- IMAGINARY
- IMREAL
- INDEX
- INDIRECT
- INT
- INTERCEPT
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISREF
- ISTEXT
- LARGE
- LEFT
- LEN
- LN
- LOG
- LOG10
- LOOKUP
- LOWER
- MATCH
- MAX
- MAXA
- MDETERM
- MEDIAN
- MID
- MIN
- MINA
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MONTH
- MROUND
- NA
- NETWORKDAYS
- NOT
- NOW
- NPER
- NPV
- OCT2DEC
- ODD
- OFFSET
- OR
- PERCENTILE
- PI
- PMT
- POISSON
- POWER
- PPMT
- PRODUCT
- PROPER
- PV
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- RANK
- RATE
- REPLACE
- REPT
- RIGHT
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- SEARCH
- SECOND
- SIGN
- SIN
- SINH
- SLOPE
- SMALL
- SQRT
- STDEV
- SUBSTITUTE
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- T
- TAN
- TANH
- TEXT
- TIME
- TODAY
- TRANSPOSE
- TREND
- TRIM
- TRUE
- TRUNC
- UPPER
- VALUE
- VAR
- VARP
- VLOOKUP
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
The following functions are not supported:
- ABSREF
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- APP.TITLE
- ARGUMENT
- ASC
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BAHTTEXT
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETADIST
- BETAINV
- BIN2HEX
- BIN2OCT
- BINOMDIST
- CALL
- CELL
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CONVERT
- CORREL
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- CRITBINOM
- CUBEKPIMEMBER
- CUBEMEMBER
- CUBEMEMBERPROPERTY
- CUBERANKEDMEMBER
- CUBESET
- CUBESETCOUNT
- CUBEVALUE
- CUMIPMT
- CUMPRINC
- DATEDIF
- DATESTRING
- DATEVALUE
- DAVERAGE
- DB
- DBCS
- DCOUNT
- DCOUNTA
- DDB
- DEC2OCT
- DISC
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DSTDEV
- DSTDEVP
- DURATION
- DVAR
- DVARP
- EFFECT
- ENABLE.TOOL
- END.IF
- ERF
- ERFC
- ERROR
- EVALUATE
- EXEC
- EXPONDIST
- FDIST
- FINDB
- FINV
- FISHER
- FISHERINV
- FORECAST
- FTEST
- FVSCHEDULE
- GAMMADIST
- GAMMAINV
- GAMMALN
- GCD
- GESTEP
- GET.CELL
- GET.DOCUMENT
- GET.WINDOW
- GET.WORKBOOK
- GET.WORKSPACE
- GETPIVOTDATA
- GOTO
- GROWTH
- HARMEAN
- HEX2BIN
- HEX2OCT
- HYPGEOMDIST
- IMABS
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- INFO
- INTRATE
- ISPMT
- JIS
- KURT
- LAST.ERROR
- LCM
- LEFTB
- LENB
- LINEST
- LOGEST
- LOGINV
- LOGNORMDIST
- MDURATION
- MIDB
- MULTINOMIAL
- N
- NEGBINOMDIST
- NOMINAL
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NUMBERSTRING
- OCT2BIN
- OCT2HEX
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PEARSON
- PERCENTRANK
- PERMUT
- PHONETIC
- PRESS.TOOL
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- QUARTILE
- RECEIVED
- REGISTER.ID
- RELREF
- REPLACEB
- RETURN
- RIGHTB
- RSQ
- RTD
- SAVE.TOOLBAR
- SEARCHB
- SERIESSUM
- SKEW
- SLN
- SQRTPI
- STANDARDIZE
- STDEVA
- STDEVP
- STDEVPA
- STEP
- STEYX
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TIMEVALUE
- TINV
- TRIMMEAN
- TTEST
- TYPE
- USDOLLAR
- VARA
- VARPA
- VDB
- WEIBULL
- WINDOW.TITLE
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
- ZTEST