Thread: Hide $0.00
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j j is offline
external usenet poster
 
Posts: 128
Default 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?