Function Finder

Math & trigonometry

ABS

Returns the absolute value.

Reference listing

Financial

ACCRINT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

ACCRINTM

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Math & trigonometry

ACOS

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ACOSH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ACOT

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ACOTH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Lookup & reference

ADDRESS

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Math & trigonometry

AGGREGATE

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Financial

AMORDEGRC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

AMORLINC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Logical

AND

Returns TRUE when all tests are true.

Open guide →

Math & trigonometry

ARABIC

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Lookup & reference

AREAS

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Text

ARRAYTOTEXT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

ASC

Reference entry for a spreadsheet function in the Text category.

Reference listing

Math & trigonometry

ASIN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ASINH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ATAN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ATAN2

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ATANH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

AVEDEV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

AVERAGE

Returns the arithmetic mean.

Open guide →

Statistical

AVERAGEA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

AVERAGEIF

Averages values matching one condition.

Reference listing

Statistical

AVERAGEIFS

Averages values matching multiple conditions.

Reference listing

Text

BAHTTEXT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Math & trigonometry

BASE

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Engineering

BESSELI

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BESSELJ

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BESSELK

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BESSELY

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Statistical

BETA.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

BETA.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Engineering

BIN2DEC

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BIN2HEX

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BIN2OCT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Statistical

BINOM.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

BINOM.DIST.RANGE

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

BINOM.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Engineering

BITAND

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BITLSHIFT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BITOR

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BITRSHIFT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

BITXOR

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Logical

BYCOL

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Logical

BYROW

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Math & trigonometry

CEILING

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

CEILING.MATH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

CEILING.PRECISE

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Information

CELL

Reference entry for a spreadsheet function in the Information category.

Reference listing

Text

CHAR

Reference entry for a spreadsheet function in the Text category.

Reference listing

Statistical

CHISQ.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

CHISQ.DIST.RT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

CHISQ.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

CHISQ.INV.RT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

CHISQ.TEST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Lookup & reference

CHOOSE

Chooses a value from a list by index.

Reference listing

Lookup & reference

CHOOSECOLS

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Lookup & reference

CHOOSEROWS

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Text

CLEAN

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

CODE

Reference entry for a spreadsheet function in the Text category.

Reference listing

Lookup & reference

COLUMN

Returns a column number.

Reference listing

Lookup & reference

COLUMNS

Returns the number of columns in a reference.

Reference listing

Math & trigonometry

COMBIN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

COMBINA

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Engineering

COMPLEX

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Text

CONCAT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

CONCATENATE

Reference entry for a spreadsheet function in the Text category.

Reference listing

Statistical

CONFIDENCE.NORM

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

CONFIDENCE.T

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Engineering

CONVERT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Statistical

CORREL

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

COS

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

COSH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

COT

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

COTH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

COUNT

Counts cells containing numbers.

Reference listing

Statistical

COUNTA

Counts non-empty cells.

Reference listing

Statistical

COUNTBLANK

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

COUNTIF

Counts cells matching one condition.

Open guide →

Statistical

COUNTIFS

Counts cells matching multiple conditions.

Reference listing

Financial

COUPDAYBS

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

COUPDAYS

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

COUPDAYSNC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

COUPNCD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

COUPNUM

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

COUPPCD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

COVARIANCE.P

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

COVARIANCE.S

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

CSC

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

CSCH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Cube

CUBEKPIMEMBER

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Cube

CUBEMEMBER

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Cube

CUBEMEMBERPROPERTY

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Cube

CUBERANKEDMEMBER

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Cube

CUBESET

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Cube

CUBESETCOUNT

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Cube

CUBEVALUE

Reference entry for a spreadsheet function in the Cube category.

Reference listing

Financial

CUMIPMT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

CUMPRINC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Date & time

DATE

Builds a date from year, month and day.

Open guide →

Date & time

DATEDIF

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Date & time

DATEVALUE

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Database

DAVERAGE

Reference entry for a spreadsheet function in the Database category.

Reference listing

Date & time

DAY

Returns the day of month.

Reference listing

Date & time

DAYS

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Date & time

DAYS360

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Financial

DB

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Text

DBCS

Reference entry for a spreadsheet function in the Text category.

Reference listing

Database

DCOUNT

Reference entry for a spreadsheet function in the Database category.

Reference listing

Database

DCOUNTA

Reference entry for a spreadsheet function in the Database category.

Reference listing

Financial

DDB

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Engineering

DEC2BIN

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

DEC2HEX

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

DEC2OCT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Math & trigonometry

DECIMAL

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

DEGREES

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Engineering

DELTA

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Statistical

DEVSQ

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Database

DGET

Reference entry for a spreadsheet function in the Database category.

Reference listing

Financial

DISC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Database

DMAX

Reference entry for a spreadsheet function in the Database category.

Reference listing

Database

DMIN

