ISNONTEXT

Posted on 18-01-2020 , by: admin , in , 0 Comments

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

Leave a comment