=IF(AND(A1<"",B1<""),B1*A1,"")

--
HTH

Bob Phillips

"Mike T" wrote in message
...
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