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