IF formula to choose a rating

[nawas]

Hi,

I'm seeking your great help on the below issue

I've different rating matrix as below;

more than 90% - " Excellent"

80% to 89% - "Very Good"

65% to 79% - "Good"

below 64% - "Low"

hence if any of the rating falls in a cell need a formula to corresponds that (lets say in cell "A1" if the rating is 85% then result should be "Very Good")

Thanks

[NBVC]

Try

=Lookup(A1,{0,65,80,90},{"Low","Good","Very Good","Excellent"})

[nawas]

Thanks NBVC for your quick response, but it is not working, I believe it is workable by using IF, AND formula. Could you pls help me out.




Thanks

[jj72uk]

Just tested it.

Works fine!

[NBVC]

Maybe you need:

=Lookup(A1,{0,0.65,0.80,0.90},{"Low","Good","Very Good","Excellent"})

[JBeaucaire]

Hi Nawas. NBVC's formula is dead on correct approach.

If it's not working, post here the exact formula as you used it (cut and paste it directly from your worksheet)...or click GO ADVANCED and use the paperclip icon to post up your workbook so we can see why it isn't working for you.

[nawas]

But I don't know whats wrong with my sheet, when I applied the formula it showing "low" only even changing the rates..

[NBVC]

Does either of these work?


=Lookup(A1+0,{0,65,80,90},{"Low","Good","Very Good","Excellent"})

or


=Lookup(A1+0,{0,0.65,0.80,0.90},{"Low","Good","Very Good","Excellent"})

[nawas]

Sorry NBVC, its great now its working...


Thanks for your great help..

[NBVC]

Actually, I think you probably didn't see my post above...(#5).

But, if you have percentages in A1, then you need:


=Lookup(A1,{0,0.65,0.80,0.90},{"Low","Good","Very Good","Excellent"})

remember that you need to change A1 if your original is in some other cell.