isnontext
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.
| Item To Test | Is It A Number? | |
| 10 | TRUE | =ISNONTEXT(C4) |
| Hello | FALSE | =ISNONTEXT(C5) |
| TRUE | =ISNONTEXT(C6) | |
| 1-Jan-98 | TRUE | =ISNONTEXT(C7) |
| 1OO | FALSE | =ISNONTEXT(C8) |
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 1:
| Item | Buying Price | Mark-up | Profit | |
| Radio | 400 | 150% | 600 | |
| TV | 800 | 200% | 1600 | |
| Video | 3OO | 150% | #VALUE! | =D32*E32 |
Table 2 shows how the error is trapped using the =ISNONTEXT function and
the =IF() function in the calculation.
Table 2:
| Item | Buying Price | Mark-up | Profit |
| Radio | 400 | 150% | 600 |
| TV | 800 | 200% | 1600 |
| Video | 3OO | 150% | Retype the Price |
| =IF(ISNONTEXT (D40),D40*E40,” Retype the Price”) |