Editing formula results so zeros appear blank
 

Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

Editing formula results so zeros appear blank
 

=if(yourformula=0,"",yourformula)
is pretty common



Holly wrote:

Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

--

Dave Peterson

Editing formula results so zeros appear blank
 

2 thoughts:

a. Switch off zeros display in the sheet via clicking:
Tools Options View tab Uncheck Zero values OK

b. Use something like this: =IF(yourformula=0,"",yourformula)

(a) gives a neat uncluttered look, easy to apply & retains the underlying
zero values
(b) converts the formula returns of zeros to null strings: "", which appear
"blank"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Holly" wrote:
Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

Editing formula results so zeros appear blank
 

One trick is to allow the formula to return a zero, but "hide" it by
means of conditional formatting on that cell - if the cell content is
zero then print with a white foreground (which on a white background
will not show).

Hope this helps.

Pete

On Jan 15, 12:55*am, Holly wrote:
Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

Editing formula results so zeros appear blank
 

Thankyou
--
Cheers,
Holly


"Max" wrote:

2 thoughts:

a. Switch off zeros display in the sheet via clicking:
Tools Options View tab Uncheck Zero values OK

b. Use something like this: =IF(yourformula=0,"",yourformula)

(a) gives a neat uncluttered look, easy to apply & retains the underlying
zero values
(b) converts the formula returns of zeros to null strings: "", which appear
"blank"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Holly" wrote:
Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

Editing formula results so zeros appear blank
 

welcome, Holly.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Holly" wrote in message
...
Thankyou
--
Cheers,
Holly

Editing formula results so zeros appear blank
 

I have a similar problem as this but want to return an actual blank cell not
an empty string (""). Any ideas?

"Pete_UK" wrote:

One trick is to allow the formula to return a zero, but "hide" it by
means of conditional formatting on that cell - if the cell content is
zero then print with a white foreground (which on a white background
will not show).

Hope this helps.

Pete

On Jan 15, 12:55 am, Holly wrote:
Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

Editing formula results so zeros appear blank
 

If a cell has a formula all it can do is display a value from that formula
There is no way the formula can delete itself.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Brian" wrote in message
...
I have a similar problem as this but want to return an actual blank cell
not
an empty string (""). Any ideas?

"Pete_UK" wrote:

One trick is to allow the formula to return a zero, but "hide" it by
means of conditional formatting on that cell - if the cell content is
zero then print with a white foreground (which on a white background
will not show).

Hope this helps.

Pete

On Jan 15, 12:55 am, Holly wrote:
Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly