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

Custom format the formula cell as e.g.,

[=0]"";General