Excel Function Library

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

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

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.

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.

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

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 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 characters from the right end of a text string.

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.

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

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

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

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.