Can anyone one help with if conditional formula

[Bahaa]

I need an IF condition formula for the following multiple criteria

Very Weak below 30%
Weak 30% - 49.9 %
Average 50% - 69.9 %
Good 70% - 89.9%
Excellent above 90%

Thanks

 

[Joe4]

If your amount was in cell A1, use:
=LOOKUP(A1,{0,0.3,0.5,0.7,0.9},{"Very Weak","Weak","Average","Good","Excellent"})

 

[Bahaa]

If your amount was in cell A1, use:
=LOOKUP(A1,{0,0.3,0.5,0.7,0.9},{"Very Weak","Weak","Average","Good","Excellent"})

Thank you for the reply but what i need is that if cell O21 was less than 30% then very weak if between 50 -49.9 then weak and if between 50% - 69.9 % then Average and between 70% - 89.9% then Good and if above 90% then Excellent

 

[Joe4]

Thank you for the reply but what i need is that if cell O21 was less than 30% then very weak if between 50 -49.9 then weak and if between 50% - 69.9 % then Average and between 70% - 89.9% then Good and if above 90% then Excellent

That is exactly what the formula does. Just put "O21" in where "A1" is.
=LOOKUP(O21,{0,0.3,0.5,0.7,0.9},{"Very Weak","Weak","Average","Good","Excellent"})