Too many arguments for the function
Solved
kardeyo
Posted messages
13
Status
Membre
-
kardeyo Posted messages 13 Status Membre -
kardeyo Posted messages 13 Status Membre -
Hello,
Here is the formula I encoded (uh I'm really a beginner, haha :p, I took over an hour to figure out how to make this formula by reading some forums):
=IF(AA20>85/100,"A",IF(AND(AA20<=84/100,AA20>=70/100),"B"),IF(AND(AA20<=69/100,AA20>=50/100),"C"),IF(AA20<=49/100,"D"))
and Excel indicates an error message "too many arguments for the function".
What I want is for Excel to indicate from the cell containing an average (AA20)
- either that for a result above 85% it is A,
- or that for a result between 84% and 70% it is B,
- or that for a result between 69% and 50% it is C
- and finally, that for a result equal to or less than 49% it is D.
Did I make a mistake?
Thank you for your help ;-)
Here is the formula I encoded (uh I'm really a beginner, haha :p, I took over an hour to figure out how to make this formula by reading some forums):
=IF(AA20>85/100,"A",IF(AND(AA20<=84/100,AA20>=70/100),"B"),IF(AND(AA20<=69/100,AA20>=50/100),"C"),IF(AA20<=49/100,"D"))
and Excel indicates an error message "too many arguments for the function".
What I want is for Excel to indicate from the cell containing an average (AA20)
- either that for a result above 85% it is A,
- or that for a result between 84% and 70% it is B,
- or that for a result between 69% and 50% it is C
- and finally, that for a result equal to or less than 49% it is D.
Did I make a mistake?
Thank you for your help ;-)
5 réponses
Hello,
Well, let's simplify your formula, it will help to read it a bit:
=IF(AA20>85%;"A";IF(AA20>70%;"B";IF(AA20>50;"C";"D")))
Otherwise, yes, you made a mistake. You closed the parentheses too early.
I will bold the parentheses to remove and underline the one to add:).
=IF(AA20>85/100;"A";IF(AND(AA20<=84/100;AA20>=70/100);"B");IF(AND(AA20<=69/100;AA20>=50/100);"C");IF(AA20<=49/100;"D"))))
Normally with this, no Excel errors
Let me know if it works for you
Well, let's simplify your formula, it will help to read it a bit:
=IF(AA20>85%;"A";IF(AA20>70%;"B";IF(AA20>50;"C";"D")))
Otherwise, yes, you made a mistake. You closed the parentheses too early.
I will bold the parentheses to remove and underline the one to add:).
=IF(AA20>85/100;"A";IF(AND(AA20<=84/100;AA20>=70/100);"B");IF(AND(AA20<=69/100;AA20>=50/100);"C");IF(AA20<=49/100;"D"))))
Normally with this, no Excel errors
Let me know if it works for you