Reference entry for a spreadsheet function in the Database category.

Reference listing

Text

DOLLAR

Reference entry for a spreadsheet function in the Text category.

Reference listing

Financial

DOLLARDE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

DOLLARFR

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Database

DPRODUCT

Reference entry for a spreadsheet function in the Database category.

Reference listing

Lookup & reference

DROP

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Database

DSTDEV

Reference entry for a spreadsheet function in the Database category.

Reference listing

Database

DSTDEVP

Reference entry for a spreadsheet function in the Database category.

Reference listing

Database

DSUM

Reference entry for a spreadsheet function in the Database category.

Reference listing

Financial

DURATION

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Database

DVAR

Reference entry for a spreadsheet function in the Database category.

Reference listing

Database

DVARP

Reference entry for a spreadsheet function in the Database category.

Reference listing

Date & time

EDATE

Moves a date by whole months.

Reference listing

Financial

EFFECT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Web

ENCODEURL

Reference entry for a spreadsheet function in the Web category.

Reference listing

Date & time

EOMONTH

Returns the last day of a month offset.

Open guide →

Engineering

ERF

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

ERF.PRECISE

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

ERFC

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

ERFC.PRECISE

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Information

ERROR.TYPE

Reference entry for a spreadsheet function in the Information category.

Reference listing

Math & trigonometry

EVEN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Text

EXACT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Math & trigonometry

EXP

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Lookup & reference

EXPAND

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Statistical

EXPON.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

F.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

F.DIST.RT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

F.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

F.INV.RT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

F.TEST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

FACT

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

FACTDOUBLE

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Logical

FALSE

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Lookup & reference

FILTER

Filters a range using criteria.

Open guide →

Web

FILTERXML

Reference entry for a spreadsheet function in the Web category.

Reference listing

Text

FIND

Finds case-sensitive text.

Reference listing

Statistical

FISHER

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

FISHERINV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Text

FIXED

Reference entry for a spreadsheet function in the Text category.

Reference listing

Math & trigonometry

FLOOR

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

FLOOR.MATH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

FLOOR.PRECISE

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

FORECAST.ETS

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

FORECAST.ETS.CONFINT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

FORECAST.ETS.SEASONALITY

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

FORECAST.ETS.STAT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

FORECAST.LINEAR

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Lookup & reference

FORMULATEXT

Returns a formula as text.

Reference listing

Statistical

FREQUENCY

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Financial

FV

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

FVSCHEDULE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

GAMMA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

GAMMA.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

GAMMA.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

GAMMALN

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

GAMMALN.PRECISE

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

GAUSS

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

GCD

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

GEOMEAN

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Engineering

GESTEP

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Lookup & reference

GETPIVOTDATA

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Statistical

GROWTH

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

HARMEAN

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Engineering

HEX2BIN

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

HEX2DEC

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

HEX2OCT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Lookup & reference

HLOOKUP

Looks horizontally in the first row of a table.

Reference listing

Date & time

HOUR

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Lookup & reference

HSTACK

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Lookup & reference

HYPERLINK

Creates a clickable hyperlink.

Open guide →

Statistical

HYPGEOM.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Logical

IF

Returns one value when a test is true and another when false.

Open guide →

Logical

IFERROR

Returns a fallback value when a formula errors.

Open guide →

Logical

IFNA

Returns a fallback when #N/A occurs.

Reference listing

Logical

IFS

Tests multiple conditions in order.

Reference listing

Engineering

IMABS

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Lookup & reference

IMAGE

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Engineering

IMAGINARY

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMARGUMENT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMCONJUGATE

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMCOS

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMCOSH

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMCOT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMCSC

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMCSCH

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMDIV

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMEXP

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMLN

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMLOG10

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMLOG2

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMPOWER

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMPRODUCT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMREAL

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSEC

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSECH

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSIN

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSINH

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSQRT

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSUB

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMSUM

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

IMTAN

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Lookup & reference

INDEX

Returns a value at a row and column position.

Open guide →

Lookup & reference

INDIRECT

Builds a reference from text.

Reference listing

Information

INFO

Reference entry for a spreadsheet function in the Information category.

Reference listing

Math & trigonometry

INT

Rounds a number down to an integer.

Reference listing

Statistical

INTERCEPT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Financial

INTRATE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

IPMT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

IRR

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Information

ISBLANK

Tests whether a cell is blank.

Reference listing

Information

ISERR

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISERROR

Tests whether a value is an error.

Reference listing

Information

ISEVEN

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISFORMULA

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISLOGICAL

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISNA

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISNONTEXT

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISNUMBER

Tests whether a value is numeric.

Open guide →

Math & trigonometry

ISO.CEILING

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Information

ISODD

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISOMITTED

Reference entry for a spreadsheet function in the Information category.

Reference listing

Date & time

ISOWEEKNUM

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Financial

