ISNUMBER with IF Returns FALSE

**hokkaido19** · 01-14-2015, 12:26 AM

Hello,

=IF(AND(ISNUMBER(O15),ISNUMBER(P15)),IF(O15>P15,"Improved","Regressed"))

My formula works, but where there is no number I get FALSE. I would like to change this to N/A. But I don't know where to write "N/A" in my formula.

Thanks very much!

**kvsrinivasamurthy** · 01-14-2015, 12:47 AM

Try this

Please Login or Register  to view this content.

**hokkaido19** · 01-14-2015, 02:25 AM

Thanks very much, Kv. That's almost does it. I get #N/A now instead of FALSE.

**daddylonglegs** · 01-14-2015, 04:24 AM

If you want a text value "N/A" rather than an error value then replace NA() with "N/A"

**hokkaido19** · 01-14-2015, 04:59 AM

That's sorted it. Thanks very much (both of you)!

**hokkaido19** · 01-14-2015, 06:02 AM

I want to add IF(O15>Q15) to my formula, but I can't get it to work. This is what I have now:

=IF(AND(ISNUMBER(O15),ISNUMBER(P15),ISNUMBER(Q15)),IF(O15>P15,"Improved","Regressed"),IF(O15>Q15,"Improved","Regressed"),"N/A")

Excel says there are too many arguments. What should I change? Thanks!

**[email protected]** · 01-14-2015, 06:16 AM

Hi,

Try this.. remove last condition
=IF(AND(ISNUMBER(O15),ISNUMBER(P15),ISNUMBER(Q15)),(IF(O15>P15,"Improved","Regressed")),IF(O15>Q15,"Improved","Regressed"))

**hokkaido19** · 01-14-2015, 07:18 AM

Thanks, PG. I used your formula, but it doesn't quite work.

I need my IF formula to check three columns for Number Values; then check if one value is greater than two others and finally write "Improved" or "Regressed." The figures are test scores, by the way. This is easier to grasp on the simplified spreadsheet attached (Test - Hokkaido Jan 14.xlsx); the last column shows the result I would like to have. As the issue has become a little more complicated I am going to mark this thread as solved and post a new question. Thanks!

**[email protected]** · 01-15-2015, 05:44 AM

Try this..
=IF(COUNTIF(D5:E5,"N/A")>0,"N/A",IF(AND(C5>D5,C5>E5),"Improved","Regressed"))

Regards,
Suhas

ISNUMBER with IF Returns FALSE

LinkBack

Thread Tools

Rate This Thread

Display

ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Re: ISNUMBER with IF Returns FALSE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Not sure where to put false condition within ISNUMBER formula

[SOLVED] ISNUMBER = FALSE, how do I convert to number?

IF(ISNUMBER(SEARCH(Find Text, Within Text)),True, False)

False Returns

How to do nothing if @IF returns FALSE?

Bookmarks

Bookmarks

Posting Permissions