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
1
0
46
1ST.3

ISNONTEXT

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.

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.
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…