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

 

[Meeko]

It is possible but I can't quite understand when you want each of the letters to appear. If i'm correct with my assumptions that it should be :

If B14 is 0 to 12 then display C
If B14 is 13 to 70 then display B
If B14 is 71 to 100 then display A

then you can use the following formula :

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

 

[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.

 

[MarcLister]

Would a VLOOKUP table not be the best solution? To get a C grade you need 50%, for example only. To get a B grade you need 65% and for A you need 80%?

 

[Meeko]

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.

So was I correct with my assmptions above then?

71 to 100 = A
13 to 70 = B
0 to 12 = C

If so, the formula in my post above will do what you need.

 

[Kerplunk]

Thanks Meeko! Superb!

 

[Meeko]

No problemo!