Help with a formula

[JoolzJJ]

Hi hope someone can help me.

I want to be able to use a formula to say if a cell is less than 60% then it is "Well Below Average" and if it is between 61% and 75% then it is "Below Average" and if it is between 76% and 80% it is "Average" and if it is between 81% and 85% it is "Average" and if it is between 86% and 90% it is "Above Average" and if it is greater than 91% it is "Well Above Average"

This is just one I have tried but it doesn't work

=IF(D5="Average Score",IF(D5<60%,(D5*"Well Below Average"),IF(AND(D5>60%,D5<76%),(D5*"Below Average"),IF(AND(D5>75%,D5<81%),(D5*"Average"),IF(AND(D5>80%,D5<86%),(D5*"Average"),IF(AND(D5>85%,D5<91%),(D5*"Above Average),IF(AND(D3>90%),(D3*""AboveAverage")))))))

Please help I am tearing my hair out!!

Thank you

 

[Mike LH]

Hi,

Does this do what you need?


=IF(A1<>"",LOOKUP(A1,{0,0.61,0.76,0.81,0.86,0.91},{"Well below average","Below avearage","Average","Average","Above average","Well above average"}),"")

 

[igold]

Does this works for you...

=IF(D5<60%,"WELL BELOW AVERAGE",IF(AND(D5>=61%,D5<=75%),"BELOW AVERAGE",IF(AND(D5>=76%,D5<=80%),"AVERAGE",IF(AND(D5>=81%,D5<=85%),"AVERAGE",IF(AND(D5>=86%,D5<=91%),"ABOVE AVERAGE","WELL ABOVE AVERAGE")))))

igold

 

[igold]

Also, 91% is sort of in a gray area...

 

[JoolzJJ]

Worked a treat...thank you so much

Hi,

Does this do what you need?


=IF(A1<>"",LOOKUP(A1,{0,0.61,0.76,0.81,0.86,0.91},{"Well below average","Below avearage","Average","Average","Above average","Well above average"}),"")

 

[JoolzJJ]

Worked a treat...thank you so much

 

[JoolzJJ]

That's great thank you!