Excel Functions

On this page, you'll find the most commonly used functions, each demonstrated in a simple example.

Date & Time

DATEDIF	Calculates the number of days, months or years between two dates.
TODAY	Displays today's date.

Logical

AND	Checks if all tests are TRUE.
BYCOL	Applies a LAMBDA function to each column and returns an array of the results.
BYROW	Applies a LAMBDA function to each row and returns an array of the results.
IF	Checks if a condition is met and returns a value based on that condition.
IFS	Checks if multiple conditions are met and returns a value corresponding to the first true condition.
IFERROR	Returns a value if there is no error or another value in case of error.
LAMBDA	Creates a custom function.
LET	Assigns a name to calculation results.
MAKEARRAY	Returns an array of specified dimensions by applying a LAMBDA function.
MAP	Returns an array after applying a LAMBDA function.
OR	Checks if at least one of the tests is TRUE.
REDUCE	Reduces an array to a cumulative value by applying a LAMBDA function.
SCAN	Traverses the values of an array, applies a LAMBDA function and returns an array of intermediate values.

Math & Trig

MROUND	Rounds a value to the desired multiple.
RAND	Randomly generates a value.
RANDBETWEEN	Randomly generates a value between 2 specified numbers.
ROUND	Rounds a value.
ROUNDDOWN	Rounds a value down.
ROUNDUP	Rounds a value up.
SQRT	Performs the square root.
SUM	Calculates the sum of a series of values.
SUMIF	Calculates the sum from values that meet a condition.
SUMIFS	Calculates the sum from values that meet several conditions.
SUMPRODUCT	Returns the sum of the products of ranges of values.

Lookup & Reference

CHOOSE	Displays a value or performs an action based on a choice.
FILTER	Filters a range of cells based on defined criteria.
INDEX	Returns a value from an array based on its coordinates.
INDEX + MATCH	Combination similar to HLOOKUP/VLOOKUP without the constraint of the first row/column.
HLOOKUP	Returns a value from an array based on a value in the first row.
MATCH	Returns the position of a value in an array.
SORT	Sorts the content of a range of cells or an array.
SORTBY	Sorts the content of a range of cells or an array based on a range of cells or an array.
TRIMRANGE	Removes empty rows or columns around a cell range or table.
UNIQUE	Returns the list of unique values from a range of cells or an array.
VLOOKUP	Returns a value from an array based on a value in the first column.
XLOOKUP	Searches for a value in an array then returns the corresponding value in the same position in a second array.
XMATCH	Returns the position of a value in an array.

Statistical

AVERAGE	Performs the average of a series of values.
COUNT	Counts the number of cells containing numbers.
COUNTA	Counts the number of non-empty cells.
COUNTBLANK	Counts the number of empty cells.
COUNTIF	Counts the number of cells meeting a criteria.
COUNTIFS	Counts the number of cells meeting several criteria.
MAX	Returns the highest value.
MIN	Returns the lowest value.

Text

LEFT	Extracts characters from the left.
LOWER	Converts to lowercase.
MID	Extracts characters from a string.
PROPER	Converts the first letter of each word to uppercase and the other letters to lowercase.
REGEXEXTRACT	Extracts text values based on a regular expression.
REGEXREPLACE	Replaces text values based on a regular expression.
REGEXTEST	Checks whether a string matches a regular expression.
RIGHT	Extracts characters from the right.
SUBSTITUTE	Replaces textual values with others.
TEXTJOIN	Assembles the values of one or several ranges of data using the defined separator.
TEXTSPLIT	Splits a text using column and row separators.
TRIM	Removes unnecessary spaces from the text.
UPPER	Converts to uppercase.

Compatibility

CONCATENATE	Assembles values one after the other.
FORECAST	Extrapolates using known data.
RANK	Assigns a ranking to a value based on a series of values.