Excel formula help. How to not compute a formula if a cell in the formula is blank

[miamialley]

The formula for cells in column M is =IF(LS>K2, "Noncompliant","Compliant")

This populates a "Compliant" in all cells in the column, if L2 is blank. If L2 is blank, I want the formula to not compute and I want the cell in column M to just be blank. Make sense? I have viewed countless videos and nothing works. How can I achieve this?

 

[D.T.]

You just need a nestled IF/ELSE type construct:


=IF(ISBLANK(L2), "", IF(L2>K2, "Noncompliant","Compliant"))


Read as: If L2 is blank, then this cell is set to "" (empty), else if L2 > K2, then set it to "Noncompliant", else it to "Compliant"

🙂

 

[miamialley]

You just need a nestled IF/ELSE type construct:


=IF(ISBLANK(L2), "", IF(L2>K2, "Noncompliant","Compliant"))


Read as: If L2 is blank, then this cell is set to "" (empty), else if L2 > K2, then set it to "Noncompliant", else it to "Compliant"

🙂

Wow. Do you know how many times I tried that...multiple IFS and the IF(ISBLANK)? I kept getting prompted that I had too many functions or something. I put it in the way you wrote it and it works perfectly! Thanks so much.