One way:

=IF(AND(B1>0,A1>0),B1*A1,"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Mike T" <MikeT@discussions.microsoft.com> wrote in message
news:258B1BD2-41F6-49A6-AF49-A964CA0537FF@microsoft.com...
> 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