CSmith12

Brilliant - thank you for your help and speedy response!

Thank you! Next one... Can I put more than one grade in there? So 0-8 = U and 9-15 = Pass?

Hi all, Hopefully posting in the right place, and not repeating previous posts (I have had a browse, but, may have missed it - apologies if so!). Trying to create a tracker for a BTEC subject - simply put, I want to input a grade, and if the grade is between a certain set of numbers (0-8, for example), I want Excel to either change the number to a piece of text (in this example, 'U'), or, input the 0-8 number, then in the next cell, it equals U. If that makes sense? I have tried many googles but not sure I'm asking the right thing as I'm not getting any usable answers so hoping you guys can help! Thanks! In hope, C.

Hi! Mirfield - fancy that!

Hi all, Been visiting these forums for a few months and thought I'd sign up as it seems a great place to share/gain knowledge (more gaining than sharing on my part, but, you never know). Found a lot of solutions to my SIMS problems on here (thank you everyone). I work in a secondary school in West Yorkshire. 'Just' admin but use SIMS a lot, started to delve into the more advanced reporting and found I really enjoyed it (Excel and Macros, wowee!), so found a fair few questions have arisen (unlucky, folks!). C