I'm trying to create a grades list in Numbers. I've managed to work out the formulas for the other columns (marks out of X from 2 different exams; percentages etc), but I would like to finish it off with the grade that they have received.
Basically, I would like my last column to use one of the following four letters: F, P, M, D (Fail, Pass, Merit, Distinction) based on the overall percentage column.
So, if a student has scored less than 40% it's a Fail, between 40% and 60% It's a Pass, between 60% and 80% it's a Merit, and over 80% it's a distinction.
Sadly I have no real training/understanding of Excel (that I can remember anyway) and so don't really know where to start beyond "=IF".
Any ideas?
Basically, I would like my last column to use one of the following four letters: F, P, M, D (Fail, Pass, Merit, Distinction) based on the overall percentage column.
So, if a student has scored less than 40% it's a Fail, between 40% and 60% It's a Pass, between 60% and 80% it's a Merit, and over 80% it's a distinction.
Sadly I have no real training/understanding of Excel (that I can remember anyway) and so don't really know where to start beyond "=IF".
Any ideas?