Say unit cost in Column D, and quantity in Column E, try something like
this:

=If(Or(D2="",E2=""),"",D2*E2)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kate_suzanne" wrote in message
...
I have a feeling that this is a simple thing...yet I have spent too much
time
already trying to figure out this "simple" thing.

I have a simple purchase order document set up in Excel 2007. I have a
formula in the total cost column that essentially multiples the quantity
by
the unit cost. I would like the total cost cell for each item to appear
blank (yet not remove the formula) if there is nothing entered into the
cell
for that particular row; however, now, if there is no quantity or unit
price
entered, the result shows as "0.00." How do I change that view...I can't
get
those zeros to disappear without deleting the formula as well.

Thanks!