Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

excel formula

  1. miamialley

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

    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...
Top Bottom
Back