FORMATTING CELLS

S

sniper2328

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

Dave Peterson

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.
 
Top