Making a Cell Blank

Hello,

I have come across a problem with IFs.

=IF(B4="hello","","Is it not hello")

How can I make the cell contain nothing, because I think "" is still classed as something and

ISBLANK()

will return FALSE if that cell is tested.

So is there something I can put in the IF statement to say "leave this cell completely empty"?

Hi,

=ISBLANK() will of necessity return FALSE since there is something in B4, i.e. a formula.

Xl clearly regards a formula which returns "" (double quotes) as being Text, since the =ISTEXT(B4) returns TRUE, whilst =ISNUMBER(B4) returns false.

Interestingly though, if you get VBA to populate the cell with double quotes:

Please Login or Register  to view this content.

it does return the null value you're after. It seems the proverbial sledgehammer/nut solution, but about the only thing I can suggest is have B4 be the subject of a Worksheet_SelectionChange event and put Your IF test in there.

HTH

Thanks for that

just out of interest why do you need a truly empty cell?

I just wondered if there was a way to get it completely blank rather than making it a string with no contents.