ⓘ
Test multiple conditions and return TRUE only if all conditions are met, otherwise it returns FALSE. Learn more
ⓘ
Count the number of cells in a range that contain numeric values. Learn more
ⓘ
Count the number of cells in a range that meet a given condition. Learn more
ⓘ
Count the number of cells in a range that meet multiple conditions. Learn more
ⓘ
Perform a conditional test on a specific value or expression. Learn more
ⓘ
Handle errors in a formula by providing a specific value or an alternative result. Learn more
ⓘ
Handle #N/A errors by providing a specific value or an alternative result. Learn more
ⓘ
Evaluate multiple conditions and return a value corresponding to the first condition that is true. Learn more
ⓘ
Evaluate multiple conditions and return a value corresponding to the first condition that is true. Learn more
ⓘ
Test multiple conditions and return TRUE if at least one of the conditions are met, otherwise it returns FALSE. Learn more
Text Functions:
ⓘ
Convert ASCII codes to their corresponding characters. Learn more
ⓘ
Remove non-printable characters from a text string. Learn more
ⓘ
Return the ASCII code of the first character in a text string. Learn more
ⓘ
Combine multiple text strings or multiple ranges into a single string. Learn more
ⓘ
Combine multiple text strings into a single string. Learn more
ⓘ
Compare if two text strings are exactly the same. Learn more
ⓘ
Determine the position of the first occurrence of a specific character or substring within a text string. Learn more
ⓘ
Extract a specified number of characters from the beginning (left side) of a text string. Learn more
ⓘ
Determine the number of characters in a text string. Learn more
ⓘ
Convert all characters in a text string to lowercase. Learn more
ⓘ
Extract a specific number of characters from a text string, starting at a specified position. Learn more
ⓘ
Capitalize the first letter of each word in a text string. Learn more
ⓘ
Extract a specified number of characters from the end (right side) of a text string. Learn more
ⓘ
Find the position of a specific character or substring within a text string, returning the starting position of the first occurrence, case-insensitive. Learn more
ⓘ
Replace occurrences of a specified substring with another text in a given text string. Learn more
ⓘ
Convert a value to text using a specified format. Learn more
ⓘ
Remove leading and trailing spaces, as well as extra spaces between words, from a text string. Learn more
ⓘ
Convert all characters in a text string to uppercase. Learn more
Financial Functions:
ⓘ
Calculate the future value of an investment based on periodic, constant payments with a fixed interest rate over a specific period. Learn more
ⓘ
Calculates the discount rate at which the net present value of cash flows becomes zero, representing the investment's rate of return. Learn more
ⓘ
Calculate the net present value by discounting a series of cash flows at a specified rate over a given period. Learn more
ⓘ
Calculate periodic payments for a loan or investment with fixed interest, periods, and present or future value. Learn more
ⓘ
Calculate the present value of future cash flows, representing the current worth of an investment or loan at a specified interest rate. Learn more
ⓘ
Calculate the interest rate for an investment or loan using total payment periods, periodic payment, present value, and future value. Learn more
Information Functions:
ⓘ
Retrieve information about a cell, such as its formatting, contents, or location. Learn more
ⓘ
Identify the type of error in a specified cell, categorizing errors such as #VALUE!, #REF!, #DIV/0!, and others. Learn more
ⓘ
Retrieve information about the current environment or workbook. Learn more
ⓘ
Check if a specified cell is blank or empty. Learn more
ⓘ
Check if a specified cell contains any error value, excluding the #N/A error. Learn more
ⓘ
Check if a specified cell contains any error value, including the #N/A error. Learn more
ⓘ
Check if a specified value is the error value #REF!. Learn more
ⓘ
Check if a specified value is a text string. Learn more
ⓘ
Convert various representations to numbers, interpreting TRUE as 1, FALSE as 0, and converting text to numeric values. Learn more
ⓘ
Check what type of data is returned by a function or formula. Learn more
Lookup and Reference Functions:
ⓘ
Search for a value in the first row of a table and return a corresponding value from a specified row, enabling horizontal lookup. Learn more
ⓘ
Return the value of a cell in a specified row and column of a range. Learn more
ⓘ
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. Learn more
ⓘ
Return a reference to a range that is a specified number of rows and columns away from a starting reference. Learn more
ⓘ
Search for a value in the first column of a table and retrieves a corresponding value from a specified column, allowing vertical lookup. Learn more
Math Functions:
ⓘ
Return the absolute value of a number. Learn more
ⓘ
Calculate the arithmetic mean of a range of numbers. Learn more
ⓘ
Calculate the average of a range of numbers based on a specified condition. Learn more
ⓘ
Calculate the average of a range of numbers based on multiple conditions. Learn more
ⓘ
Round a number down to the nearest integer. Learn more
ⓘ
Find the highest numerical value in a range or a set of values. Learn more
ⓘ
Find the middle number in a dataset when sorted in ascending or descending order. Learn more
ⓘ
Find the smallest numerical value in a range or a set of values. Learn more
ⓘ
Find the number that occurs the most in a dataset. Learn more
ⓘ
Generate a random decimal number between 0 and 1. Learn more
ⓘ
Round a number to a specified number of digits. Learn more
ⓘ
Calculate the square root of a given number. Learn more
ⓘ
Add up a range of numbers or individual values. Learn more
ⓘ
Add up range of numbers based on a specified condition. Learn more
ⓘ
Add up range of numbers based on multiple conditions. Learn more
Date and Time Functions:
ⓘ
Create a date by specifying the year, month, and day as separate arguments. Learn more
ⓘ
Extract the day of the month from a given date. Learn more
ⓘ
Extract the hour component from a given time. Learn more
ⓘ
Extract the minute component from a given time. Learn more
ⓘ
Extract the month component from a given date. Learn more
ⓘ
Insert the current date and time into a cell. Learn more
ⓘ
Extract the second component from a given time. Learn more
ⓘ
Create a time value by specifying the hour, minute, and second as separate arguments. Learn more
