Too Many Arguments
I'm working on a gradebook and doing letter grades. The numbers are percentages. It says too many arguments and I am getting errors. HELP
=IF(P6<60,"F",IF<65.49,"D",IF<69.49,"D+",IF<73.49,"C-",IF<76.49,"C",IF<79.49,"C+",IF<83.49,"B-",IF<86.49,"B",IF<89.49,"A-",IF>=95,"A")
Last edited by Allisongw; 01-19-2015 at 06:46 PM.
Hi!
You're missing the (P6 for each additional If Statement also if you want everything >89.49 and <100 to = A you'll need to change the last statement to what's below "p6<=100"A"). Since excel reads the arguments in order you don't risk a 66 being counted as an A.
=IF(P6<60,"F",IF(P6<65.49,"D",IF(P6<69.49,"D+",IF(P6<73.49,"C-",IF(P6<76.49,"C",IF(P6<79.49,"C+",IF(P6<83.49,"B-",IF(P6<86.49,"B",IF(P6<89.49,"A-",IF(P6<=100,"A"))))))))))
Please let me know if that works for you.
Thank you! That fixed the arguments, now all grades, even if 100% are showing up as an FIS there something else I messed up in the formula?
Grade book example.xlsxDid you copy and paste my formula? It works in my test (see attached.)
Another way:
=LOOKUP(P6, {0,65.5,69.5,73.5,76.5,79.5,86.5,89.5,95}, {"F","D","D+","C-","C","B-","B","A-","A"})
Entia non sunt multiplicanda sine necessitate
Since it's a percent, do I need to move the decimal point on the formula? Could that be why it is registering all as an F?
YES THAT WORKED MOVING THE DECIMALS! Thank you so much for all of your help
Please don't forget to star me if I helped with the solution! :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks