I would like Excel to return "Great" as the overall rating if:the total score is less than or equal to 166the total score is greater than or equal to 167 and less than or equal to 233the total score is greater than or equal to 234 and less than or equal to 300My attempt is attached, but I was expecting the overall rating to return "great" and it returned "good." Any advice?

Ashley Why IFS? Try this: =LOOKUP(C11,{0,167,234},{"Good","Great","Excellent"})

Forum Discussion

Iron Contributor

Jun 20, 2022

Solved

I would like Excel to return "Great" as the overall rating if:

My attempt is attached, but I was expecting the overall rating to return "great" and it returned "good."

Any advice?

Riny_van_Eekelen
Jun 20, 2022
Ashley Why IFS? Try this:

=LOOKUP(C11,{0,167,234},{"Good","Great","Excellent"})

Ashley
Iron Contributor
Jun 20, 2022
For the record, both responses worked beautifully. Try them both!
Riny_van_Eekelen
Platinum Contributor
Jun 20, 2022
Ashley Why IFS? Try this:

=LOOKUP(C11,{0,167,234},{"Good","Great","Excellent"})
mtarler
Silver Contributor
Jun 20, 2022
Ashley The only problem you had was putting "" around the VALUES (making them text)
=IFS(C11<167,"Good",C11<234,"Great",C11<300,"Excellent",TRUE,"OFF THE CHART")
I removed the quotes and it worked "Great"
I also added a DEFAULT condition (i.e. if none of the other apply) and return "OFF THE CHART"
see attached
Example for Tech Community.xlsx10 KB