Try this:
=IF(D5*E5,D5*E5,"")
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Dave O." wrote in message
...
In F5 i have the formula SUM(D5*E5) the cell is formatted for currency.
When
i drag my formula it creates in every cell $0.00 this is affecting my
average at the bottom. How do i keep the formula but loose the $0.00?
Thank you for your help!
|