# Excel functions

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

## 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 a 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

...

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 that a series of future payments is worth now.

rate

nper

pmt

fv

type