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
|