Formula Functions > Functions H to L > ISNONTEXT |
This function tests whether a value, an expression, or contents of a referenced cell has any data type other than text.
ISNONTEXT(cellreference)
ISNONTEXT(value)
ISNONTEXT(expression)
Specify a cell reference, a numeric or text value, or an expression for the argument.
Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.
This function returns TRUE if the value refers to a blank cell.
Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.
ISNONTEXT(A3)
ISNONTEXT(R3C1)
ISNONTEXT(12) gives the result TRUE
ISNONTEXT("Total") gives the result FALSE
This function is available in product version 1.0 or later.
ISLOGICAL | ISNUMBER | ISTEXT | Information Functions