Forum Discussion

Ashley's avatar
Ashley
Iron Contributor
Jun 20, 2022
Solved

How do I include a range in my IFS function?

I would like Excel to return "Great" as the overall rating if: the total score is less than or equal to 166 the total score is greater than or equal to 167 and less than or equal to 233 the total...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 20, 2022

    Ashley Why IFS? Try this:

     

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

     

Ashley's avatar
Ashley
Iron Contributor
Jun 20, 2022

For the record, both responses worked beautifully. Try them both!

Resources