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?