MrExcel Publishing
Your One Stop for Excel Tips & Solutions

multiplying two colums


Posted by jeff on January 21, 2002 5:39 AM

I have column B, which has 463 cells running down the page, I need to divide each cell by .50 and show the total. I can do on cell at a time =(B1/.50), but is there a way to have it calculate B2, B3 and so on down the page. Thanks jeff


Posted by Tom Urtis on January 21, 2002 5:50 AM

Enter .5 in any unused cell, click Edit > Copy, then select your target range of 463 cells, and click Edit > Paste special, select "Divide" in the Operation section, click OK, and hit Esc to clear the clipboard.

By the way, in your case, you could also enter a 2 in any unused cell, select your range, and choose Multiply as your Paste special operation, which is the same as dividing a number by .5.

HTH

Tom Urtis

Posted by George J on January 21, 2002 5:53 AM

You already have the solution. If you select the first cell your formula is in, click and hold down on the little black box at the very bottom right of the cell (the cursor should change when you are over this), and drag down to the last cell you want calculated.

If individual totals are not required you can do
=SUM(B1:B463)/0.5


George

Posted by Tom Urtis on January 21, 2002 5:58 AM

I think I misread your post. My original answer would give you the calculated result in the same column B. If you want to keep the column B numbers as they are, then in cell C2 (assuming your range of 463 cells starts in B2), enter
=B1/.5
Or
=B1*2

Re-select cell C2, and then double click on the little black square (called a "fill handle") that you see as the lower right corner of the border of C2. If your 463 cells in column B is continuous then this will be the quickest way to copy the formula down to the 463rd used cell. Otherwise, select C2 and click Edit > Copy, then highlight C3:C464, and hit Edit > Paste (or Edit > Paste special > Formulas).

Tom U.