Too Many Arguments - If Number is Between a Range, Then it is This

[blahmin027]

I have a column of numbers from 0 to 100, and now I need to group them according to a range:

0-24 = Poor
25-49 = Low
50-74 = Medium
75-100 = High

I tried doing this formula but Excel said there is too many arguments

=IF(D2>=1,D2<=24,"Poor",IF(D2>=25,D2<=49,"Low",IF(D2>=50,D2<=74,"Medium",IF(D2>=75,D2<=100,"High")))

Can anyone help me what formula I should do?

Thanks

 

[Fluff]

How about
=LOOKUP(D2,{0,25,50,75},{"Poor","Low","Medium","High"})

 

[blahmin027]

Thank you so much! It worked and much more elegant than what I did that also worked

=IF(D2<=24,"Poor",IF(D2<=49,"Low",IF(D2<=74,"Medium",IF(D2<=100,"High"))))

 

[Fluff]

You're welcome & thanks for the feedback.