SOLVED
Home

Simple but can't figure it out!

%3CLINGO-SUB%20id%3D%22lingo-sub-303345%22%20slang%3D%22en-US%22%3ESimple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303345%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3EI've%20what%20I%20suspect%20is%20a%20simple%20formula%20but%20I%20can't%20figure%20it%20out.%20Any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20here%20goes%3A%3C%2FP%3E%3CP%3EIf%20the%20value%20is%20between%204%20and%207.9%20the%20answer%20is%200%20and%20if%20it%20falls%20outside%20that%20range%20the%20answer%20is%201.%3C%2FP%3E%3CP%3EWhat%20I've%20put%20in%20is%20%3DIF(AX2%26gt%3B4%2C0%2CIF(AX2%26lt%3B7.9%2C0%2C1)).%20%26nbsp%3BI'm%20getting%20zero%20as%20the%20answer%20regardless%20of%20what%20value%20is%20in%20AX2.%3C%2FP%3E%3CP%3EI%20would%20sit%20and%20look%20at%26nbsp%3Bthis%20all%20day%20but%26nbsp%3Bbe%20none%20the%20wiser!%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20helping!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-303345%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303377%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303377%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20now%2C%20Sergei.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20million!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303376%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303376%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Detlef%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20for%20that%2C%20works%20now!%3C%2FP%3E%3CP%3EAlison%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303372%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303372%22%20slang%3D%22en-US%22%3E%3CP%3EAlison%2C%20probably%20the%20value%20in%20AX2%20is%20text%20and%20not%20a%20number.%20You%20can%20check%20with%20ISNUMBER(AX2).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303367%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303367%22%20slang%3D%22en-US%22%3E%3CP%3EAlison%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20works%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20238px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F63036i30513A1BA61805EE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20check%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303365%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303365%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%20%26nbsp%3BI'm%20afraid%20that%20hasn't%20worked%20-%20it's%20giving%20me%20an%20answer%20of%201%20regardless%20to%20what%20the%20value%20is%20in%20AX2.%20%26nbsp%3BSo%20if%20it%20falls%20within%20the%20range%20the%20answer%20should%20be%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20other%20thoughts%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EAlison%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303363%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20but%20can't%20figure%20it%20out!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303363%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Alison%2C%3C%2FP%3E%0A%3CPRE%3E%3D(AX2%26lt%3B%3D4)%2B(AX2%26gt%3B%3D7.9)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Alison Flynn
Contributor

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!

 

6 Replies
Solution

Hi Alison,

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

 

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

Alison,

 

It works like this

image.png

Please check attached

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

Hi Detlef,

 

Cheers for that, works now!

Alison 

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