This is the list of the most popular functions in Excel. Click one to learn more.

## Logical functions

Returns value_if_error if an expression is an error and the value of the expression itself otherwise.

value

value_if_error

## Text functions

Returns position of one text string within another text string.

find_text

within_text

start_num

Replaces one string with the second string, based on location.

old_text

start_num

num_chars

new_text

## Date and time functions

Returns the number of days between two dates based on a 360-day year.

start_date

end_date

method

Returns the serial number of the last day of the month in future or past months.

start_date

months

Returns the number of whole workdays between two dates with custom weekend parameters.

start_date

end_date

weekend

holidays

Returns the current date and time.

Returns the current date.

Returns the serial number of the date before or after a specified number of workdays.

start_date

days

holidays

Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.

start_date

days

weekend

holidays

## Lookup and Reference functions

Creates a cell reference as text, given specified row and column numbers.

row_num

col_num

abs_num

a1

sheet

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

lookup_value

table_array

row_index_num

range_lookup

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

lookup_value

table_array

col_index_num

range_lookup

## Math and Trig functions

Returns the value of PI.

Returns a random number between 0 and 1.

Sums cells that match multiple criteria.

sum_range

criteria_range1

criteria1

criteria_range2

criteria2

…

## Statistical functions

Return the average (arithmetic mean) of its arguments specified by given criteria.

range

criteria

average_range

Returns the average (arithmetic mean) of its arguments specified by a given set of criteria.

sum_range

criteria_range1

criteria1

criteria_range2

criteria2

…

Counts cells that match multiple criteria.

criteria_range1

criteria1

criteria_range2

criteria2

…

Returns the median, or the number in the middle of the set of given numbers.

number1

number2

…

Calculates standard deviation based on the entire population given as arguments.

number1

number2

…

Calculates standard deviation based on the entire population given as arguments.

number1

number2

…

## Engineering functions

## Information functions

## Financial Functions

Returns the number of periods for an investment based on periodic, constant payments and constant interest rate.

rate

pmt

pv

fv

type

Calculates the payment for a loan based on constant payments and a constant interest rate.

rate

pmt

pv

fv

type

Returns the present value of an investment: the total amount that a series of future payments is worth now.

rate

nper

pmt

fv

type