Supported Formulas

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

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

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