Excel Formula Helper
Browse and search common Excel formulas organized by category.
Math
SUM(number1, [number2], ...)Adds all numbers in a range of cells.
=SUM(A1:A10) → sums values in A1 through A10
AVERAGE(number1, [number2], ...)Returns the arithmetic mean of its arguments.
=AVERAGE(B1:B5) → average of B1 to B5
COUNT(value1, [value2], ...)Counts the number of cells that contain numbers.
=COUNT(C1:C20) → count of numeric cells in C1:C20
MIN(number1, [number2], ...)Returns the smallest value in a set of values.
=MIN(D1:D100) → smallest value in D1:D100
MAX(number1, [number2], ...)Returns the largest value in a set of values.
=MAX(E1:E50) → largest value in E1:E50
ROUND(number, num_digits)Rounds a number to a specified number of digits.
=ROUND(3.14159, 2) → 3.14
Lookup
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Searches for a value in the first column of a range and returns a value from a specified column in the same row.
=VLOOKUP(A2, B:D, 2, FALSE) → finds A2 in column B, returns column C
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])Searches for a value in the top row of a range and returns a value from a specified row in the same column.
=HLOOKUP("Sales", A1:E3, 2, FALSE) → finds Sales in row 1, returns row 2
INDEX(array, row_num, [col_num])Returns the value of an element in a table or array, selected by row and column number indexes.
=INDEX(A1:C10, 3, 2) → value at row 3, column 2 of A1:C10
MATCH(lookup_value, lookup_array, [match_type])Searches for a value in a range and returns the relative position of that item.
=MATCH("Apple", A1:A10, 0) → position of Apple in A1:A10
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Searches a range or array for a match and returns the corresponding item from a second range. Replaces VLOOKUP, HLOOKUP, and LOOKUP.
=XLOOKUP(A2, B:B, C:C) → finds A2 in column B, returns matching value from C
Text
CONCATENATE(text1, [text2], ...)Joins two or more text strings into one string.
=CONCATENATE(A1, " ", B1) → joins A1 and B1 with a space
LEFT(text, [num_chars])Returns the specified number of characters from the start of a text string.
=LEFT("Hello", 3) → "Hel"
RIGHT(text, [num_chars])Returns the specified number of characters from the end of a text string.
=RIGHT("Hello", 3) → "llo"
MID(text, start_num, num_chars)Returns a specific number of characters from a text string starting at the position you specify.
=MID("Hello World", 7, 5) → "World"
LEN(text)Returns the number of characters in a text string.
=LEN("Hello") → 5
TRIM(text)Removes all spaces from a text string except for single spaces between words.
=TRIM(" Hello World ") → "Hello World"
UPPER(text)Converts text to uppercase.
=UPPER("hello") → "HELLO"
LOWER(text)Converts text to lowercase.
=LOWER("HELLO") → "hello"
Logic
IF(logical_test, value_if_true, [value_if_false])Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.
=IF(A1>10, "High", "Low") → High if A1>10, else Low
AND(logical1, [logical2], ...)Returns TRUE if all its arguments are TRUE.
=AND(A1>0, B1>0) → TRUE only if both A1 and B1 are positive
OR(logical1, [logical2], ...)Returns TRUE if any argument is TRUE.
=OR(A1="Yes", B1="Yes") → TRUE if either A1 or B1 is Yes
NOT(logical)Reverses the value of its argument.
=NOT(A1>10) → TRUE if A1 is not greater than 10
IFERROR(value, value_if_error)Returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula.
=IFERROR(A1/B1, 0) → returns 0 if division produces an error
Date
TODAY()Returns the current date as a serial number.
=TODAY() → current date (e.g. 3/16/2026)
NOW()Returns the current date and time as a serial number.
=NOW() → current date and time (e.g. 3/16/2026 14:30)
DATE(year, month, day)Returns the sequential serial number that represents a particular date.
=DATE(2026, 3, 16) → date value for March 16, 2026
YEAR(serial_number)Returns the year corresponding to a date.
=YEAR(A1) → 2026 if A1 contains a date in 2026
MONTH(serial_number)Returns the month of a date represented by a serial number, as a number from 1 to 12.
=MONTH(A1) → 3 if A1 contains March 16, 2026
DAY(serial_number)Returns the day of the month for a given date, as a number from 1 to 31.
=DAY(A1) → 16 if A1 contains March 16, 2026
DATEDIF(start_date, end_date, unit)Calculates the number of days, months, or years between two dates. Unit can be "Y", "M", "D", "MD", "YM", or "YD".
=DATEDIF(A1, B1, "Y") → number of complete years between A1 and B1