The free Excel function reference
Syntax, arguments, and worked examples for every function — filter by category or search by name.
30 functions
AND()
Returns TRUE only if every argument is true.
AND(logical1, [logical2], ...)View syntax & examples →StatisticalAVERAGE()
Calculates the arithmetic mean of a set of numbers.
AVERAGE(number1, [number2], ...)View syntax & examples →StatisticalAVERAGEIF()
Averages the cells in a range that meet a single condition.
AVERAGEIF(range, criteria, [average_range])View syntax & examples →TextCONCAT()
Joins text from multiple cells or strings together, with no delimiter.
CONCAT(text1, [text2], ...)View syntax & examples →StatisticalCOUNTIF()
Counts the cells in a range that meet a single condition.
COUNTIF(range, criteria)View syntax & examples →StatisticalCOUNTIFS()
Counts cells that meet multiple conditions at once.
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)View syntax & examples →Date & TimeDATE()
Builds a date from separate year, month, and day numbers.
DATE(year, month, day)View syntax & examples →Date & TimeDATEDIF()
Calculates the difference between two dates in years, months, or days.
DATEDIF(start_date, end_date, unit)View syntax & examples →Lookup & ReferenceHLOOKUP()
Like VLOOKUP, but searches the top row of a range and returns a value from a row you specify below it.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])View syntax & examples →LogicalIF()
Returns one value if a condition is true and another if it's false.
IF(logical_test, value_if_true, [value_if_false])View syntax & examples →LogicalIFERROR()
Returns a fallback value if a formula evaluates to an error, otherwise returns the formula's normal result.
IFERROR(value, value_if_error)View syntax & examples →LogicalIFS()
Checks multiple conditions in order and returns the value for the first one that's true — no nesting required.
IFS(logical_test1, value1, [logical_test2, value2], ...)View syntax & examples →Lookup & ReferenceINDEX()
Returns the value at a given row and column position within a range.
INDEX(array, row_num, [column_num])View syntax & examples →TextLEFT()
Returns a specified number of characters from the start of a text string.
LEFT(text, [num_chars])View syntax & examples →Lookup & ReferenceMATCH()
Returns the relative position of a value within a range, rather than the value itself.
MATCH(lookup_value, lookup_array, [match_type])View syntax & examples →TextMID()
Returns characters from the middle of a text string, starting at a position you specify.
MID(text, start_num, num_chars)View syntax & examples →LogicalOR()
Returns TRUE if any argument is true.
OR(logical1, [logical2], ...)View syntax & examples →StatisticalRANK()
Returns the rank of a number within a list — 1st, 2nd, 3rd, and so on.
RANK(number, ref, [order])View syntax & examples →TextRIGHT()
Returns a specified number of characters from the end of a text string.
RIGHT(text, [num_chars])View syntax & examples →Math & TrigROUND()
Rounds a number to a specified number of digits.
ROUND(number, num_digits)View syntax & examples →Math & TrigROUNDUP()
Rounds a number away from zero, regardless of the digit that follows.
ROUNDUP(number, num_digits)View syntax & examples →Math & TrigSUM()
Adds up a range of numbers or a list of values.
SUM(number1, [number2], ...)View syntax & examples →Math & TrigSUMIF()
Sums the cells in a range that meet a single condition.
SUMIF(range, criteria, [sum_range])View syntax & examples →Math & TrigSUMIFS()
Sums cells that meet multiple conditions at once.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)View syntax & examples →Math & TrigSUMPRODUCT()
Multiplies corresponding items across arrays and adds up the results — a flexible way to do conditional sums without helper columns.
SUMPRODUCT(array1, [array2], [array3], ...)View syntax & examples →TextTEXTJOIN()
Joins text with a delimiter between each item, and can skip blank cells.
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)View syntax & examples →Date & TimeTODAY()
Returns the current date, updated automatically whenever the sheet recalculates.
TODAY()View syntax & examples →TextTRIM()
Removes leading and trailing spaces from text, and collapses multiple spaces between words to one.
TRIM(text)View syntax & examples →Lookup & ReferenceVLOOKUP()
Looks up a value in the first column of a range and returns a value from another column in the same row.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])View syntax & examples →Lookup & ReferenceXLOOKUP()
The modern replacement for VLOOKUP — searches any direction, defaults to an exact match, and returns a custom value when nothing is found.
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])View syntax & examples →