Excel: Fill D1 with 'Incomplete' if data is entered in A1 and either or both B1 and C2 are blank
You may also try the formula =IF(A1="","",IF(OR(B1="",C1=""),"Incomplete","")).
Excel: Fill D1 with 'Incomplete' if data is entered in A1 and either or both B1 and C2 are blank
You may also try the formula =IF(A1="","",IF(OR(B1="",C1=""),"Incomplete","")).