• 412K Members
• 3,822 Online
• 468K Conversations
SOLVED

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
Solution

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

Hi Alison,

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

# 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

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

Alison,

It works like this

# 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).

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

Hi Detlef,

Cheers for that, works now!

Alison

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

Working now, Sergei.

Thanks a million!

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies