Forum Discussion

Terrie Grusnis's avatar
Terrie Grusnis
Copper Contributor
Apr 25, 2017
Solved

IFS function with multiple criteria

I'm trying to write an IFS funtion with values returned on three criterias and I'm having a problem with the second criteria. The first criteria is to return a value if the cell has a value less than or equal to 36, the second criteria is to return a value if the cell is greater than 36 but less than 84, and the last criteria is to return a value if the cell is greater than 84. My problem is I don't know how to write for the second criteria. This is what I have, and yes the middle (2nd criteria) if completely wrong, so don't laugh, I'm really new at formulas. :)

 

=IFS(N12<=36,"0-3",N12>36<=84,"3-7",N12>84,"7+") 

 

I really need an answer quickly.

 

Thank you in advance,

Terrie Grusnis

3 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello Terrie

     

    =IFS(N12<=36,"0-3",N12<=84,"3-7",TRUE,"7+")

    Or with LOOKUP():

    =LOOKUP(N12,{0;37;85},{"0-3";"3-7";"7+"})

     

     

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Terrie,

     

    Try this

    =IFS(N12>84,"7+",N12>36,"3-7",N12<=36,"0-3")
    • Terrie Grusnis's avatar
      Terrie Grusnis
      Copper Contributor

      Thank you so much, Sergei, that worked!! Much appreciated.

       

      Sincerely,

      Terrie Grusnis