Hey folks,

If I enter in cell A1, If(criteria,"",""), as I understand it, should return a blank value. If I then test that cell for a blank value using Isblank(A1), I am for some reason receiving a "false" output.

It is as if Isblank() cannot detect that cells which If() has left blank are blank. Isblank() appears to be confused by the presence of a formula in the cell, leading it to return a conclusion that the cell is not blank.

Anyone know a way to work around this?

Thanks in advance