Excel functions

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


Logical functions

Checks whether all arguments are TRUE.
logical1
logical2
...
Function returns true if the condition is met.
logical_test
value_if_true
value_if_false
Returns value_if_error if an expression is an error and the value of the expression itself otherwise.
value
value_if_error
Change FALSE to TRUE and TRUE to FALSE.
logical
Checks whether any of the arguments are TRUE.
logical1
logical2
...

Text functions

Returns the character specified by the number code.
number
Removes non-printable characters from cell.
text
Returns the code for a character.
text
Joins multiple strings into one string.
text1
text2
...
Converts a number to text, using currency format.
number
decimals
Checks whether two text strings are exactly the same.
text1
text2
Returns position of one text string within another text string.
find_text
within_text
start_num
Returns the number of characters from the left side of a string.
text
start_num
Returns the length of a string.
text
Changes text to lowercase.
text
Returns a character from the middle of a text string.
text
start_num
num_chars
Changes the first letter to uppercase, other to lowercase.
text
Replaces one string with second string, based on location.
old_text
start_num
num_chars
new_text
Repeats text as specified.
text
number_times
Returns the number of characters from the right side of a string.
text
start_num
Gets a the location of string inside text.
find_text
within_text
start_num
Changes a part of a string with another string.
text
old_text
new_text
instance_num
Converts a value to text in a specified format.
value
format_text
Removes all spaces except for single spaces between words.
text
Changes all letters in a string to uppercase.
text
Converts text that represents a number to a number.
text

Date and time functions

Creates date from year, month, day.
year
month
date
Get days, months, or years between two dates.
start_date
end_date
unit
Converts a date in text format to a valid date.
date_text
Returns the day of the month (1-31).
serial_number
Counts the number of days between to dates.
end_date
start_date
Returns the number of days between two dates based on a 360-day year.
start_date
end_date
method
Returns the same date in future or past months.
start_date
months
Returns the serial number of the last day of the month in future or past months.
start_date
months
Returns an hour as a number (0-23).
serial_number
Returns a minute as a number (0-59).
serial_number
Returns the month number.
text
Returns the number of whole workdays between two dates.
start_date
end_date
holidays
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 a second as a number (0-59).
serial_number
Creates a time from hour, minute, second.
hour
minute
second
Converts text time to an Excel serial number for a time.
time_text
Returns the current date.
Returns a number identifying the day of the week.
serial_number
return_type
Returns the week number in the year.
serial_number
return_type
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
Returns the year from a date.
serial_number
Returns the year fraction.
start_date
end_date
basis

Lookup and Reference functions

Creates a cell reference as text, given specified row and column numbers.
row_num
col_num
abs_num
a1
sheet
Returns the number of areas in a reference.
reference
Returns a value from a list based on a position.
index_num
value1
value2
...
Returns a specified column number.
reference
Returns a specified column number.
array
Look up a value in a table by matching on the first row.
lookup_value
table_array
row_index_num
range_lookup
Create a clickable link.
link_location
friendly_name
Gets a value in a list or table based on location.
array
row_num
column_num
Gets a value in a list or table based on location.
reference
row_num
column_num
area_num
Returns the reference specified by a text string.
ref_text
a1
Gets the position of an item in an array.
lookup_value
lookup_array
match_type
Look up a value in a one-column range.
lookup_value
lookup_vector
result_vector
Create a reference offset from given starting point.
reference
rows
cols
height
width
Returns a specified row number.
reference
Returns a specified row number.
array
Converts data in rows to columns and vice versa.
array
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 absolute value of a number.
number
Rounds a number up, to the nearest multiple of significance.
number
significance
Returns the cosine of an angle.
number
Convert radians to degrees.
angle
Rounds a positive number up and negative number down to the nearest even integer.
number
Returns e raised to the power of a given number.
angle
Returns the factorial of a number.
number
Rounds a number down, to the nearest multiple of significance.
number
significance
Returns the greatest common divisor.
number1
number2
...
Rounds a number down to the nearest integer.
number
Get the least common multiple.
number1
number2
...
Returns the logarithm of a number to the base you specify.
number
base
Returns the base-10 logarithm of a number.
number
Returns a number rounded to the desired multiple.
number
multiple
Returns a remainder after a number is divided by a divisor.
number
divisor
Rounds a positive number up and negative number down to the nearest odd integer.
number
Returns the value of PI.
Convert to degrees to radians.
angle
Returns a random number between 0 and 1.
Returns a random number between two specified values.
bottom
top
Rounds a number to a given number of digits.
number
num_digits
Rounds a number down to a given number of digits.
number
num_digits
Rounds a number up to a given number of digits.
number
num_digits
Returns the sign of a number.
number
Returns the sine of an angle.
number
Returns the square root of a number.
number
Gets a subtotal in a list or database.
find_text
within_text
start_num
Sums all number in a range.
number1
number2
...
Adds cells specified by a given condition or criteria.
range
criteria
sum_range
Sums cells that match multiple criteria.
sum_range
criteria_range1
criteria1
criteria_range2
criteria2
...
Returns the sum of the products.
array1
array2
...
Returns the tangent of an angle.
number
Truncates a number to a given precision.
number
num_digits

Statistical functions

Returns the average (arithmetic mean) of its arguments.
number1
number2
...
Returns the average (arithmetic mean) of its arguments.
value1
value2
...
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 the number of cells in a range that contain numbers.
value1
value2
...
Counts non-empty cells in a range.
value1
value2
...
Counts empty cells.
range
Counts the number of cells within a range that meet the given criteria.
range
criteria
Counts cells that match multiple criteria.
criteria_range1
criteria1
criteria_range2
criteria2
...
Returns the k-th largest value
array
n
Gets the frequency of values in a data set.
data_array
bins_array
Returns the largest value in a set of values.
number1
number2
...
Returns the median, or the number in the middle of the set of given numbers.
number1
number2
...
Returns the smallest value in a set of values.
number1
number2
...
Returns the most frequently occurring value.
number1
number2
...
Returns the normal distribution for the specified mean and standard deviation.
range
Returns the Poisson distribution.
range
Ranks a number against a range of numbers.
number
ref
order
Returns the nth smallest value.
array
n
Estimates standard deviation based on a sample.
number1
number2
...
Calculates standard deviation based on the entire population given as arguments.
number1
number2
...
Estimates standard deviation based on a sample.
number1
number2
...
Calculates standard deviation based on the entire population given as arguments.
number1
number2
...

Engineering functions

Converts measurement units.
number
from_unit
to_unit

Information functions

Returns information about cell.
text
start_num
Returns the number of error.
error_val
Checks whether the cell is blank.
value
Returns true if a value is an error (excluding #N/A).
value
Returns true if a value is an error.
value
Returns TRUE if the number is even.
value
Returns TRUE if the value is logical.
value
Checks whether a value is #N/A.
value
Checks whether a value is not text.
value
Checks whether a value is a number.
value
Returns TRUE if the number is odd.
value
Checks whether a value is a reference.
value
Checks whether a value is a text string.
value
Converts a value to a number.
value
Returns the error value #N/A.
value

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
Returns the interest rate per period of a loan or an investment.
nper
pmt
pv
fv
type
guess