Microsoft Office Tutorials and References

In Depth Information

SHEETS*

Returns the number of sheets in a reference.

TYPE

Returns a number indicating the data type of a value.

* Indicates a function introduced in Excel 2013.

Table A-8: Logical Category Functions

Function

What It Does

AND

Returns TRUE if all its arguments are TRUE.

FALSE

Returns the logical value FALSE.

IF

Specifies a logical test to perform.

IFERROR* Returns a different result if the first argument evaluates to an error.

Returns the value you specify if the expression resolves to #N/A; otherwise, re-

turns the result of the expression.

IFNA**

NOT

Reverses the logic of its argument.

OR

Returns TRUE if any argument is TRUE.

TRUE

Returns the logical value TRUE.

XOR**

Returns a logical exclusive OR of all arguments.

* Indicates a function introduced in Excel 2007.** Indicates a function introduced in Excel 2013.

Table A-9: Lookup & Reference Category Functions

Function

What It Does

ADDRESS

Returns a reference as text to a single cell in a worksheet.

AREAS

Returns the number of areas in a reference.

CHOOSE

Chooses a value from a list of values.

COLUMN

Returns the column number of a reference.

COLUMNS

Returns the number of columns in a reference.

FORMULATEXT* Returns the formula at the given reference as text.

GETPIVOTDATA
Returns data stored in a pivot table.

Searches for a value in the top row of a table and then returns a value in

the same column from a row you specify in the table.

HLOOKUP