multiplying by blank cell

[timjimbob]

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".

 

[Ron Coderre]

If blank, I want the cell value to be "0" not "1".

Typically, the returned product of a number and a blank *would* be 0.
Can you post the formula you're using?

 

[c_m]

also check on the format of the cell that you think is empty

 

[timjimbob]

=product(d28,e28)

 

[timjimbob]

tried different cell "NUMBERS", didn't change

 

[schielrn]

For the function Product it ignores empty cells. So I would use something like:

=D28*E28

and not product. This is an excerpt fropm Excel help:

Remarks

• Arguments that are numbers, logical values, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers cause errors.
• If an argument is an array or reference, only numbers in the array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.

Hope that helps.

 

[timjimbob]

That fixed it, but I guess I don't get it.Thanks