Hi,
Cell A1=7
Cell B1=IF(A1=7,"","Not 7")
Under these conditions, Cell B1 is blank.
But apparently it's not really blank.
If I make C1= ISBLANK(B1), C1 returns FALSE.
If "" doesn't give a real blank cell, what does?
Regards - Dave.