Formula Function Reference

ABS

ABS(number)

ACOS

ACOS(number)

ACOSH

ACOSH(number)

ACOT

ACOT(number)

ACOTH

ACOTH(number)

ASIN

ASIN(number)

ASINH

ASINH(number)

ATAN

ATAN(number)

ATAN2

ATAN2(x, y)

ATANH

ATANH(number)

CEILING

CEILING(number, significance)

COS

COS(angle)

COSH

COSH(number)

COT

COT(angle)

COTH

COTH(number)

DEGREES

DEGREES(angle)

EVEN

EVEN(arg1)

EXP

EXP(number)

FACT

FACT(arg1)

FACTDOUBLE

FACTDOUBLE(arg1)

FLOOR

FLOOR(number, significance)

GCD

GCD()

INT

INT(number)

LCM

LCM()

LN

LN(number)

LOG

LOG(number, [base])

LOG10

LOG10(number)

MOD

MOD(number, divisor)

MROUND

MROUND(arg1, arg2)

MULTINOMIAL

MULTINOMIAL()

ODD

ODD(arg1)

PI

PI()

POWER

POWER(number, power)

PRODUCT

PRODUCT()

QUOTIENT

QUOTIENT(numerator, denominator)

RADIANS

RADIANS(angle)

RAND

RAND()

RANDBETWEEN

RANDBETWEEN(arg1, arg2)

ROMAN

ROMAN(arg1, arg2)

ROUND

ROUND(number, digits)

ROUNDDOWN

ROUNDDOWN(number, digits)

ROUNDUP

ROUNDUP(number, digits)

SEC

SEC(angle)

SECH

SECH(number)

SIGN

SIGN(number)

SIN

SIN(angle)

SINH

SINH(number)

SQRT

SQRT(number)

SQRTPI

SQRTPI(arg1)

SUM

SUM(number1, [number2], ...)

SUMIF

SUMIF(range, criteria, [sum_range])

SUMIFS

SUMIFS(sum_range, criteria_range1, criteria1, ...)

SUMPRODUCT

SUMPRODUCT(array1, [array2], ...)

SUMSQ

SUMSQ(number1, [number2], ...)

SUMX2MY2

SUMX2MY2(arg1, arg2)

SUMX2PY2

SUMX2PY2(arg1, arg2)

SUMXMY2

SUMXMY2(arg1, arg2)

TAN

TAN(angle)

TANH

TANH(number)

TRUNC

TRUNC(number, [digits])

AVEDEV

AVEDEV()

AVERAGE

AVERAGE(number1, [number2], ...)

AVERAGEA

AVERAGEA()

AVERAGEIF

AVERAGEIF(arg1, arg2, arg3, arg4)

AVERAGEIFS

AVERAGEIFS()

BETA.DIST

BETA.DIST(arg1, arg2, arg3, arg4, arg5, arg6)

BETA.INV

BETA.INV(arg1, arg2, arg3, arg4, arg5)

BINOM.DIST

BINOM.DIST(arg1, arg2, arg3, arg4)

BINOM.INV

BINOM.INV(arg1, arg2, arg3)

CHISQ.DIST

CHISQ.DIST(x, deg_freedom, cumulative)

CHISQ.DIST.RT

CHISQ.DIST.RT(x, deg_freedom)

CHISQ.INV

CHISQ.INV(probability, deg_freedom)

CHISQ.INV.RT

CHISQ.INV.RT(probability, deg_freedom)

CONFIDENCE.NORM

CONFIDENCE.NORM(arg1, arg2, arg3)

CONFIDENCE.T

CONFIDENCE.T(arg1, arg2, arg3)

CORREL

CORREL(array1, array2)

COUNT

COUNT(value1, [value2], ...)

COUNTA

COUNTA(value1, [value2], ...)

COUNTBLANK

COUNTBLANK()

COUNTIF

COUNTIF(range, criteria)

COUNTIFS

COUNTIFS(criteria_range1, criteria1, ...)

COVARIANCE.P

COVARIANCE.P(array1, array2)

COVARIANCE.S

COVARIANCE.S(array1, array2)

DEVSQ

DEVSQ()

EXPON.DIST

EXPON.DIST(arg1, arg2, arg3)

F.DIST

F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

F.DIST.RT

F.DIST.RT(x, deg_freedom1, deg_freedom2)

F.INV

