Function Finder
Search by name or category. A linked guide includes sample data, expected results and troubleshooting. Entries without a guide remain a name-and-category index; availability varies by spreadsheet product and version.
ABS
Returns the absolute value.
ACCRINT
ACCRINTM
ACOS
ACOSH
ACOT
ACOTH
ADDRESS
AGGREGATE
AMORDEGRC
AMORLINC
AND
Returns TRUE when all tests are true.
ARABIC
AREAS
ARRAYTOTEXT
ASC
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
Returns the arithmetic mean.
AVERAGEA
AVERAGEIF
Averages values matching one condition.
AVERAGEIFS
Averages values matching multiple conditions.
BAHTTEXT
BASE
BESSELI
BESSELJ
BESSELK
BESSELY
BETA.DIST
BETA.INV
BIN2DEC
BIN2HEX
BIN2OCT
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
BYCOL
BYROW
CEILING
CEILING.MATH
CEILING.PRECISE
CELL
CHAR
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHOOSE
Chooses a value from a list by index.
CHOOSECOLS
CHOOSEROWS
CLEAN
CODE
COLUMN
Returns a column number.
COLUMNS
Returns the number of columns in a reference.
COMBIN
COMBINA
COMPLEX
CONCAT
CONCATENATE
CONFIDENCE.NORM
CONFIDENCE.T
CONVERT
CORREL
COS
COSH
COT
COTH
COUNT
Counts cells containing numbers.
COUNTA
Counts non-empty cells.
COUNTBLANK
COUNTIF
Counts cells matching one condition.
COUNTIFS
Counts cells matching multiple conditions.
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
COVARIANCE.P
COVARIANCE.S
CSC
CSCH
CUBEKPIMEMBER
CUBEMEMBER
CUBEMEMBERPROPERTY
CUBERANKEDMEMBER
CUBESET
CUBESETCOUNT
CUBEVALUE
CUMIPMT
CUMPRINC
DATE
Builds a date from year, month and day.
DATEDIF
DATEVALUE
DAVERAGE
DAY
Returns the day of month.
DAYS
DAYS360
DB
DBCS
DCOUNT
DCOUNTA
DDB
DEC2BIN
DEC2HEX
DEC2OCT
DECIMAL
DEGREES
DELTA
DEVSQ
DGET
DISC
DMAX
DMIN
DOLLAR
DOLLARDE
DOLLARFR
DPRODUCT
DROP
DSTDEV
DSTDEVP
DSUM
DURATION
DVAR
DVARP
EDATE
Moves a date by whole months.
EFFECT
ENCODEURL
EOMONTH
Returns the last day of a month offset.
ERF
ERF.PRECISE
ERFC
ERFC.PRECISE
ERROR.TYPE
EVEN
EXACT
EXP
EXPAND
EXPON.DIST
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FACT
FACTDOUBLE
FALSE
FILTER
Filters a range using criteria.
FILTERXML
FIND
Finds case-sensitive text.
FISHER
FISHERINV
FIXED
FLOOR
FLOOR.MATH
FLOOR.PRECISE
FORECAST.ETS
FORECAST.ETS.CONFINT
FORECAST.ETS.SEASONALITY
FORECAST.ETS.STAT
FORECAST.LINEAR
FORMULATEXT
Returns a formula as text.
FREQUENCY
FV
FVSCHEDULE
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMALN
GAMMALN.PRECISE
GAUSS
GCD
GEOMEAN
GESTEP
GETPIVOTDATA
GROWTH
HARMEAN
HEX2BIN
HEX2DEC
HEX2OCT
HLOOKUP
Looks horizontally in the first row of a table.
HOUR
HSTACK
HYPERLINK
Creates a clickable hyperlink.
HYPGEOM.DIST
IF
Returns one value when a test is true and another when false.
IFERROR
Returns a fallback value when a formula errors.
IFNA
Returns a fallback when #N/A occurs.
IFS
Tests multiple conditions in order.
IMABS
IMAGE
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
INDEX
Returns a value at a row and column position.
INDIRECT
Builds a reference from text.
INFO
INT
Rounds a number down to an integer.
INTERCEPT
INTRATE
IPMT
IRR
ISBLANK
Tests whether a cell is blank.
ISERR
ISERROR
Tests whether a value is an error.
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
Tests whether a value is numeric.
ISO.CEILING
ISODD
ISOMITTED
ISOWEEKNUM
ISPMT
ISREF
ISTEXT
Tests whether a value is text.
KURT
LAMBDA
LARGE
Returns the k-th largest value.
LCM
LEFT
Returns characters from the start of text.
LEN
Returns the number of characters in text.
LET
Assigns names to calculation results inside a formula.
LINEST
LN
LOG
LOG10
LOGEST
LOGNORM.DIST
LOGNORM.INV
LOOKUP
Looks up a value in a vector or array.
LOWER
Converts text to lowercase.
MATCH
Returns the relative position of a value.
MAX
Returns the largest value.
MAXA
MAXIFS
MDETERM
MDURATION
MEDIAN
Returns the median.
MID
Returns characters from the middle of text.
MIN
Returns the smallest value.
MINA
MINIFS
MINUTE
MINVERSE
MIRR
MMULT
MOD
Returns the remainder after division.
MODE.MULT
MODE.SNGL
MONTH
Returns the month from a date.
MROUND
MULTINOMIAL
MUNIT
N
NA
NEGBINOM.DIST
NETWORKDAYS
Counts working days between dates.
NETWORKDAYS.INTL
NOMINAL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NOT
Reverses a logical value.
NOW
Returns the current date and time.
NPER
NPV
NUMBERVALUE
OCT2BIN
OCT2DEC
OCT2HEX
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OFFSET
Returns a reference offset from a starting cell.
OR
Returns TRUE when any test is true.
PDURATION
PEARSON
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK.EXC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PHI
PHONETIC
PI
PMT
POISSON.DIST
POWER
Raises a number to a power.
PPMT
PRICE
PRICEDISC
PRICEMAT
PROB
PRODUCT
Multiplies supplied numbers.
PROPER
Capitalizes words.
PV
QUARTILE.EXC
QUARTILE.INC
QUOTIENT
RADIANS
RAND
Returns a random number between 0 and 1.
RANDARRAY
RANDBETWEEN
Returns a random integer between two values.
RANK.AVG
RANK.EQ
RATE
RECEIVED
REDUCE
REPLACE
Replaces text by position.
REPT
RIGHT
Returns characters from the end of text.
ROMAN
ROUND
Rounds a number to a specified number of digits.
ROUNDDOWN
Rounds toward zero.
ROUNDUP
Rounds away from zero.
ROW
Returns a row number.
ROWS
Returns the number of rows in a reference.
RRI
RSQ
RTD
SCAN
SEARCH
Finds text without case sensitivity.
SEC
SECH
SECOND
SERIESSUM
SHEET
SHEETS
SIGN
SIN
SINH
SKEW
SKEW.P
SLN
SLOPE
SMALL
Returns the k-th smallest value.
SORT
Sorts a range or array.
SORTBY
SQRT
Returns a square root.
SQRTPI
STANDARDIZE
STDEV.P
STDEV.S
STDEVA
STDEVPA
STEYX
SUBSTITUTE
Replaces matching text.
SUBTOTAL
Calculates a subtotal while optionally ignoring hidden rows.
SUM
Adds numbers or ranges.
SUMIF
Adds values matching one condition.
SUMIFS
Adds values matching multiple conditions.
SUMPRODUCT
Multiplies corresponding values and returns their sum.
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SWITCH
Matches a value against a list of cases.
SYD
T
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
TAKE
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TEXT
Formats a value as text.
TEXTAFTER
TEXTBEFORE
TEXTJOIN
Joins text with a delimiter.
TEXTSPLIT
TIME
TIMEVALUE
TOCOL
TODAY
Returns today’s date.
TOROW
TRANSPOSE
Switches rows and columns.
TREND
TRIM
Removes extra spaces from text.
TRIMMEAN
TRUE
TRUNC
Truncates a number to a set number of digits.
TYPE
UNICHAR
UNICODE
UNIQUE
Returns unique values.
UPPER
Converts text to uppercase.
VALUE
Converts text representing a number into a number.
VALUETOTEXT
VAR.P
VAR.S
VARA
VARPA
VDB
VLOOKUP
Looks vertically in the first column of a table.
VSTACK
WEBSERVICE
WEEKDAY
Returns the weekday number.
WEEKNUM
Returns the week number.
WEIBULL.DIST
WORKDAY
Returns a workday before or after a date.
WORKDAY.INTL
WRAPCOLS
WRAPROWS
XIRR
XLOOKUP
Looks up a value in a range and returns a corresponding result.
XMATCH
Modern match function with flexible search modes.
XNPV
XOR
Returns TRUE when an odd number of tests are true.
YEAR
Returns the year from a date.