grading on my worksheet

hi

i am trying to setup a way for my spreadsheet to automatically input grades into a column next to were a students mark is

I have there marks in cells within column N and would like there respective grades to appear within column O

The grade boundries are U = 0-19, D = 20-34, C = 35-49, B = 50-64, A = 65-79 and A* = 80-100

How can i get the spreadsheet to automatically fill in the grades given the mark in the previous column

Hi there,

There's probably a simpler way, but you can use this formula from cell O1 (change the starting cell as required) and copy down as required:

=IF(N1<=19,"U",IF(AND(N1>=20,N1<=34),"D",IF(AND(N1>=35,N1<=49),"C",IF(AND(N1>=50,N1<=64),"B",IF(AND(N1>=65,N1<=79),"A","A*")))))

HTH

Robert

superb Robert, thanks very much