This is the list of the most popular functions in Excel. Click one to learn more.
Logical functions
Checks whether all arguments are TRUE.
The 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.
Change FALSE to TRUE and TRUE to FALSE.
Checks whether any of the arguments are TRUE.
Text functions
Returns the character specified by the number code.
Removes non-printable characters from a cell.
Returns the code for a character.
Joins multiple strings into one string.
Checks whether two text strings are exactly the same.
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.
Returns the length of a string.
Changes text to lowercase.
Returns a character from the middle of a text string.
Changes the first letter to uppercase, other to lowercase.
Replaces one string with the second string, based on location.
old_text
start_num
num_chars
new_text
Repeats text as specified.
Returns the number of characters from the right side of a string.
Gets a 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.
Removes all spaces except for single spaces between words.
Changes all letters in a string to uppercase.
Converts text that represents a number to a number.
Date and time functions
Creates date from year, month, day.
Get days, months, or years between two dates.
Converts a date in text format to a valid date.
Returns the day of the month (1-31).
start_date
end_date
method
Returns the same date in the future or past months.
Returns the serial number of the last day of the month in future or past months.
Returns an hour as a number (0-23).
Returns a minute as a number (0-59).
Returns the month number.
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).
Creates a time from an hour, minute, second.
Converts text time to an Excel serial number for a time.
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.
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.
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.
Returns a value from a list based on a position.
index_num
value1
value2
…
Returns a specified column number.
Returns a specified column number.
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.
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.
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.
Returns a specified row number.
Converts data in rows to columns and vice versa.
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
Rounds a number up, to the nearest multiple of significance.
Returns the cosine of an angle.
Convert radians to degrees.
Rounds a positive number up and negative number down to the nearest even integer.
Returns e raised to the power of a given number.
Returns the factorial of a number.
Rounds a number down, to the nearest multiple of significance.
Returns the greatest common divisor.
Get the least common multiple.
Returns the logarithm of a number to the base you specify.
Returns the base-10 logarithm of a number.
Returns a number rounded to the desired multiple.
Returns a remainder after a number is divided by a divisor.
Rounds a positive number up and negative number down to the nearest odd integer.
Convert to degrees to radians.
Rounds a number to a given number of digits.
Rounds a number down to a given number of digits.
Rounds a number up to a given number of digits.
Returns the sign of a number.
Returns the sine of an angle.
Returns the square root of a number.
Gets a subtotal in a list or database.
find_text
within_text
start_num
Sums all number in a range.
Adds cells specified by a given condition or criteria.
Sums cells that match multiple criteria.
sum_range
criteria_range1
criteria1
criteria_range2
criteria2
…
Returns the sum of the products.
Returns the tangent of an angle.
Truncates a number to a given precision.
Statistical functions
Returns the average (arithmetic mean) of its arguments.
Returns the average (arithmetic mean) of its arguments.
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 the number of cells in a range that contain numbers.
Counts non-empty cells in a range.
Counts the number of cells within a range that meet the given criteria.
Counts cells that match multiple criteria.
criteria_range1
criteria1
criteria_range2
criteria2
…
Returns the k-th largest value
Gets the frequency of values in a dataset.
Returns the largest value in a set of values.
Returns the median, or the number in the middle of the set of given numbers.
Returns the smallest value in a set of values.
Returns the most frequently occurring value.
Ranks a number against a range of numbers.
Returns the nth smallest value.
Estimates standard deviation based on a sample.
Estimates standard deviation based on a sample.
Calculates standard deviation based on the entire population given as arguments.
Engineering functions
Converts measurement units.
Information functions
Returns information about the cell.
Returns the number of an error.
Checks whether the cell is blank.
Returns true if a value is an error (excluding #N/A).
Returns true if a value is an error.
Returns TRUE if the number is even.
Returns TRUE if the value is logical.
Checks whether a value is #N/A.
Checks whether a value is not text.
Checks whether a value is a number.
Returns TRUE if the number is odd.
Checks whether a value is a reference.
Checks whether a value is a text string.
Converts a value to a number.
Returns the error value #N/A.
Financial Functions
Returns the number of periods for an investment based on periodic, constant payments and constant interest rate.
Calculates the payment for a loan based on constant payments and a constant interest rate.
Returns the present value of an investment: the total amount that a series of future payments is worth now.
Returns the interest rate per period of a loan or an investment.
nper
pmt
pv
fv
type
guess
Post Views: 2,846
