View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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