Excel Function List

Excel functions by category. Optional arguments in white. Click any function for a detailed description with formula examples. Also see 500 Formulas and 101 Functions.

Logical

AND

Test multiple conditions with AND

logical1logical2...

FALSE

Generate the logical value FALSE

Test for a specific condition

logical_testvalue_if_truevalue_if_false

IFERROR

Trap and handle errors

valuevalue_if_error

IFNA

Trap and handle #N/A errors

valuevalue_if_na

IFS

Test multiple conditions, return first true

test1value1test2, value2...

NOT

Reverse arguments or results

logical

Test multiple conditions with OR

logical1logical2...

SWITCH

Match multiple values, return first match

expressionval1/result1val2/result2...default

TRUE

Generate the logical value TRUE

XOR

Perform exclusive OR

logical1logical2...

Date and time

DATE

Create a date with year, month, and day

yearmonthday

DATEDIF

Get days, months, or years between two dates

start_dateend_dateunit

DATEVALUE

Convert a date in text format to a valid date

date_text

DAY

Get the day as a number (1-31) from a date

date

DAYS

Get days between dates

end_datestart_date

DAYS360

Get days between 2 dates in a 360-day year

start_dateend_datemethod

EDATE

Shift date n months in future or past

start_datemonths

EOMONTH

Get last day of month n months in future or past

start_datemonths

HOUR

Get the hour as a number (0-23) from a Time

serial_number

ISOWEEKNUM

Get ISO week number for a given date

date

MINUTE

Get minute as a number (0-59) from time

serial_number

MONTH

Get month as a number (1-12) from a date

date

NETWORKDAYS

Get the number of working days between two dates

start_dateend_dateholidays

NETWORKDAYS.INTL

Get work days between two dates

start_dateend_dateweekendholidays

NOW

Get the current date and time

SECOND

Get the Second as a number (0-59) from a Time

serial_number

TIME

Create a time with hours, minutes, and seconds

hourminutesecond

TIMEVALUE

Get a valid time from a text string

time_text

TODAY

Get the current date

WEEKDAY

Get the day of the week as a number

serial_numberreturn_type

WEEKNUM

Get the week number for a given date

serial_numreturn_type

WORKDAY

Get a date n working days in the future or past

start_datedaysholidays

WORKDAY.INTL

Get date n working days in future or past

start_datedaysweekendholidays

YEAR

Get the year from a date

date

YEARFRAC

Get the fraction of a year between two dates

start_dateend_datebasis

Lookup and reference

ADDRESS

Create a cell address from a given row and column

row_numcol_numabs_numa1sheet

AREAS

Get the number of areas in a reference.

reference

CHOOSE

Get a value from a list based on position

index_numvalue1value2...

COLUMN

Get the column number of a reference.

reference

COLUMNS

Get the number of columns in an array or reference.

array

FORMULATEXT

Get the formula in a cell

reference

GETPIVOTDATA

Retrieve data from a pivot table in a formula

data_fieldpivot_tablefield1, item1...

HLOOKUP

Look up a value in a table by matching on the first row

valuetablerow_indexrange_lookup

HYPERLINK

Create a clickable link.

link_locationfriendly_name

INDEX

Get a value in a list or table based on location

arrayrow_numcol_numarea_num

INDIRECT

Create a reference from text

ref_texta1

LOOKUP

Look up a value in a one-column range

lookup_valuelookup_vectorresult_vector

MATCH

Get the position of an item in an array

lookup_valuelookup_arraymatch_type

MMULT

Perform matrix multiplication

array1array2

OFFSET

Create a reference offset from given starting point

referencerowscolsheightwidth

ROW

Get the row number of a reference

reference

ROWS

Get the number of rows in an array or reference.

array

TRANSPOSE

Flip the orientation of a range of cells

array

VLOOKUP

Lookup a value in a table by matching on the first column

valuetablecol_indexrange_lookup

Text

CHAR

Get a character from a number

number

CLEAN

Strip non-printable characters from text

text

CODE

Get the code for a character

text

CONCAT

Join text values without delimiter

text1text2...

CONCATENATE

Join text together

text1text2text3...

DOLLAR

