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

J

jkb_junk

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?
 
G

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
 
Top