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.
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
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.
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.
using the letter O instead of the zero 0.
Table 2 shows how the error is trapped using the =ISNONTEXT function and
the =IF() function in the calculation.
One Response
Today, I went to the beachfront with my kids. I found a sea shell and
gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.”
She put the shell to her ear and screamed.
There was a hermit crab inside and it pinched her ear.
She never wants to go back! LoL I know this is completely off topic but I had to tell someone!