I am looking for something that will allow the following:

If the score in cell AL9 equals a certain percentage then cell AM9 equals:

0%-70% then score 1
70%-85% then score 2
85%-100% then score 3
100%-110% then score 4
100%+ then score 5

Any ideas?

I tried this formulae in AM9: =IF(AL9>=85.5%,3,IF(AL9<=75%,1,IF(AL9>=75.01%,2,if(AL9>100%,4,if(AL9>110%,5))))) but it didn't work.