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