Mulitplication Formula

**reelnsnook** · 04-21-2011, 04:21 PM

Hello all....I am creating a formula to multiply Length * Width * Height each category would have its own cell. I will not always be entering all measurements so the problem I am having is that if I only enter two measurements one is always zero so when excel multiplies the formula the sum is always zero. I would like all of the cells to equal 1 unless the amount is greater. I have messed around with several formulas with no luck. Could someone please help me. Thanks in advance.

**TMS** · 04-21-2011, 04:25 PM

One way:

=IF(A1="",1,A1)*IF(B1="",1,B1)*IF(C1="",1,C1)

Regards

**reelnsnook** · 04-21-2011, 04:27 PM

Thanks I will give it a try.

**daddylonglegs** · 04-21-2011, 04:28 PM

PRODUCT function will ignore blanks....so try either

=PRODUCT(A1:C1)

or if the cells don't form one contiguous range

=PRODUCT(A1,C1,E1)

**TMS** · 04-21-2011, 04:38 PM

Daddylonglegs solution is neater than mine, a lot less typing, but you will get a zero value if all the cells are empty whereas, with mine, you'll get one (1). Zero might be preferable depending on what you need.

Regards

**reelnsnook** · 04-21-2011, 04:39 PM

That did the trick, but what I forgot to mention is there is another cell that that has the totals of the three ( length * width * Height) and is now giving me the sum of one as well I need that cell to be set at zero.

**reelnsnook** · 04-21-2011, 04:43 PM

Thanks guys "=product" seems to solve that problem

**TMS** · 04-21-2011, 04:45 PM

Edit: posts crossed - ignore

Sorry, that's lost on me. What formulae do you have in what cells?

Probably easiest to upload a sample workbook so we don't go round the houses.

Regards