ISPMT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Information

ISREF

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

ISTEXT

Tests whether a value is text.

Reference listing

Statistical

KURT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Logical

LAMBDA

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Statistical

LARGE

Returns the k-th largest value.

Reference listing

Math & trigonometry

LCM

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Text

LEFT

Returns characters from the start of text.

Open guide →

Text

LEN

Returns the number of characters in text.

Reference listing

Logical

LET

Assigns names to calculation results inside a formula.

Open guide →

Statistical

LINEST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

LN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

LOG

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

LOG10

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

LOGEST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

LOGNORM.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

LOGNORM.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Lookup & reference

LOOKUP

Looks up a value in a vector or array.

Reference listing

Text

LOWER

Converts text to lowercase.

Reference listing

Lookup & reference

MATCH

Returns the relative position of a value.

Open guide →

Statistical

MAX

Returns the largest value.

Reference listing

Statistical

MAXA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

MAXIFS

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

MDETERM

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Financial

MDURATION

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

MEDIAN

Returns the median.

Reference listing

Text

MID

Returns characters from the middle of text.

Open guide →

Statistical

MIN

Returns the smallest value.

Reference listing

Statistical

MINA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

MINIFS

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Date & time

MINUTE

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Math & trigonometry

MINVERSE

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Financial

MIRR

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Math & trigonometry

MMULT

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

MOD

Returns the remainder after division.

Reference listing

Statistical

MODE.MULT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

MODE.SNGL

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Date & time

MONTH

Returns the month from a date.

Reference listing

Math & trigonometry

MROUND

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

MULTINOMIAL

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

MUNIT

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Information

N

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

NA

Reference entry for a spreadsheet function in the Information category.

Reference listing

Statistical

NEGBINOM.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Date & time

NETWORKDAYS

Counts working days between dates.

Open guide →

Date & time

NETWORKDAYS.INTL

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Financial

NOMINAL

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

NORM.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

NORM.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

NORM.S.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

NORM.S.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Logical

NOT

Reverses a logical value.

Reference listing

Date & time

NOW

Returns the current date and time.

Reference listing

Financial

NPER

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

NPV

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Text

NUMBERVALUE

Reference entry for a spreadsheet function in the Text category.

Reference listing

Engineering

OCT2BIN

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

OCT2DEC

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Engineering

OCT2HEX

Reference entry for a spreadsheet function in the Engineering category.

Reference listing

Math & trigonometry

ODD

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Financial

ODDFPRICE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

ODDFYIELD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

ODDLPRICE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

ODDLYIELD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Lookup & reference

OFFSET

Returns a reference offset from a starting cell.

Reference listing

Logical

OR

Returns TRUE when any test is true.

Open guide →

Financial

PDURATION

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

PEARSON

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PERCENTILE.EXC

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PERCENTILE.INC

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PERCENTRANK.EXC

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PERCENTRANK.INC

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PERMUT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PERMUTATIONA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

PHI

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Text

PHONETIC

Reference entry for a spreadsheet function in the Text category.

Reference listing

Math & trigonometry

PI

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Financial

PMT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

POISSON.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

POWER

Raises a number to a power.

Reference listing

Financial

PPMT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

PRICE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

PRICEDISC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

PRICEMAT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

PROB

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

PRODUCT

Multiplies supplied numbers.

Reference listing

Text

PROPER

Capitalizes words.

Reference listing

Financial

PV

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

QUARTILE.EXC

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

QUARTILE.INC

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Math & trigonometry

QUOTIENT

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

RADIANS

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

RAND

Returns a random number between 0 and 1.

Reference listing

Math & trigonometry

RANDARRAY

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

RANDBETWEEN

Returns a random integer between two values.

Reference listing

Statistical

RANK.AVG

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

RANK.EQ

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Financial

RATE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

RECEIVED

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Logical

REDUCE

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Text

REPLACE

Replaces text by position.

Reference listing

Text

REPT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

RIGHT

Returns characters from the end of text.

Open guide →

Math & trigonometry

ROMAN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

ROUND

Rounds a number to a specified number of digits.

Open guide →

Math & trigonometry

ROUNDDOWN

Rounds toward zero.

Reference listing

Math & trigonometry

ROUNDUP

Rounds away from zero.

Reference listing

Lookup & reference

ROW

Returns a row number.

Reference listing

Lookup & reference

ROWS

Returns the number of rows in a reference.

Reference listing

Financial

RRI

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

RSQ

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Lookup & reference

RTD

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Logical

SCAN

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Text

SEARCH

Finds text without case sensitivity.

Reference listing

Math & trigonometry

SEC

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

SECH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Date & time

SECOND

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Math & trigonometry

SERIESSUM

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Information

SHEET

Reference entry for a spreadsheet function in the Information category.

Reference listing

Information

SHEETS

