Sep 27 2021 09:41 AM
I am new to writing formula in excel so I am not sure who to ask to help.
Date is found in columns H through M, the formula reflects what I need to find out once data is there. My issue is applying the formula in column N but it staying blank if there is no data.
=IF((AND(H12="X", I12="X", J12="X",K12="X", L12="X",M12="X")), "Ready", "Missing")
Sep 27 2021 09:54 AM
=IF( COUNTA(H12:M12), IF(AND(H12="X", I12="X", J12="X",K12="X", L12="X",M12="X"), "Ready", "Missing"), "")
Sep 27 2021 11:04 AM
Unfortunately, this formula still comes up with "Missing" when there is not data in columns H through M. Am I doing something wrong?
Sep 27 2021 01:10 PM
Please check the sample
or
or
Do you actually check blank cells or empty texts "" returned by formulae as well?