Excel Formulas

Showing page 4 of 21
ISLOGICAL
Information

Returns TRUE if the value is a logical value

ISNA
Information

Returns TRUE if the value is the #N/A error value

ISNONTEXT
Information

Returns TRUE if the value is not text

ISNUMBER
Information

Returns TRUE if the value is a number

ISODD
Information

Returns TRUE if the number is odd

ISREF
Information

Returns TRUE if the value is a reference

ISTEXT
Information

Returns TRUE if the value is text

TYPE
Information

Returns a number indicating the data type of a value

N
Information

Returns a value converted to a number

SHEET
Information

Returns the sheet number of the referenced sheet

SHEETS
Information

Returns the number of sheets in a reference

FORMULATEXT
Information

Returns the formula at the given reference as text

CHOOSE
Lookup

Chooses a value from a list of values

COLUMN
Lookup

Returns the column number of a reference

COLUMNS
Lookup

Returns the number of columns in a reference

ROW
Lookup

Returns the row number of a reference

ROWS
Lookup

Returns the number of rows in a reference

TRANSPOSE
Lookup

Returns the transpose of an array

HLOOKUP
Lookup

Looks in the top row of an array and returns the value of the indicated cell

LOOKUP
Lookup

Looks up values in a vector or array

Page 4 of 21