Forum Discussion

RichardGoldberg's avatar
RichardGoldberg
Copper Contributor
Sep 23, 2024
Solved

Error: "You've entered too many argument for this function"

Hi - i'm receiving this error when completing this excel formula. I can't determine why though. Can you please assist? The goal of this formula is to determine if the cells are blank or filled in and...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 23, 2024

    RichardGoldberg 

    The two values for Y2 are the same: "7. > 24 months". Was that a typo?

    Apart from that, I think you want

    =IF(J2="Closed", "Closed", IF(OR(Y2="7. > 24 months", Y2="7. > 24 months"), "", IF(AND(COUNTBLANK(K2:W2)=0, COUNTBLANK(AA2:AD2)=0), "Completed", IF(AND(COUNTBLANK(K2:W2)>0, COUNTBLANK(AA2:AD2)>0), "Not Completed", "Partially Completed"))))

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 23, 2024

RichardGoldberg 

As a comment, with such formulae it's easier to work in multiline mode

=IF( J2="Closed",
     "Closed",
 IF( OR(Y2="7. > 24 months", Y2="7. > 24 months"),
     "",
 IF( AND(COUNTBLANK(K2:W2)=0, COUNTBLANK(AA2:AD2)=0),
    "Completed",
 IF( AND(COUNTBLANK(K2:W2)>0, COUNTBLANK(AA2:AD2)>0),
    "Not Completed",
    "Partially Completed"
))))