Returns TRUE if all of its arguments are TRUE.

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

Reverses the logic of its argument.

Returns TRUE if any argument is TRUE.

Returns the average (arithmetic mean) of the arguments.

Counts the number of cells that contain numbers.

Counts the number of cells that are not empty.

Counts the number of cells within a range that meet a single criterion.

Counts the number of cells that meet multiple criteria.

Rounds a number to a specified number of digits.

Adds all the numbers in a range of cells.

Adds the cells specified by a given criteria.

Adds the cells in a range that meet multiple criteria.

Joins several text strings into one text string (superseded by CONCAT and the "&" operator).

Returns the specified number of characters from the start of a text string.

Returns the number of characters in a text string.

Returns a specific number of characters from a text string, starting at the position you specify.

Returns the specified number of characters from the end of a text string.

Combines the text from multiple ranges and/or strings, with a delimiter you specify.

Removes all spaces from a text string except for single spaces between words.

Returns the serial number that represents a particular date.

Calculates the number of days, months, or years between two dates.

Returns the number of whole working days between two dates.

Returns the current date and time.

Returns the current date.

Calculates the future value of an investment.

Returns the internal rate of return for a series of cash flows.

Calculates the net present value of an investment by using a discount rate and a series of future payments and income.

Calculates the payment for a loan based on constant payments and a constant interest rate.

Calculates the present value of an investment.

Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.

Returns the relative position of an item in a range that matches a specified value.

Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.

Searches a range or an array for a match and returns the corresponding item from a second range or array. The modern replacement for VLOOKUP/HLOOKUP.