F.INV(probability, deg_freedom1, deg_freedom2)

F.INV.RT

F.INV.RT(probability, deg_freedom1, deg_freedom2)

FISHER

FISHER(arg1)

FISHERINV

FISHERINV(arg1)

FORECAST

FORECAST(arg1, arg2, arg3)

FREQUENCY

FREQUENCY(arg1, arg2)

GAMMA

GAMMA(arg1)

GAMMA.DIST

GAMMA.DIST(arg1, arg2, arg3, arg4)

GAMMA.INV

GAMMA.INV(arg1, arg2, arg3)

GAMMALN

GAMMALN(arg1)

GAUSS

GAUSS(arg1)

GEOMEAN

GEOMEAN()

GROWTH

GROWTH(arg1, arg2, arg3, arg4)

HARMEAN

HARMEAN()

HYPGEOM.DIST

HYPGEOM.DIST(arg1, arg2, arg3, arg4, arg5)

INTERCEPT

INTERCEPT(arg1, arg2)

KURT

KURT()

LARGE

LARGE()

LOGNORM.DIST

LOGNORM.DIST(arg1, arg2, arg3, arg4)

LOGNORM.INV

LOGNORM.INV(arg1, arg2, arg3)

MAX

MAX(number1, [number2], ...)

MEDIAN

MEDIAN(number1, [number2], ...)

MIN

MIN(number1, [number2], ...)

MODE.SNGL

MODE.SNGL()

NEGBINOM.DIST

NEGBINOM.DIST(arg1, arg2, arg3, arg4)

NORM.DIST

NORM.DIST(x, mean, standard_dev, cumulative)

NORM.INV

NORM.INV(probability, mean, standard_dev)

NORM.S.DIST

NORM.S.DIST(z, cumulative)

NORM.S.INV

NORM.S.INV(probability)

PEARSON

PEARSON()

PERCENTILE.EXC

PERCENTILE.EXC()

PERCENTILE.INC

PERCENTILE.INC()

PERCENTRANK.EXC

PERCENTRANK.EXC()

PERCENTRANK.INC

PERCENTRANK.INC()

PERMUT

PERMUT()

PHI

PHI(arg1)

POISSON.DIST

POISSON.DIST(arg1, arg2, arg3)

QUARTILE.EXC

QUARTILE.EXC()

QUARTILE.INC

QUARTILE.INC()

RANK.AVG

RANK.AVG(number, ref, [order])

RANK.EQ

RANK.EQ(number, ref, [order])

RSQ

RSQ()

SKEW

SKEW()

SLOPE

SLOPE()

SMALL

SMALL()

STANDARDIZE

STANDARDIZE(x, mean, standard_dev)

STDEV.P

STDEV.P(number1, [number2], ...)

STDEV.S

STDEV.S(number1, [number2], ...)

STEYX

STEYX()

T.DIST

T.DIST(x, deg_freedom, cumulative)

T.DIST.2T

T.DIST.2T(x, deg_freedom)

T.DIST.RT

T.DIST.RT(x, deg_freedom)

T.INV

T.INV(probability, deg_freedom)

T.INV.2T

T.INV.2T(probability, deg_freedom)

TRIMMEAN

TRIMMEAN()

VAR.P

VAR.P(number1, [number2], ...)

VAR.S

VAR.S(number1, [number2], ...)

WEIBULL.DIST

WEIBULL.DIST(arg1, arg2, arg3, arg4)

Z.TEST

Z.TEST()

AND

AND(logical1, [logical2], ...)

FALSE

FALSE()

IF

IF(condition, value_if_true, [value_if_false])

IFERROR

IFERROR(value, value_if_error)

IFNA

IFNA(value, value_if_na)

IFS

IFS()

NOT

NOT(logical)

OR

OR(logical1, [logical2], ...)

TRUE

TRUE()

XOR

XOR(logical1, [logical2], ...)

DATE

DATE(year, month, day)

DATEDIF

DATEDIF(arg1, arg2, arg3)

DATEVALUE

DATEVALUE(arg1)

DAY

DAY(date)

DAYS

DAYS(arg1, arg2)

DAYS360

DAYS360(arg1, arg2, arg3)

EDATE

EDATE(arg1, arg2)

EOMONTH

EOMONTH(arg1, arg2)

HOUR

HOUR(time)

ISOWEEKNUM

