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?
|