Forum Discussion
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...
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"))))
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"))))
yes that was a typo. thanks for catching that. This works perfectly! thanks a lot!