Hi guys, I would appreciate if I could get some help with excel 2007. I need to design a spreadsheet which is used to calculate student grades. So say column A would have a range of numbers between 0 and 100 representing a mark achieved by a student. I would like to find a way to use a formula so that it is able to show a grade in Column B.
So for example is for someone achieves a 53 that would be a D.
Of course I’d like it so I could specify data ranges i.e anyone achieving a mark between say 40 and 55 would be recognised as having achieved a D and have that placed in column b by their mark.