ISOWEEKNUM(arg1)

MINUTE

MINUTE(time)

MONTH

MONTH(date)

NETWORKDAYS

NETWORKDAYS(arg1, arg2, arg3)

NETWORKDAYS.INTL

NETWORKDAYS.INTL(arg1, arg2, arg3, arg4)

NOW

NOW()

SECOND

SECOND(time)

TIME

TIME(hour, minute, second)

TIMEVALUE

TIMEVALUE(arg1)

TODAY

TODAY()

WEEKDAY

WEEKDAY(date, [type])

WEEKNUM

WEEKNUM(arg1, arg2)

WORKDAY

WORKDAY(arg1, arg2, arg3)

WORKDAY.INTL

WORKDAY.INTL(arg1, arg2, arg3, arg4)

YEAR

YEAR(date)

YEARFRAC

YEARFRAC(arg1, arg2, arg3)

ACCRINT

ACCRINT()

ACCRINTM

ACCRINTM()

CUMIPMT

CUMIPMT()

CUMPRINC

CUMPRINC()

DB

DB()

DDB

DDB()

DOLLARDE

DOLLARDE()

DOLLARFR

DOLLARFR()

EFFECT

EFFECT()

FV

FV()

IPMT

IPMT()

IRR

IRR()

MIRR

MIRR()

NOMINAL

NOMINAL()

NPER

NPER()

NPV

NPV()

PMT

PMT()

PPMT

PPMT()

PRICE

PRICE()

PV

PV()

RATE

RATE()

SLN

SLN()

SYD

SYD()

XIRR

XIRR()

XNPV

XNPV()

YIELD

YIELD()

BESSELI

BESSELI(arg1, arg2)

BESSELJ

BESSELJ(arg1, arg2)

BESSELK

BESSELK(arg1, arg2)

BESSELY

BESSELY(arg1, arg2)

BIN2DEC

BIN2DEC(arg1)

BIN2HEX

BIN2HEX(arg1, arg2)

BIN2OCT

BIN2OCT(arg1, arg2)

BITAND

BITAND(arg1, arg2)

BITLSHIFT

BITLSHIFT(arg1, arg2)

BITOR

BITOR(arg1, arg2)

BITRSHIFT

BITRSHIFT(arg1, arg2)

BITXOR

BITXOR(arg1, arg2)

COMPLEX

COMPLEX(arg1, arg2, arg3)

CONVERT

CONVERT()

DEC2BIN

DEC2BIN(arg1, arg2)

DEC2HEX

DEC2HEX(arg1, arg2)

DEC2OCT

DEC2OCT(arg1, arg2)

DELTA

DELTA(arg1, arg2)

ERF

ERF(arg1, arg2)

ERF.PRECISE

ERF.PRECISE()

ERFC

ERFC(arg1)

GESTEP

GESTEP(arg1, arg2)

HEX2BIN

HEX2BIN(arg1, arg2)

HEX2DEC

HEX2DEC(arg1)

HEX2OCT

HEX2OCT(arg1, arg2)

IMABS

IMABS(arg1)

IMAGINARY

IMAGINARY(arg1)

IMARGUMENT

IMARGUMENT(arg1)

IMCONJUGATE

IMCONJUGATE(arg1)

IMCOS

IMCOS(arg1)

IMCOSH

IMCOSH(arg1)

IMCOT

IMCOT(arg1)

IMCSC

IMCSC(arg1)

IMCSCH

IMCSCH(arg1)

IMDIV

IMDIV(arg1, arg2)

IMEXP

IMEXP(arg1)

IMLN

IMLN(arg1)

IMLOG10

IMLOG10(arg1)

IMLOG2

IMLOG2(arg1)

IMPOWER

IMPOWER(arg1, arg2)

IMPRODUCT

IMPRODUCT()

IMREAL

IMREAL(arg1)

IMSEC

IMSEC(arg1)

IMSECH

IMSECH(arg1)

IMSIN

IMSIN(arg1)

IMSINH

IMSINH(arg1)

IMSQRT

IMSQRT(arg1)

IMSUB

IMSUB(arg1, arg2)

IMSUM

IMSUM()

IMTAN

IMTAN(arg1)

OCT2BIN

OCT2BIN(arg1, arg2)

OCT2DEC

OCT2DEC(arg1)

OCT2HEX

OCT2HEX(arg1, arg2)