IF Statement in Numbers regarding four different outcomes

Discussion in 'Mac Basics and Help' started by Sam1487, Nov 23, 2010.

  1. Sam1487 macrumors member

    Sam1487

    Joined:
    Jan 18, 2009
    Location:
    Between Nottingham & Derby, UK
    #1
    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?
     
  2. Tumbleweed666 macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #2
    I think vlookup might be a better place to start
     

Share This Page