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!
View best response
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?
It works like this
Please check attached
Alison, probably the value in AX2 is text and not a number. You can check with ISNUMBER(AX2).
Cheers for that, works now!
Working now, Sergei.
Thanks a million!