Currently Being ModeratedOct 28, 2012 3:47 PM (in response to clifffromfarmington)
One way is to use conditional formatting to set the text color to the same as the background when the value is "0.00":
To apply conditional formatting select the target cells, then open the Conditional Formatting Tool by selecting the menu item "Format > Show Conditional Format Rules".
The other way is to place the math operation in an if() statement as follows:
G3=IF(F3*A3=0, "", F3*A3)
select G3 and fill down as needed