Simple but can't figure it out!

[Alison Flynn]

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!

[#2 · Accepted solution]

Hi Alison,

=(AX2<=4)+(AX2>=7.9)

[#3]

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

[#4]

Alison,

It works like this

Please check attached

[#5]

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

[#6]

Hi Detlef,

Cheers for that, works now!

Alison 

[#7]

Working now, Sergei.

Thanks a million!