View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Cell formulas display "0" (zero's)

Maybe this:

=IF(Z3+A4<0,Z3+A4,"")

Regards,
Per

"Lenny" skrev i meddelelsen
...
How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want
to
have to make the entries white to hide them. There's gotta be a way to
not
show this value.

My thanks

Lenny