# 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. 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. 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. 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.