2Answers

# Excel, you input too many parameters for this function, how to solve

Asked by: Kimberly Edwards 211 views IT

=IF(C2>=60,"pass ","failed",IF (C2>84,"excellent","pass "))

Welcome Guest.

2Answers
# Excel, you input too many parameters for this function, how to solve

Asked by: Kimberly Edwards 211 views IT

=IF(C2>=60,"pass ","failed",IF (C2>84,"excellent","pass "))

+3

VotesThat’s because your formula is set incorrectly!

According to your meaning, the formula should be changed to:

=IF(C2>84,"excellent",IF(C2>=60,"pass "," Failed "))

The effect is as follows:

Joyce Cook- March 29, 2019 |

+4

VotesRemove it, change =IF(C2>=60,"pass ",IF(C2>84,"excellent","pass "))

There is no prompt for “too many parameters”, but the result is incorrect.

John Walker- March 29, 2019 |