SOLVED

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
Highlighted
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
Highlighted
Solution

Hi Alison,

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

 

Highlighted

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

Alison,

 

It works like this

image.png

Please check attached

Highlighted

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

Highlighted

Hi Detlef,

 

Cheers for that, works now!

Alison 

Highlighted

Working now, Sergei.

 

Thanks a million!