Forum Discussion

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

excel

Formulas and Functions

SergeiBaklan
Dec 18, 2018
Hi Alison,

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

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

Silver Contributor

Dec 18, 2018

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

Alison Flynn
Brass Contributor
Dec 18, 2018
Hi Detlef,

Cheers for that, works now!
Alison