One way:
=IF(AND(B10,A10),B1*A1,"")
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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
|