ISNONTEXT

Definition: ISNONTEXT is a function that returns TRUE if a value is not text, and FALSE if it is text.

Syntax: =ISNONTEXT(value)

Situation: This formula is appropriate when you need to check if a value is not text.

Example: If you want to check if cell A1 contains a non-text value, the formula =ISNONTEXT(A1) will return TRUE if it contains a non-text value, and FALSE if it contains text.