Reference entry for a spreadsheet function in the Information category.

Reference listing

Math & trigonometry

SIGN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

SIN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

SINH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

SKEW

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

SKEW.P

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Financial

SLN

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

SLOPE

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

SMALL

Returns the k-th smallest value.

Reference listing

Lookup & reference

SORT

Sorts a range or array.

Open guide →

Lookup & reference

SORTBY

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Math & trigonometry

SQRT

Returns a square root.

Reference listing

Math & trigonometry

SQRTPI

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Statistical

STANDARDIZE

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

STDEV.P

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

STDEV.S

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

STDEVA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

STDEVPA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

STEYX

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Text

SUBSTITUTE

Replaces matching text.

Reference listing

Math & trigonometry

SUBTOTAL

Calculates a subtotal while optionally ignoring hidden rows.

Open guide →

Math & trigonometry

SUM

Adds numbers or ranges.

Open guide →

Math & trigonometry

SUMIF

Adds values matching one condition.

Reference listing

Math & trigonometry

SUMIFS

Adds values matching multiple conditions.

Open guide →

Math & trigonometry

SUMPRODUCT

Multiplies corresponding values and returns their sum.

Reference listing

Math & trigonometry

SUMSQ

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

SUMX2MY2

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

SUMX2PY2

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

SUMXMY2

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Logical

SWITCH

Matches a value against a list of cases.

Reference listing

Financial

SYD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Text

T

Reference entry for a spreadsheet function in the Text category.

Reference listing

Statistical

T.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

T.DIST.2T

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

T.DIST.RT

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

T.INV

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

T.INV.2T

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

T.TEST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Lookup & reference

TAKE

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Math & trigonometry

TAN

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Math & trigonometry

TANH

Reference entry for a spreadsheet function in the Math & trigonometry category.

Reference listing

Financial

TBILLEQ

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

TBILLPRICE

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

TBILLYIELD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Text

TEXT

Formats a value as text.

Reference listing

Text

TEXTAFTER

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

TEXTBEFORE

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

TEXTJOIN

Joins text with a delimiter.

Open guide →

Text

TEXTSPLIT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Date & time

TIME

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Date & time

TIMEVALUE

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Lookup & reference

TOCOL

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Date & time

TODAY

Returns today’s date.

Open guide →

Lookup & reference

TOROW

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Lookup & reference

TRANSPOSE

Switches rows and columns.

Open guide →

Statistical

TREND

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Text

TRIM

Removes extra spaces from text.

Open guide →

Statistical

TRIMMEAN

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Logical

TRUE

Reference entry for a spreadsheet function in the Logical category.

Reference listing

Math & trigonometry

TRUNC

Truncates a number to a set number of digits.

Reference listing

Information

TYPE

Reference entry for a spreadsheet function in the Information category.

Reference listing

Text

UNICHAR

Reference entry for a spreadsheet function in the Text category.

Reference listing

Text

UNICODE

Reference entry for a spreadsheet function in the Text category.

Reference listing

Lookup & reference

UNIQUE

Returns unique values.

Open guide →

Text

UPPER

Converts text to uppercase.

Reference listing

Text

VALUE

Converts text representing a number into a number.

Reference listing

Text

VALUETOTEXT

Reference entry for a spreadsheet function in the Text category.

Reference listing

Statistical

VAR.P

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

VAR.S

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

VARA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Statistical

VARPA

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Financial

VDB

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Lookup & reference

VLOOKUP

Looks vertically in the first column of a table.

Open guide →

Lookup & reference

VSTACK

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Web

WEBSERVICE

Reference entry for a spreadsheet function in the Web category.

Reference listing

Date & time

WEEKDAY

Returns the weekday number.

Reference listing

Date & time

WEEKNUM

Returns the week number.

Reference listing

Statistical

WEIBULL.DIST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing

Date & time

WORKDAY

Returns a workday before or after a date.

Reference listing

Date & time

WORKDAY.INTL

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Lookup & reference

WRAPCOLS

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Lookup & reference

WRAPROWS

Reference entry for a spreadsheet function in the Lookup & reference category.

Reference listing

Financial

XIRR

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Lookup & reference

XLOOKUP

Looks up a value in a range and returns a corresponding result.

Open guide →

Lookup & reference

XMATCH

Modern match function with flexible search modes.

Reference listing

Financial

XNPV

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Logical

XOR

Returns TRUE when an odd number of tests are true.

Reference listing

Date & time

YEAR

Returns the year from a date.

Reference listing

Date & time

YEARFRAC

Reference entry for a spreadsheet function in the Date & time category.

Reference listing

Financial

YIELD

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

YIELDDISC

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Financial

YIELDMAT

Reference entry for a spreadsheet function in the Financial category.

Reference listing

Statistical

Z.TEST

Reference entry for a spreadsheet function in the Statistical category.

Reference listing