zeros in cells with formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when I enter a formula in a cell it displays a 0, when there is not an answer to the formula. Is there a way to keep the formula but get rid of the zeros

any help is greatly apperciated!

Thanks,
Darrell
 
Hi Darrel,

You can do this using the numeric picture switch, eg:
{SUM(ABOVE) \# 0;-0;}
Numeric picture switches take three parameters: +ve value display, -ve value
display and 0 value display, each separated by a semi-colon, in that order.
The above example hides 0 values because there is nothing after the second
semi-colon.

Cheers


Darrell said:
when I enter a formula in a cell it displays a 0, when there is not an
Click to expand...
answer to the formula. Is there a way to keep the formula but get rid of
the zeros?
 
Back
Top