View Single Post
  #1   Report Post  
Mike T
 
Posts: n/a
Default adding a formula in a cell but when cell = 0 cell is blank

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