math; How do I multiply a row of numbers quickly?

E

Emily

How do I multiply a row of numbers quickly? I need to calculate how many
cubic inches there are for a given shipping box size.
In A1 I’ve entered the shipping box code; irrelevant to the calculation. In
B1 I’ve entered the box height, in C1 I’ve entered the box width, in D1 I’ve
entered the box length. How do I multiply B1, C1, D1 to find how many cubic
inches this shipping box is and have the answer appear in E1?
I need to calculate this for 10 shipping boxes; A1 through A10.
Thank you,
Emily
 
E

Emily

Thank you Toppers,
Could you please provide a little more detail of the steps to follow?
Again, thank you,
Emily
 
T

Toppers

In E1 put the formula I gave (=B1*C1*D1) (no brackets)

Select E1 and place the cursor on the square at the bottom right of the
highlighted cell. The cursor will change to a black cross. Hold down left
mouse button and drag for as many rows (10) as required.

HTH
 
E

Emily

Thank you Topper. It worked.
Emily;)

Toppers said:
In E1 put the formula I gave (=B1*C1*D1) (no brackets)

Select E1 and place the cursor on the square at the bottom right of the
highlighted cell. The cursor will change to a black cross. Hold down left
mouse button and drag for as many rows (10) as required.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top