Forum Discussion

Alison Flynn's avatar
Alison Flynn
Brass Contributor
Dec 18, 2018
Solved

Simple but can't figure it out!

Hi guys,

I've what I suspect is a simple formula but I can't figure it out. Any help would be greatly appreciated.

 

So here goes:

If the value is between 4 and 7.9 the answer is 0 and if it falls outside that range the answer is 1.

What I've put in is =IF(AX2>4,0,IF(AX2<7.9,0,1)).  I'm getting zero as the answer regardless of what value is in AX2.

I would sit and look at this all day but be none the wiser! 

Thanks in advance for helping!

 

excel
Formulas and Functions

6 Replies

    • Alison Flynn's avatar
      Alison Flynn
      Brass Contributor
      Dec 18, 2018

      Hi Sergei,

       

      Thanks for your reply.  I'm afraid that hasn't worked - it's giving me an answer of 1 regardless to what the value is in AX2.  So if it falls within the range the answer should be 0.

       

      Any other thoughts?

      Thanks

      Alison

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Dec 18, 2018

        Alison, probably the value in AX2 is text and not a number. You can check with ISNUMBER(AX2).