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

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?

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

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



jkb_junk wrote:

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

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

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

On Tue, 9 Jan 2007 19:21:01 -0800, jkb_junk
wrote:

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?