Forum Discussion

Alison Flynn's avatar
Alison Flynn
Brass Contributor
Dec 18, 2018
Solved

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 fall...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 18, 2018

    Hi Alison,

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

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 18, 2018

Hi Alison,

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

 

  • Alison Flynn's avatar
    Alison Flynn
    Brass Contributor
    Dec 18, 2018

    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

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Dec 18, 2018

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

      • Alison Flynn's avatar
        Alison Flynn
        Brass Contributor
        Dec 18, 2018

        Hi Detlef,

         

        Cheers for that, works now!

        Alison 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 18, 2018

      Alison,

       

      It works like this

      Please check attached

      • Alison Flynn's avatar
        Alison Flynn
        Brass Contributor
        Dec 18, 2018

        Working now, Sergei.

         

        Thanks a million!