Spread Formula Reference
ISNONTEXT
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.

Syntax

ISNONTEXT(cellreference)

ISNONTEXT(value)

ISNONTEXT(expression)

Arguments

Specify a cell reference, a numeric or text value, or an expression for the argument.

Remarks

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.

Data Types

Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

Examples

ISNONTEXT(A3)

ISNONTEXT(R3C1)

ISNONTEXT(12) gives the result TRUE

ISNONTEXT("Total") gives the result FALSE

Version Available

This function is available in product version 1.0 or later.

See Also

ISLOGICAL | ISNUMBER | ISTEXT | Information Functions