Excel Function Library

Return TRUE if all supplied conditions evaluate to TRUE.

Convert full-width DBCS characters to half-width single-byte characters.

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.

Convert a number to Thai text and append the Baht currency suffix.

Return the character represented by a numeric character code.

Return one value from a list by position number.

Remove nonprintable characters from imported or copied text.

Return the numeric code for the first character in a text string.

Return the column number of a reference or of the cell that contains the formula.

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.

Convert a number to text in currency format with configurable rounding.

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

Compare two text strings and return TRUE only when they match exactly.

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.

Round a number, format it as text, and optionally suppress thousands separators.

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.

Convert all letters in a text string to lowercase.

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.

Extract the phonetic furigana characters from a text string or referenced cell.

Capitalize the first letter of each word-like segment in a text string.

Replace matching text in a string by using a regular expression pattern.

Replace part of a text string by character position and length.

Repeat a text string a specified number of times.

Return characters from the right end of a text string.

Round a number to a specified number of digits.

Round a number up, away from zero, to a specified number of digits.

Return the row number of a reference or of the cell that contains the formula.

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.

Sort a range or array based on values in a separate range or array.

Replace specific text inside a string by matching old text instead of character positions.

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.

Return text values as text and convert non-text values to an empty string.

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

Return the text that appears after a chosen delimiter.

Return the text that appears before a chosen delimiter.

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

Split text into columns, rows, or both by using one or more delimiters.

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 all letters in a text string to uppercase.

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.