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
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.
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.
Nakliyat
October 12, 2023 at 3:54 pm
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!