Excel Functions
Check out our collection of Excel Functions below. For more information on any of the functions, just click on the function name!
Categories
Logical Functions
Function
Objective
Preview
AND 🔗
Test multiple conditions and return TRUE only if all conditions are met, otherwise it returns FALSE
=AND(condition1, [condition2], ...)
=IF(logical_test, value_if_true, value_if_false)
IFERROR 🔗
Handle errors in a formula by providing a specific value or an alternative result
=IFERROR(value, value_if_error)
IFNA 🔗
Handle #N/A errors by providing a specific value or an alternative result
=IFNA(value, value_if_na)
IFS 🔗
Evaluate multiple conditions and return a value corresponding to the first condition that is true
=IFS(condition1, value_if_true1, [condition2, value_if_true2], ...)
=NOT(logical_test)
=OR(condition1, [condition2], ...)
Text Functions
Function
Objective
Preview
=CHAR(number)
=CLEAN(text)
CODE 🔗
Return the ASCII code of the first character in a text string
=CODE(text)
=CONCAT(text1, [text2], …)
Combine multiple text strings into a single string
=CONCATENATE(text1, [text2], …)
=EXACT(text1, text2)
=FIND(find_text, within_text, [start_num])
=LEFT(text, num_chars)
LEN 🔗
Determine the number of characters in a text string
=LEN(text)
LOWER 🔗
Convert all characters in a text string to lowercase
=LOWER(text)
=MID(text,, start_num, num_chars))
=PROPER(text)
=RIGHT(text, num_chars)
SEARCH 🔗
Find the position of a specific character or substring within a text string, returning the starting position of the first occurrence, case-insensitive
=SEARCH(find_text, within_text, [start_num])
Replace occurrences of a specified substring with another text in a given text string
=SUBSTITUTE(text, old_text, new_text, [instance_num])
TEXT 🔗
Convert a value to text using a specified format
=TEXT(value, format_text)
=TEXT(text)
=UPPER(text)
Financial Functions
Function
Objective
Preview
FV 🔗
Calculate the future value of an investment based on periodic, constant payments with a fixed interest rate over a specific period
=FV(rate, nper, pmt, [pv], [type])
IRR 🔗
Calculates the discount rate at which the net present value of cash flows becomes zero, representing the investment's rate of return
=IRR(values, [guess])
NPV 🔗
Calculate the net present value by discounting a series of cash flows at a specified rate over a given period
=NPV(rate, value1, [value2], ...)
PMT 🔗
Calculate periodic payments for a loan or investment with fixed interest, periods, and present or future value
=PMT(rate, nper, pv, [fv], [type])
PV 🔗
Calculate the present value of future cash flows, representing the current worth of an investment or loan at a specified interest rate
=PV(rate, nper, pmt, [fv], [type])
RATE 🔗
Calculate the interest rate for an investment or loan using total payment periods, periodic payment, present value, and future value
Count the number of cells in a range that contain numeric values
COUNT 🔗
=COUNT(value1, [value2], ...)
Count the number of cells in a range that meet a given condition
COUNTIF 🔗
=COUNTIF(range, criteria)
COUNTIFS 🔗
Count the number of cells in a range that meet multiple conditions
=COUNTIFS(range1, criteria1, [range2, criteria2], ...)
=RATE(nper, pmt, pv, [fv], [type], [guess])
Information Functions
Function
Objective
Preview
=CELL(info_type, [reference])
Identify the type of error in a specified cell, categorizing errors such as #VALUE!, #REF!, #DIV/0!, and others
=ERROR.TYPE(error_val)
INFO 🔗
Retrieve information about the current environment or workbook
=INFO(type_text)
ISBLANK 🔗
Check if a specified cell is blank or empty
Perform a conditional test on a specific value or expression
IF 🔗
Return the opposite of a logical value
NOT 🔗
Test multiple conditions and return TRUE if at least one of the conditions are met, otherwise it returns FALSE
OR 🔗
Convert ASCII codes to their corresponding characters
CHAR 🔗
Remove non-printable characters from a text string
CLEAN 🔗
Combine multiple text strings or multiple ranges into a single string
CONCAT 🔗
Compare if two text strings are exactly the same
EXACT 🔗
Determine the position of the first occurrence of a specific character or substring within a text string
FIND 🔗
Extract a specified number of characters from the beginning (left side) of a text string
LEFT 🔗
Extract a specific number of characters from a text string, starting at a specified position
MID 🔗
Capitalize the first letter of each word in a text string
PROPER 🔗
Extract a specified number of characters from the end (right side) of a text string
RIGHT 🔗
Remove leading and trailing spaces, as well as extra spaces between words, from a text string
TRIM 🔗
Convert all characters in a text string to uppercase
UPPER 🔗
Retrieve information about a cell, such as its formatting, contents, or location
CELL 🔗
=ISBLANK(value)
Check if a specified cell contains any error value, excluding the #N/A error
ISERR 🔗
=ISERR(value)
Check if a specified cell contains any error value, including the #N/A error
ISERROR 🔗
=ISERROR(value)
Check if a specified number is even
ISEVEN 🔗
=ISEVEN(number)
Check if a specified value is a logical value (TRUE or FALSE)
=ISLOGICAL(value)
Check if a specified value is the error value #N/A
ISNA 🔗
=ISNA(value)
Check if a specified value is a text string
=ISNONTEXT(value)
Check if a specified value is a numeric value
ISNUMBER 🔗
=ISNUMBER(value)
Check if a specified number is odd
ISODD 🔗
=ISODD(number)
Check if a specified value is the error value #REF!
ISREF 🔗
=ISREF(value)
Check if a specified value is a text string
ISTEXT 🔗
=ISTEXT(value)
N 🔗
Convert various representations to numbers, interpreting TRUE as 1, FALSE as 0, and converting text to numeric values
=N(value)
Check what type of data is returned by a function or formula
TYPE 🔗
=TYPE(value)
Lookup and Reference Functions
Function
Objective
Preview
HLOOKUP 🔗
Search for a value in the first row of a table and return a corresponding value from a specified row, enabling horizontal lookup
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
INDEX 🔗
Return the value of a cell in a specified row and column of a range
=INDEX(array, row_num, [column_num])
MATCH 🔗
Search for a specified value in a range and return the relative position (index) of that item, facilitating the location of data within a given range
=MATCH(lookup_value, lookup_array, [match_type])
OFFSET 🔗
Return a reference to a range that is a specified number of rows and columns away from a starting reference
=OFFSET(reference, rows, cols, [height], [width])
VLOOKUP 🔗
Search for a value in the first column of a table and retrieves a corresponding value from a specified column, allowing vertical lookup
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Math Functions
Function
Objective
Preview
Return the absolute value of a number
ABS 🔗
=ABS(number)
Calculate the arithmetic mean of a range of numbers
AVERAGE 🔗
=AVERAGE(number1, [number2], ...)
Calculate the average of a range of numbers based on a specified condition
=AVERAGEIF(range, criteria, [average_range])
Calculate the average of a range of numbers based on multiple conditions
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Round a number down to the nearest integer
INT 🔗
=INT(number)
Find the highest numerical value in a range or a set of values
MAX 🔗
=MAX(number1, [number2], ...)
Find the middle number in a dataset when sorted in ascending or descending order
MEDIAN 🔗
=MEDIAN(number1, [number2], ...)
Find the smallest numerical value in a range or a set of values
MIN 🔗
=MIN(number1, [number2], ...)
Find the number that occurs the most in a dataset
MODE 🔗
=MODE(number1, [number2], ...)
Generate a random decimal number between 0 and 1
RAND 🔗
=RAND()
Round a number to a specified number of digits
ROUND 🔗
=ROUND(number, num_digits)
Calculate the square root of a given number
SQRT 🔗
=SQRT(number)
Add up a range of numbers or individual values
SUM 🔗
=SUM(number1, [number2], ...)
Add up range of numbers based on a specified condition
SUMIF 🔗
=SUMIF(range, criteria, [sum_range])
SUMIFS 🔗
Add up range of numbers based on multiple conditions
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Date and Time Functions
Function
Objective
Preview
Create a date by specifying the year, month, and day as separate arguments
DATE 🔗
=DATE(year, month, day)
Extract the day of the month from a given date
DAY 🔗
=DAY(serial_number)
Extract the hour component from a given time
HOUR 🔗
=HOUR(serial_number)
Extract the minute component from a given time
MINUTE 🔗
=MINUTE(serial_number)
Extract the month component from a given date
MONTH 🔗
=MONTH(serial_number)
Insert the current date and time into a cell
NOW 🔗
=NOW()
Extract the second component from a given time
SECOND 🔗
=SECOND(serial_number)
Create a time value by specifying the hour, minute, and second as separate arguments
TIME 🔗
=TIME(hour, minute, second)
Insert the current date into a cell
TODAY 🔗
=TODAY()
Extract the year component from a given date
YEAR 🔗
=YEAR(serial_number)