Cubic mm Formula Advice

[Joneye]

I've to calculate total cubic volume of a product packaging.

1) Below are all mm
2) formula used is SUM(L*W*H)
3) Question, i've never done this before so seeking advice im correct or advise me what forumla and method is better?
4) Using Mac Excel 2016 (sorry unable to paste in properly)


L W H Cubic Total
180 70 20 252000
180 100 30 540000
180 100 20 360000
180 100 15 270000
180 100 30 540000

 

[steve the fish]

You could just use L*W*H without the SUM but its still going to produce the same answer.

 

[Joneye]

You could just use L*W*H without the SUM but its still going to produce the same answer.

Thanks im looking to learn if my approach is correct as im shocking at maths.

 

[Joneye]

You could just use L*W*H without the SUM but its still going to produce the same answer.

Thanks, looking for support if my approach is correct? and my answer is right?

 

[steve the fish]

That will be cubic mm as long as all your L, W and H dimensions are also all in mm.

 

[Yongle]

If they are in adjacent columns (here A:C) then
=PRODUCT(A2:C2)

If not in adjacent columns, same formula but values separated by comma
=PRODUCT(A2,B2,C2)

 

[Joneye]

That will be cubic mm as long as all your L, W and H dimensions are also all in mm.

Yes correct all figures are in mm - assumes my approach and answer is right?

(applogies my maths is shocking - hence seeking foum advice