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”)
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”) Read More
