Excel help

[Kerplunk]

I am trying to do an IF statement that simpy shows from a % score either an A, B, or a C.

I have the below formula working but it only works with A and B. If i add C at the end i get " Too many arguments error" Is it not possible to do this?

=IF(AND(B14<101,B14>71,B14>12),"A","B" ) Works

=IF(AND(B14<101,B14>71,B14>12),"A","B","C" ) Doesnt Work

 

[Kerplunk]

Basically its a scoring system, enter numbers in a box then it creates a percentage score, then below that I want either an A grade, B grade, or C grade to appear below.

 

[Kerplunk]

Thanks Meeko! Superb!