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.
Bookmarks