Hide $0.00

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

Guest

I am using Excel 2007.
I am using the following formula to calculate the total cost based on 2 cells:
The formula is in Cell "F3" and is entered as this =B3*C3

How can I keep it from displaying $0.00 when the fields are empty?
 
Hi J,

An alternate solution which might be considered is to suppress the display
of zero on the sheet. In that case you hide all 0's from view or printing
but they still remain in the cell. This effects the entire sheet on which
you apply it.

Choose File (Office Button), Excel Options, Advanced, Display options for
this worksheet, and uncheck "Show zero in cells that have zero value."
 
Or just a custom format like

$#,##0.00;-$#,##0.00;

That way the OP can suppress the display of zeros where he/she wants it only
and not in the whole workbook
 
And in the spirit of "there are more ways to kill a pig than stuffing it
with butter":
Use conditional formatting such that if value is zero, then font color
matched cell background and hence is invisible.
But I prefer Peo's answer!
best wishes
 
The easiest IMHO is a simple formula:

=IF(B3*C3,B3*C3,"")

Kills 2 birds with one stone.<g>
 
Back
Top