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...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 25, 2017

    Hi Terrie,

     

    Try this

    =IFS(N12>84,"7+",N12>36,"3-7",N12<=36,"0-3")
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 25, 2017

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+"})