A formula resulting in a REAL blank

[Jeffrey Mahoney]

This seems so fundamental and I feel silly posting it. I like seeing zero results as blank because it doesn't clutter the field and is easier to see.

As you all know a formula in a cell resulting in a Null or double quote cannot be used in math. I call that a pseudo blank cell.
like: Cell B1 =If(A1=0,"",A1) [if A1 is zero, the result would be null]

If I then use cell B1 to add some cells I get #VALUE. Or I can create a formula like =Sum(B1)+C2+D4. I forget that I have to do that.

A true blank cell returns zero

Is there a function that can actually return a value that mimics a blank cell?

 

[Fluff]

Nope, fraid not. However if you don't want to see zeros in cells your could use a custom cell format, or just hide zeros in the advanced options.

 

[Jeffrey Mahoney]

Nope, fraid not. However if you don't want to see zeros in cells your could use a custom cell format, or just hide zeros in the advanced options.

Thank you Fluff. The other reason for not wanting zeros is that it fouls averages.

 

[Fluff]

Glad to help & thanks for the feedback.