Try
=if(A1*B1=0,"",A1*B1)

"Mike T" wrote:

I am trying to create an invoice so when I put qty in cell A1 and the $ value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula
running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00
appearing in each cell, My question is how can I use this formula or
something simular to get same answer to show a blank cell when not used
--
Thanks Mike T