Math
SUM
Returns the total of all the numbers in the cells, ranges, or values you give it.
Functions
Math
AVERAGE
Returns the arithmetic mean of the numbers in the cells or ranges you give it.
Math
COUNT
Returns how many of the given cells or values contain numbers.
Math
MIN
Returns the smallest number found in the cells or ranges you give it.
Math
MAX
Returns the largest number found in the cells or ranges you give it.
Logical
IF
Returns one result when a test is true and a different result when it is false.
Lookup
VLOOKUP
Returns a value from the same row as a key found in the first column of a table.
Lookup
INDEX
Returns the value sitting at a chosen row and column position inside a range.
Lookup
MATCH
Returns the position of a value within a single row or column of cells.
Text
LEFT
Returns the first characters of a piece of text.
Text
LEN
Returns the number of characters in a piece of text, spaces included.
Date
TODAY
Returns the current date from your computer clock.
Math
ROUND
Returns the number you give it, rounded to a given number of digits.
Math
COUNTIF
Returns how many cells in a range meet one criterion.
Text
RIGHT
Returns the last characters of a piece of text.
Math
SUMIF
Returns the sum of numbers that correspond to cells passing a single test.
Math
SUMIFS
Returns the sum of numbers from rows that satisfy every listed test.
Math
SUMPRODUCT
Returns the sum after multiplying numbers that share a position across ranges.
Text
MID
Returns characters from the middle of a piece of text, starting at a given position.
Text
FIND
Returns the starting position of one piece of text inside another, matching letter case.
Text
SEARCH
Returns the starting position of one piece of text inside another, ignoring letter case.
Logical
AND
Returns true only when every logical test you give it is true.
Logical
OR
Returns true when at least one of the logical tests you give it is true.
Logical
TRUE
Returns the logical value true, which a formula can store as a passing test.
Date
DATE
Returns a date built from a year, a month number, and a day number.
Date
YEAR
Returns the four-digit calendar year of a date.
Date
MONTH
Returns the month number of a date, from 1 through 12.
Math
AVERAGEIF
Returns the mean of numbers whose matching cells pass a single criterion.
Math
AVERAGEIFS
Returns the mean of numbers from rows that meet every listed test.
Math
COUNTIFS
Returns how many rows satisfy every listed test.
Text
UPPER
Returns a copy of text with every letter converted to uppercase.
Text
LOWER
Returns a copy of text with every letter converted to lowercase.
Text
PROPER
Returns a copy of text with the first letter of each word capitalized.
Logical
NOT
Returns the opposite of a logical value: true becomes false, and false becomes true.
Logical
IFERROR
Returns a fallback value when a formula produces an error, and otherwise returns the formula result.
Logical
FALSE
Returns the logical value false, which a formula can store as a failing test.
Date
DAY
Returns the day of the month of a date, from 1 through 31.
Date
WEEKDAY
Returns a number that stands for the weekday of a date.
Date
EDATE
Returns a date that is a given number of months before or after a start date.
Math
COUNTA
Returns how many of the given cells are not empty.
Math
COUNTBLANK
Returns how many cells in a range are empty.
Math
RAND
Returns a random decimal that is at least 0 and less than 1.
Text
TRIM
Returns text after extra spaces are stripped from the ends and from between words.
Text
SUBSTITUTE
Returns text after every matching piece of old text is replaced with new text.
Text
CLEAN
Returns text after non-printable characters have been removed.
Logical
IFS
Returns the result paired with the first logical test that is true.
Logical
ISBLANK
Returns true when a cell is empty and false when the cell holds a value.
Logical
SWITCH
Returns the result that matches a given value, or a default when no match is found.
Date
DATEDIF
Returns the span between two dates in years, months, or days, according to a unit code.
Date
DAYS
Returns how many days fall between a start date and an end date.
Date
EOMONTH
Returns the last day of the month that is a given number of months from a start date.
Math
ROUNDUP
Returns a number rounded away from zero to a given number of digits.
Math
ROUNDDOWN
Returns a number rounded toward zero to a given number of digits.
Math
CEILING
Returns a number rounded up to the next multiple of a given significance.
Text
TEXTJOIN
Returns one string made by joining text values with a delimiter you choose.
Text
TEXT
Returns a number written as text according to a format code you supply.
Text
CONCAT
Returns one string made by joining text values with no delimiter between them.
Logical
ISNUMBER
Returns true when a value is a number and false when it is not.
Logical
ISERROR
Returns true when a formula result is an error and false when it is not.
Logical
ISTEXT
Returns true when a value is text and false when it is not.
Date
NETWORKDAYS
Returns how many weekdays fall between a start date and an end date.
Date
WORKDAY
Returns a date that is a given number of weekdays before or after a start date.
Date
NOW
Returns the current date and time from your computer clock.
Math
ABS
Returns the absolute value of a number, with any minus sign removed.
Math
MOD
Returns the remainder after one number is divided by another.
Math
FLOOR
Returns a number rounded down to the next multiple of a given significance.
Text
VALUE
Returns a number converted from a piece of text that looks like a number.
Text
EXACT
Returns true when two pieces of text are identical, matching letter case.
Text
REPLACE
Returns text after characters at a given position are swapped for new text.
Date
TIME
Returns a time built from an hour, a minute number, and a second number.
Date
HOUR
Returns the hour of a time, from 0 through 23.
Date
MINUTE
Returns the minute of a time, from 0 through 59.
Math
POWER
Returns a number raised to a given exponent.
Math
SQRT
Returns the square root of a number.
Math
PI
Returns the constant pi, the ratio of a circle circumference to its diameter.
Lookup
HLOOKUP
Returns a value from the same column as a key found in the first row of a table.
Lookup
XLOOKUP
Returns a value from a return range by matching a key in a separate lookup range.
Lookup
XMATCH
Returns the position of a lookup value in a range, with optional match and search modes.
Math
MEDIAN
Returns the middle number in a set of numbers after they are ordered.
Math
LARGE
Returns the nth largest number found in the cells or ranges you give it.
Math
RANK
Returns the standing of a number among a list of numbers.
Lookup
FILTER
Returns the rows or columns from a range that pass a given test.
Lookup
UNIQUE
Returns the distinct values from a range, dropping repeats.
Lookup
CHOOSE
Returns the value at a chosen index from a list of arguments.
Math
MINIFS
Returns the smallest number from rows that satisfy every listed test.
Math
MAXIFS
Returns the largest number from rows that satisfy every listed test.
Math
SMALL
Returns the nth smallest number found in the cells or ranges you give it.
Lookup
INDIRECT
Returns the value of a cell whose address is written as text.
Lookup
SORT
Returns the values from a range ordered by one or more columns.
Lookup
OFFSET
Returns a cell or range a given number of rows and columns away from a starting cell.
Lookup
ROW
Returns the row number of a given cell.
Lookup
COLUMN
Returns the column number of a given cell.
Lookup
LOOKUP
Returns a value from a result vector after matching a key in a lookup vector.
Lookup
ROWS
Returns how many rows a given range contains.
Lookup
COLUMNS
Returns how many columns a given range contains.