Look up any Excel function — syntax, a real example, and when to use it.
Returns TRUE only if every condition given is true.
Calculates the arithmetic mean of a range of numbers.
Averages the numbers in a range that meet a single condition.
Averages numbers that meet multiple conditions across one or more ranges.
Returns a value from a list based on a position number you provide.
Joins two or more pieces of text into one.
Counts how many cells in a range contain a number, ignoring text and blank cells.
Counts how many cells in a range contain anything at all — numbers, text, or dates — skipping only truly empty cells.
Counts how many cells in a range are empty.
Counts the number of cells in a range that meet a single condition.
Counts cells that meet multiple conditions across one or more ranges, all at once.
Returns only the rows of a range that meet a condition, automatically spilling the matching rows into neighboring cells.
Returns the position where one piece of text starts inside another, and is case-sensitive.
Returns one value if a condition is true, and another if it's false.
Returns a fallback value if a formula results in an error, otherwise returns the formula's normal result.
Returns a fallback value only if a formula results in the #N/A error specifically, otherwise returns the formula's normal result (including other error types).
Checks multiple conditions in order and returns the result for the first one that's true — a flatter alternative to nested IF statements.
Returns the value at a given row and column position within a range.
Returns TRUE if a cell is completely empty, and FALSE otherwise.
Returns TRUE if a value is any kind of error (#N/A, #VALUE!, #REF!, and others), and FALSE otherwise.
Returns TRUE only if a value is specifically the #N/A error, and FALSE for anything else, including other error types.
Returns TRUE if a value is a number, and FALSE otherwise.
Returns TRUE if a value is text, and FALSE otherwise.
Returns a specified number of characters from the start (left side) of a text string.
Returns the number of characters in a text string, including spaces.
Assigns names to intermediate calculations inside a single formula, so a repeated sub-calculation is written once and referenced by name.
Converts all letters in a text string to lowercase.
Returns the position of a value within a range, rather than the value itself.
Returns the largest value in a set of numbers.
Returns the largest value in a range, but only among rows that meet one or more conditions.
Returns the middle value in a set of numbers — half the values are above it, half below.
Returns a specific number of characters from the middle of a text string, starting at a position you choose.
Returns the smallest value in a set of numbers.
Returns the smallest value in a range, but only among rows that meet one or more conditions.
Reverses a TRUE/FALSE value — turns TRUE into FALSE, and FALSE into TRUE.
Returns the current date and time, and updates automatically whenever the sheet recalculates.
Returns TRUE if at least one of the conditions given is true.
Capitalizes the first letter of each word in a text string, converting the rest to lowercase.
Replaces a specific number of characters within a string, matched by position rather than by the text itself.
Returns a specified number of characters from the end (right side) of a text string.
Rounds a number to a specified number of digits.
Rounds a number down, toward zero, to a specified number of digits.
Rounds a number up, away from zero, to a specified number of digits.
Returns the position where one piece of text starts inside another, and is not case-sensitive.
Generates a list of sequential numbers, spilling automatically into a range of the size you specify.
Returns a range sorted by a column you specify, automatically spilling the sorted results into neighboring cells.
Sorts a range based on the values in a different range, rather than a column within the range itself.
Replaces occurrences of specific text within a string, matched by the text itself rather than its position.
Adds all the numbers in a range of cells.
Adds the numbers in a range that meet a single condition.
Adds numbers that meet multiple conditions across one or more ranges.
Multiplies corresponding elements across one or more ranges, then adds up the results.
Compares one expression against a list of values and returns the result matching the first one found, with an optional default if nothing matches.
Converts a number into text, displayed in a specific format you choose.
Joins multiple pieces of text together with a delimiter between each, optionally skipping empty cells.
Returns the current date, and updates automatically every day the file is opened.
Removes extra spaces from text, leaving only single spaces between words.
Returns each distinct value from a range exactly once, automatically spilling the results into neighboring cells.
Converts all letters in a text string to uppercase.
Converts text that looks like a number into an actual number Excel can calculate with.
Looks for a value in the first column of a range and returns a value from a column you specify in the same row.
Searches a range for a value and returns a corresponding value from another range — the modern replacement for VLOOKUP.