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