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