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

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 Ive entered the shipping box code; irrelevant to the calculation. In
B1 Ive entered the box height, in C1 Ive entered the box width, in D1 Ive
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

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

=B1*C1*D1

Copy down to E10

"Emily" wrote:

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 Ive entered the shipping box code; irrelevant to the calculation. In
B1 Ive entered the box height, in C1 Ive entered the box width, in D1 Ive
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

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

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


"Toppers" wrote:

=B1*C1*D1

Copy down to E10

"Emily" wrote:

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 Ive entered the shipping box code; irrelevant to the calculation. In
B1 Ive entered the box height, in C1 Ive entered the box width, in D1 Ive
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

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

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


"Emily" wrote:

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


"Toppers" wrote:

=B1*C1*D1

Copy down to E10

"Emily" wrote:

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 Ive entered the shipping box code; irrelevant to the calculation. In
B1 Ive entered the box height, in C1 Ive entered the box width, in D1 Ive
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

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

Thank you Topper. It worked.
Emily;)

"Toppers" wrote:

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


"Emily" wrote:

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


"Toppers" wrote:

=B1*C1*D1

Copy down to E10

"Emily" wrote:

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 Ive entered the shipping box code; irrelevant to the calculation. In
B1 Ive entered the box height, in C1 Ive entered the box width, in D1 Ive
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