Searchable reference for 100+ Excel and Google Sheets formulas with syntax, examples, and tips.
Searches for a value in the first column of a range and returns a value in the same row from a specified column.
Searches for a value in the top row of a range and returns a value in the same column from a specified row.
Returns the value of an element in a table or array, selected by the row and column number indexes.
Returns the relative position of an item in an array that matches a specified value.
Modern replacement for VLOOKUP/HLOOKUP. Searches a range or array, and returns the first match. Can look in any direction.
Adds all the numbers in a range of cells.
Sums cells that meet a single condition.
Rounds a number to a specified number of digits.
Always rounds a number up, away from zero.
Always rounds a number down, toward zero.
Returns the remainder after a number is divided by a divisor.
Returns the absolute (positive) value of a number.
Returns the result of a number raised to a power.
Returns the positive square root of a number.
Returns the average (arithmetic mean) of its arguments.
Returns the average of all cells that meet a given criteria.
Returns the smallest value in a set of values.
Returns the largest value in a set of values.
Counts how many numbers are in the list of arguments. Only numeric values are counted.
Counts the number of cells that are not empty in a range.
Counts the number of cells within a range that meet the given condition.
Returns one value if a condition is true and another value if it is false.
Checks whether one or more conditions are met and returns the value corresponding to the first true condition.
Returns TRUE if all its arguments are TRUE; returns FALSE if any argument is FALSE.
Returns TRUE if any argument is TRUE; returns FALSE when all arguments are FALSE.
Reverses the logic of its argument. Returns TRUE when given FALSE, and FALSE when given TRUE.
Returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula.
Returns the number of characters in a text string.
Returns the leftmost characters from a text value.
Returns the rightmost characters from a text value.
Returns a specific number of characters from a text string, starting at the position you specify.
Removes all spaces from text except for single spaces between words.
Converts text to uppercase.
Converts all uppercase letters in a text string to lowercase.
Substitutes new_text for old_text in a text string.
Joins several text items into one text item.
Joins text from multiple ranges using a delimiter, with option to ignore empty cells.
Converts a value to text in a specific number format.
Converts a text string that represents a number to a number.
Returns the serial number of the current date. Updates every time the worksheet is recalculated.
Returns the serial number of the current date and time.
Returns the sequential serial number that represents a particular date.
Calculates the number of days, months, or years between two dates.
Returns the number of whole working days between start_date and end_date, excluding weekends and holidays.
Returns the year corresponding to a date.
Returns the month (1–12) corresponding to a date.
Returns the day of the month (1–31) corresponding to a date.
Calculates the payment for a loan based on constant payments and a constant interest rate.
Returns the future value of an investment based on periodic, 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 net present value of an investment based on a series of periodic cash flows and a discount rate.
Returns a list of unique values in a list or range.
Filters a range of data based on criteria you define.
Sorts the contents of a range or array.
Transposes the rows and columns of an array.
