9 Oct 20191 minute to read
The following are the list of formulas supported in Calculate library,
ABS
ACOS
ACOSH
ACOT
ACOTH
ADDRESS
AND
ARABIC
AREAS
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BASE
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
BINOM.DIST
BINOM.INV
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
CEILING
CEILINGMATH
CELL
CHAR
CHIDIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHOOSE
CLEAN
CODE
COLUMN
COLUMNS
COMBIN
COMBINA
CONCATENATE
CONFIDENCE.NORM
CORREL
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTBLANK
COUNTIF
CSC
CSCH
DATE
DATEVALUE
DAY
DAYS
DAYS360
DEC2BIN
DEC2OCT
DECIMAL
DEGREES
DEVSQ
DOLLAR
EDATE
EncodeURL
EOMONTH
ERROR.TYPE
EVEN
EXACT
EXP
EXPON.DIST
F.DIST
F.DIST.RT
F.INV.RT
FACT
FACTDOUBLE
FALSE
FIND
FISHER
FISHERINV
FIXED
FLOOR
FORECAST
FORMULATEXT
GAMMA.INV
GAMMALN
GAMMALN.PRECISE
GEOMEAN
HARMEAN
HEX2BIN
HEX2OCT
HLOOKUP
HOUR
HYPERLINK
IF
IFERROR
IFNA
IFS
INDEX
INDIRECT
INFO
INT
INTERCEPT
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOWEEKNUM
ISREF
ISTEXT
LARGE
LEFT
LEN
LN
LOG
LOG10
LOGNORM.DIST
LOGNORM.INV
LOOKUP
LOWER
MATCH
MAX
MAXA
MEDIAN
MID
MIN
MINA
MINUTE
MMULT
MOD
MONTH
ODD
N
NA
NEGBINOM.DIST
NETWORKDAYS
NETWORKDAYSINTL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NOT
NOW
NUMBERVALUE
OFFSET
OR
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PI
PMT
POISSON.DIST
POWER
PRODUCT
PROPER
PV
RADIANS
RAND
RANDBETWEEN
RANK.EQ
REPLACE
REPT
RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
RSQ
SEARCH
SEC
SECH
SECOND
SERIESSUM
SHEET
SHEETS
SIN
SINH
SMALL
SQRT
STANDARDIZE
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
T
T.DIST
T.INV
TAN
TEXT
TIME
TIMEVALUE
TODAY
TRANSPOSE
TRIM
TRIMMEAN
TRUE
TRUNC
TYPE
UNICHAR
UNICODE
UPPER
VALUE
VAR.P
VARA
VARPA
VLOOKUP
WEEKDAY
WEEKNUM
WEIBULL.DIST
WORKDAY
WORKDAYINTL
XOR
YEAR
ZTEST