Navigation:  Formula Reference >

Spreadsheet Formula Functions

Previous pageReturn to chapter overviewNext page

 

Spreadsheet provides these built-in functions, listed alphabetically.

 

ABS

ACCRINT

ACCRINTM

ACOS

ACOSH

ADDRESS

AMORDEGRC

AMORLINC

AND

ASIN

ASINH

ATAN

ATAN2

ATANH

AVEDEV

AVERAGE

AVERAGEA

AVERAGEIF

AVERAGEIFS

BESSELI

BESSELJ

BESSELK

BESSELY

BETADIST

BETA.DIST

BETAINV

BETA.INV

BIN2DEC

BIN2HEX

BIN2OCT

BINOMDIST

BINOM.DIST

BINOM.INV

CEILING

CEILING.PRECISE

CHAR

CHIDIST

CHIINV

CHISQ.DIST

CHISQ.DIST.RT

CHISQ.INV

CHISQ.INV.RT

CHISQ.TEST

CHITEST

CHOOSE

CLEAN

CODE

COLUMN

COLUMNS

COMBIN

COMPLEX

CONCATENATE

CONFIDENCE

CONFIDENCE.NORM

CONFIDENCE.T

CONVERT

CORREL

COS

COSH

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

COVAR

COVARIANCE.P

COVARIANCE.S

CRITBINOM

CUMIPMT

CUMPRINC

 

 

 

DATE

DATEDIF

DATEVALUE

DAVERAGE

DAY

DAYS360

DB

DCOUNT

DCOUNTA

DDB

DEC2BIN

DEC2HEX

DEC2OCT

DEGREES

DELTA

DEVSQ

DGET

DISC

DMAX

DMIN

DOLLAR

DOLLARDE

DOLLARFR

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DURATION

DVAR

DVARP

EDATE

EFFECT

EOMONTH

ERF

ERF.PRECISE

ERFC

ERFC.PRECISE

ERROR.TYPE

EURO

EUROCONVERT

EVEN

EXACT

EXP

EXPONDIST

EXPON.DIST

 

FACT

FACTDOUBLE

FALSE

FDIST

F.DIST

F.DIST.RT

FIND

FINV

F.INV

F.INV.RT

FISHER

FISHERINV

FIXED

FLOOR

FLOOR.PRECISE

FORECAST

FREQUENCY

FTEST

F.TEST

FV

FVSCHEDULE

GAMMADIST

GAMMA.DIST

GAMMAINV

GAMMA.INV

GAMMALN

GAMMALN.PRECISE

GCD

GEOMEAN

GESTEP

GROWTH

HARMEAN

HEX2BIN

HEX2DEC

HEX2OCT

HLOOKUP

HOUR

HYPGEOMDIST

HYPGEOM.DIST

 

IF

IFERROR

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMCOS

IMDIV

IMEXP

IMLN

IMLOG2

IMLOG10

IMPOWER

IMPRODUCT

IMREAL

IMSIN

IMSQRT

IMSUB

IMSUM

INDEX

INDIRECT

INT

INTERCEPT

INTRATE

IPMT

IRR

ISBLANK

ISERR

ISERROR

ISEVEN

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISO.CEILING

ISODD

ISPMT

ISREF

ISTEXT

KURT

LARGE

LCM

LEFT

LEN

LINEST

LN

LOG

LOG10

LOGEST

LOGINV

LOGNORMDIST

LOGNORM.DIST

LOGNORM.INV

LOOKUP

LOWER

 

 

 

MATCH

MAX

MAXA

MDETERM

MDURATION

MEDIAN

MID

MIN

MINA

MINUTE

MINVERSE

MIRR

MMULT

MOD

MODE

MODE.MULT

MODE.SNGL

MONTH

MROUND

MULTINOMIAL

NEGBINOMDIST

NEGBINOM.DIST

N

NA

NETWORKDAYS

NETWORKDAYS.INTL

NOMINAL

NORMDIST

NORM.DIST

NORMINV

NORM.INV

NORMSDIST

NORM.S.DIST

NORMSINV

NORM.S.INV

NOT

NOW

NPER

NPV

OCT2BIN

OCT2DEC

OCT2HEX

ODD

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

OFFSET

OR

OFFSET

 

 

PEARSON

PERCENTILE

PERCENTILE.EXC

PERCENTILE.INC

PERCENTRANK

PERCENTRANK.EXC

PERCENTRANK.INC

PERMUT

PI

PMT

POISSON

POISSON.DIST

POWER

PPMT

PRICE

PRICEDISC

PRICEMAT

PROB

PRODUCT

PROPER

PV

QUARTILE

QUARTILE.EXC

QUARTILE.INC

QUOTIENT

RADIANS

RAND

RANDBETWEEN

RANK

RANK.AVG

RANK.EQ

RATE

RECEIVED

REFRESH

REPLACE

REPT

RIGHT

ROMAN

ROUND

ROUNDDOWN

ROUNDUP

ROW

ROWS

RSQ

 

 

SEARCH

SECOND

SERIESSUM

SIGN

SIN

SINH

SKEW

SLN

SLOPE

SMALL

SQRT

SQRTPI

STANDARDIZE

STDEV

STDEVA

STDEVP

STDEV.P

STDEVPA

STDEV.S

STEYX

SUBSTITUTE

SUBTOTAL

SUM

SUMIF

SUMIFS

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

SYD

T

TAN

TANH

TBILLEQ

TBILLPRICE

TBILLYIELD

TDIST

T.DIST

T.DIST.2T

T.DIST.RT

TEXT

TIME

TIMEVALUE

TINV

T.INV

T.INV.2T

TODAY

TRANSPOSE

TREND

TRIM

TRIMMEAN

TRUE

TRUNC

TTEST

T.TEST

TYPE

 

UPPER

VALUE

VAR

VARA

VARP

VAR.P

VARPA

VAR.S

VDB

VLOOKUP

WEEKDAY

WEEKNUM

WEIBULL

WEIBULL.DIST

WORKDAY

WORKDAY.INTL

XIRR

XNPV

YEAR

YEARFRAC

YIELD

YIELDDISC

YIELDMAT

ZTEST

Z.TEST