IF Statement - too many arguments - Excel 2010

[cspruill]

I am working with a teacher to create a gradebook spreadsheet and this is the formula for the cell that calculates the grade :

=IF(SUM(G48*0.1)+(H48*0.15)+(I48*0.15)+(J48*0.1)+(K48*0.5)>0,IF(B5>=93,"A",IF(B5>=90,"A-",IF(B5>=87,"B+",IF(B5>=83,"B",IF(B5>=80,"B-",IF(B5>=77,"C+",IF(B5>=73,"C",IF(B5>=70,"C-",IF(B5>=67,"D+",IF(B5>=64,"D-",IF(B5<64,"E")))))))))),"")

When I try to enter this formula, I am getting the message that I have entered too many arguments. Does anyone know how I can tweak this formula to allow for all of the arugments, or a similiar formula that will do the same thing?

[NBVC]

Try:

=IF(SUM(G48*0.1,H48*0.15,I48*0.15,J48*0.1,K48*0.5)>0,LOOKUP(B5,{0,64,67,70,73,77,80,83,87,90,93},{"E","D-","D+","C-","C","C+","B-","B","B+","A-","A"}),"")

not sure if you are missing "D" and "A+"??

[NBVC]

Try:

=IF(SUM(G48*0.1,H48*0.15,I48*0.15,J48*0.1,K48*0.5)>0,LOOKUP(B5,{0,64,67,70,73,77,80,83,87,90,93},{"E","D-","D+","C-","C","C+","B-","B","B+","A-","A"}),"")

not sure if you are missing "D" and "A+"??

[cspruill]

Perfect - thank you so much!! No, there is no A+, or D- (Strange, I know.) Thanks again!!