Welcome Guest.


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

Asked by: Kimberly Edwards 211 views IT March 29, 2019

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

2 Answers

  1. +3Votes  

    That’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 ",&quot Failed "))

    The effect is as follows:

    Joyce Cook- March 29, 2019 |

  2. +4Votes  

     Remove 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 |