.

ISNONTEXT Function Dictionary

Function Dictionary Function Examples Function Categories

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.
Examples        
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")

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download