How to get Blank into a cell as a result of a formula

[Guest]

I want to have a cell hold nothing (blank) based on a formula.
I can do it with an empty string, but then that is registered
as a row holding data, thus messing up pivot table results and scrolling.
Ex: =IF(ISBLANK(C35),"",FALSE).

I I do this:
=IF(ISBLANK(C35),,FALSE) it changes the value to zero.

If I do this:
=IF(ISBLANK(C35),BLANK,"Filled")
it gives me the #NAME? error.

Does anyone know how to deal with this?

 

[Dave Peterson]

Excel doesn't support this kind of "blankness".

 

[Gord Dibben]

A cell with a formula cannot return a null value.

Your "" empty string makes it look blank but that's all.


Gord Dibben MS Excel MVP