Forum Discussion
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 return "completed" "partially completed" or "not completed" And if column J is closed then return closed.
Also, if column Y has the below two text than X can remain blank. if they dont contain that text, column X needs to be filled in.
=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","Partially Completed"),"Not 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"))))
3 Replies
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" ))))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!
