"IF" agruements

Copper Contributor

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")

4 Replies

@Edikita 

=IF( COUNTA(H12:M12),  IF(AND(H12="X", I12="X", J12="X",K12="X", L12="X",M12="X"), "Ready", "Missing"), "")
I like the typing

@Sergei Baklan 

Unfortunately, this formula still comes up with "Missing" when there is not data in columns H through M. Am I doing something wrong?

@Edikita 

Please check the sample

image.png

or

image.png

or

image.png

Do you actually check blank cells or empty texts "" returned by formulae as well?