ISNONTEXT (Returns TRUE if the value is not text)

What Does It Do?

This functions tests an entry to determine whether it is a number, rather than text.

It would be used to ensure that only numeric entries are used in calculations, rather than text which looks like a number, such as typing the letter O instead of zero 0.

The function is normally used with other function such as the =IF() function.

Syntax

=ISNONTEXT(CellToTest)

Formatting

No special formatting is needed.

Example

The following table is used by an electrical retailer to calculate the selling price of an item based on the buying price and the shop mark-up.

Table 1 shows the #VALUE! error generated when a number, 300, is entered using the letter O instead of the zero 0.

Table 2 shows how the error is trapped using the =ISNONTEXT function and the =IF() function in the calculation.