Hey guys, in a nutshell, I work in a School, and I need excel to return a TRUE statement, if a student is getting an A*-C grade in a particular given subject.

The grades we use here are
A*
A
B
C3
C2
C1
Pass
Merit
Distinction
Distinction*
All other grades would show FALSE.

I thought the easiest way to do this would be to use a Nested IF formula with 10 arguments. I got this far with it, and it was working fine, but as I try and increase the amount of statements that it searches for, I keep returning an error.

=IF(A2="A*","True",IF(A2="A","True"))

One I have all the IF statements working, the plan is to do simple countIF's and easily work out which students are due to get the golden number of exam passes.

If any one can enlighten me on how I can get this working easily, It would be massively appreciated!