Dynamic Range

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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.
 
B1 contains a formula... deleting it is the only want to make a real blank
cell. ISBLANK will only return true for an empty cell.
Instead of ISBLANK(B1), try =IF(B1="",TRUE, FALSE)
 
Back
Top