ISNONTEXT Function (Functions in Excel)

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

Related Posts by Categories