FORMATTING CELLS
 

I'm trying to figure out how to leave a cell with a function blank if the
returned value is 0

FORMATTING CELLS
 

You can't leave the cell empty if it's 0, but you could hide it with formatting
or change the formula so the cell looks empty.

=if(yourformula=0,"",yourformula)

or

Format|conditional formatting
cell value is equal to 0
and give it the same font color as fill color (white on white)

Or

Format|cells|number tab|custom category:
0;-0;;@

Positive;negative;0;text
is what each of those element represents.

sniper2328 wrote:

I'm trying to figure out how to leave a cell with a function blank if the
returned value is 0

--

Dave Peterson

FORMATTING CELLS
 

Like this:

=IF(your_formula=0,"",your_formula)

Hope this helps.

Pete

On Jan 10, 2:13*am, sniper2328
wrote:
I'm trying to figure out how to leave a cell with a function blank if the
returned value is 0