Convert a number to text in currency format

numberdecimals

EXACT

Compare two text strings

text1text2

FIND

Get the location of text in a string

find_textwithin_textstart_num

FIXED

Format number as text with fixed decimals

numberdecimalsno_commas

LEFT

Extract text from the left of a string

textnum_chars

LEN

Get the length of text.

text

LOWER

Convert text to lower case

text

MID

Extract text from inside a string

textstart_numnum_chars

NUMBERVALUE

Convert text to number with custom separators

textdecimal_separatorgroup_separator

PROPER

Capitalize the first letter in each word

text

REPLACE

Replace text based on location

old_textstart_numnum_charsnew_text

REPT

Repeat text as specified

textnumber_times

RIGHT

Extract text from the right of a string

textnum_chars

Get the location of text in a string

find_textwithin_textstart_num

SUBSTITUTE

Replace text based on content

textold_textnew_textinstance

TEXT

Convert a number to text in a number format

valueformat_text

TEXTJOIN

Join text values with a delimiter

delimiterignore_emptytext1text2...

TRIM

Remove extra spaces from text

text

UNICHAR

Get Unicode character by number

number

UNICODE

Get number from Unicode character

text

UPPER

Convert text to upper case

text

VALUE

Convert text to a number

text

Dynamic array

FILTER

Filters range with given criteria

arrayincludeif_empty

LET

Assign variables inside formula

name1value1name2/value2...calculation

RANDARRAY

Get array of random numbers

rowscolumnsminmaxinteger

SEQUENCE

Get array of list of seuential numbers

rowscolumnsstartstep

SINGLE

Get single value with implicit intersection

value

SORT

Sorts range or array

arraysort_indexsort_orderby_col

SORTBY

Sorts range or array by column

arrayby_arraysort_orderarray/order...

UNIQUE

Extract unique values from range

arrayby_colexactly_once

XLOOKUP

Find values in range or table

lookuplookup_arrayreturn_arraynot_foundmatch_modesearch_mode

XMATCH

Lookup values in range or table

lookup_valuelookup_arraymatch_modesearch_mode

Engineering

BIN2DEC

Converts a binary number to decimal

number

BIN2HEX

Converts a binary number to hexadecimal

numberplaces

BIN2OCT

Converts a binary number to octal

numberplaces

BITAND

Returns a 'Bitwise And' of two numbers

number1number2

BITLSHIFT

Returns a number shifted left by some number of bits

numbershift_amount

BITOR

Returns a 'Bitwise Or' of two numbers

number1number2

BITRSHIFT

Returns a number shifted right by some number of bits

numbershift_amount

BITXOR

Returns a 'Bitwise Xor' of two numbers

number1number2

COMPLEX

Convert coefficients to complex number

real_numi_numsuffix

CONVERT

Convert measurement units

numberfrom_unitto_unit

DEC2BIN

Converts a decimal number to binary

numberplaces

DEC2HEX

Converts a decimal number to hexadecimal

numberplaces

DEC2OCT

Converts a decimal number to octal

numberplaces

DELTA

Test two values are equal

number1number2

HEX2BIN

Converts a hexadecimal number to binary

numberplaces

HEX2DEC

Converts a hexadecimal number to decimal

number

HEX2OCT

Converts a hexadecimal number to octal

numberplaces

IMABS

Get absolute value of complex number

inumber

IMAGINARY

Get imaginary coefficient of complex number

inumber

IMPOWER

Raise complex number to given power

inumbernumber

IMPRODUCT

Get product of complex numbers

inumber1inumber2...

IMREAL

Get real coefficient of complex number

inumber

IMSUB

Get difference between two complex numbers

inumber1inumber2

IMSUM

Get sum of complex numbers

inumber1inumber2...

Financial

ACCRINT

Get accrued interest periodic

idfdsdrateparfreqbasiscalc

ACCRINTM

Get accrued interest at maturity

idsdrateparbasis

AMORDEGRC

Depreciation for accounting period coefficient

costpurchasefirstsalvageperiodratebasis

AMORLINC

Depreciation for accounting period

costpurchasefirstsalvageperiodratebasis

COUPDAYBS

Get days from coupon period to settlement date