1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

IT/Spreadsheet help

Discussion in 'Heads of department' started by drinewinker, Sep 2, 2017.

  1. drinewinker

    drinewinker New commenter

    I'm pulling my hair out at the moment...

    My school wants student data as national curriculum levels, GCSE grades and entry level 3, level 1 etc. I'm trying to make my spreadsheet automatically display the correct corresponding levels dependent on what national curriculum level I enter. Is there a way to do this? I'm trying to use the IF function but not having any luck.

    I'd really appreciate any help, thanks in advance.
     
  2. wanet

    wanet Star commenter

    IF will do it , but not the best way - use a LOOKUP function, e.g. VLOOKUP. Create a table with the lookup grade and the grade that you want next to it, then use LOOKUP to find the new grade.
     
  3. drinewinker

    drinewinker New commenter

    Thank you. I'll look into that.
     

Share This Page