SOLVED

Highlighted
Contributor

# 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!

6 Replies
Highlighted
Solution

# Re: Simple but can't figure it out!

Hi Alison,

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

Highlighted

# Re: Simple but can't figure it out!

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

Highlighted

# Re: Simple but can't figure it out!

Alison,

It works like this

Highlighted

# Re: Simple but can't figure it out!

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

Highlighted

# Re: Simple but can't figure it out!

Hi Detlef,

Cheers for that, works now!

Alison

Highlighted

# Re: Simple but can't figure it out!

Working now, Sergei.

Thanks a million!