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!