Excel Function Library

Return TRUE if all supplied conditions evaluate to TRUE.

Return the arithmetic mean of the numbers in a range or list of values.

Return the average of values that meet one condition.

Return the average of values that meet multiple conditions.

Join text from multiple cells or ranges into one string without adding a delimiter.

Join multiple text values into a single text string.

Use a natural-language prompt directly in a cell to generate or transform content with Excel Copilot.

Count how many cells contain numeric values.

Count how many cells are not empty.

Count how many blank cells are in a range.

Count the number of cells in a range that meet a single condition.

Count how many rows meet multiple criteria.

Build a valid Excel date from separate year, month, and day values.

Calculate the difference between two dates in years, months, days, or combinations of them.

Return the day number from a valid Excel date.

Return the last day of the month a given number of months before or after a start date.

Return only the rows or columns in an array that meet criteria you define.

Return the starting position of one text string inside another, with case-sensitive matching.

Search across the top row of a table and return a value from a specified row underneath it.

Test a condition and return one result for TRUE and another for FALSE.

Evaluate multiple conditions and return the result for the first TRUE condition.

Return a value from a range by row number, column number, or both.

Return the reference specified by a text string, allowing dynamic cell and range references.

Test whether a value is numeric in Excel and return TRUE or FALSE without coercing text numbers.

Return the first character or characters from a text string.

Return the number of characters in a text string.

Return the relative position of a value inside a row or column.

Return characters from the middle of a text string based on a start position and length.

Return the remainder after a number is divided by a divisor.

Return the month number from a valid Excel date.

Return the number of working days between two dates.

Return the current date and time based on the workbook's latest recalculation.

Return a reference shifted by a specified number of rows and columns from a starting point.

Return TRUE if any supplied condition evaluates to TRUE.

Return characters from the right end of a text string.

Round a number to a specified number of digits.

Return the starting position of one text string inside another, without case-sensitive matching.

Sort the contents of a range or array by one of its rows or columns.

Add numbers, cell references, and ranges together in a single formula.

Add values that meet a single condition.

Add values that meet multiple conditions at the same time.

Match an expression against a list of values and return the result for the first match.

Convert a value to text using a custom number, date, or time format.

Join text from multiple cells or ranges into one string with a delimiter you choose.

Build a valid Excel time value from hour, minute, and second components.

Return the current date as a dynamic Excel date value.

Remove extra spaces from text while leaving single spaces between words.

Truncate a number by removing digits without rounding the result.

Return a code that identifies the data type of a value.

Return a list of distinct values from a range or array.

Convert a text representation of a number, date, or time into a numeric Excel value.

Search for a value in the first column of a table and return a value from the same row.

Return the day-of-week number for a valid Excel date.

Return a date that is a given number of working days before or after a start date.

Search a range or array for a match and return a corresponding item from a second range or array.

Return the year from a valid Excel date.