# Help with a formula

#### JoolzJJ

##### New Member
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")))))))

Thank you

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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"}),"")

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

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

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"}),"")

Worked a treat...thank you so much

That's great thank you!

Replies
7
Views
328
Replies
5
Views
171
Replies
1
Views
233
Replies
3
Views
521
Replies
4
Views
1K

1,196,408
Messages
6,015,102
Members
441,870
Latest member
kojack

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back