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
Search JabSto ::




Custom Search