"IF" agruements

%3CLINGO-SUB%20id%3D%22lingo-sub-2789067%22%20slang%3D%22en-US%22%3E%26amp%3Bquot%3BIF%26amp%3Bquot%3B%20agruements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789067%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20writing%20formula%20in%20excel%20so%20I%20am%20not%20sure%20who%20to%20ask%20to%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EDate%20is%20found%20in%20columns%20H%20through%20M%2C%20the%20formula%20reflects%20what%20I%20need%20to%20find%20out%20once%20data%20is%20there.%20My%20issue%20is%20applying%20the%20formula%20in%20column%20N%20but%20it%20staying%20blank%20if%20there%20is%20no%20data.%3C%2FP%3E%3CP%3E%3DIF((AND(H12%3D%22X%22%2C%20I12%3D%22X%22%2C%20J12%3D%22X%22%2CK12%3D%22X%22%2C%20L12%3D%22X%22%2CM12%3D%22X%22))%2C%20%22Ready%22%2C%20%22Missing%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2789067%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2789110%22%20slang%3D%22en-US%22%3ERe%3A%20%26amp%3Bquot%3BIF%26amp%3Bquot%3B%20agruements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1167954%22%20target%3D%22_blank%22%3E%40Edikita%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(%20COUNTA(H12%3AM12)%2C%20%20IF(AND(H12%3D%22X%22%2C%20I12%3D%22X%22%2C%20J12%3D%22X%22%2CK12%3D%22X%22%2C%20L12%3D%22X%22%2CM12%3D%22X%22)%2C%20%22Ready%22%2C%20%22Missing%22)%2C%20%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New 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?