Forum Discussion
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
Hi Terrie,
Try this
=IFS(N12>84,"7+",N12>36,"3-7",N12<=36,"0-3")
3 Replies
- Detlef_LewinSilver 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+"}) - SergeiBaklanDiamond Contributor
Hi Terrie,
Try this
=IFS(N12>84,"7+",N12>36,"3-7",N12<=36,"0-3")
- Terrie GrusnisCopper Contributor
Thank you so much, Sergei, that worked!! Much appreciated.
Sincerely,
Terrie Grusnis