isnontext
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) |
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.
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”) |