I am multiplying one cell (called Quantity) by second cell (Price each) to get Total (the formula cell). If "Price each" cell is blank, the "Total" cell is the "Price each",not zero. In another word, the blank cell should be zero, not one.
If blank, I want the cell value to be "0" not "1".
If blank, I want the cell value to be "0" not "1".