multiplying by blank cell

timjimbob

New Member
Joined
Apr 27, 2007
Messages
38
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".
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

c_m

Well-known Member
Joined
May 29, 2008
Messages
836
also check on the format of the cell that you think is empty
 

timjimbob

New Member
Joined
Apr 27, 2007
Messages
38

ADVERTISEMENT

tried different cell "NUMBERS", didn't change
 

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,939
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,575
Members
414,390
Latest member
plimbu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top