Hide $0.00
 

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?

Hide $0.00
 

Try one of these:

=IF(COUNT(B3,C3)<2,"",B3*C3)

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


--
Biff
Microsoft Excel MVP


"J" wrote in message
...
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?

Hide $0.00
 

I tried the first one and it works perfect.
Thanks.

"T. Valko" wrote:

Try one of these:

=IF(COUNT(B3,C3)<2,"",B3*C3)

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


--
Biff
Microsoft Excel MVP


"J" wrote in message
...
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?

Hide $0.00
 

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

Cheers,
Shane Devenshire


"J" wrote:

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?

Hide $0.00
 

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


--

Regards,

Peo Sjoblom

"ShaneDevenshire" wrote in
message ...
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."
--

Cheers,
Shane Devenshire


"J" wrote:

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?

Hide $0.00
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"J" wrote in message
...
I tried the first one and it works perfect.
Thanks.

"T. Valko" wrote:

Try one of these:

=IF(COUNT(B3,C3)<2,"",B3*C3)

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


--
Biff
Microsoft Excel MVP


"J" wrote in message
...
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?

Hide $0.00
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Peo Sjoblom" wrote in message
...
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


--

Regards,

Peo Sjoblom

"ShaneDevenshire" wrote in
message ...
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."
--

Cheers,
Shane Devenshire


"J" wrote:

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?

Hide $0.00
 

The easiest IMHO is a simple formula:

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

Kills 2 birds with one stone.<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Peo Sjoblom" wrote in message
...
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


--

Regards,

Peo Sjoblom

"ShaneDevenshire" wrote in
message ...
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."
--

Cheers,
Shane Devenshire


"J" wrote:

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?