Home Computer Learn What is Isnontext Excel formula and where to use.

Learn What is Isnontext Excel formula and where to use.

1 min read


Isnontext excel formula step by step


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.


No special formatting.

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.
Isnontext Excel formula example 1

Table 2 shows how the error is trapped using the =ISNONTEXT function and

the =IF() function in the calculation.
Isnontext formula example
Load More Related Articles
Load More By amitgupta
Load More In Computer

One Comment

  1. 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!

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…