Need a formula that will do C1=A1*B1...Cn=An*Bn

[Ryan]

Suppose column A has "quantity" values, column B has "amount" values, and I
want column C to be their products. I have 950 rows of this and I don't want
to enter 950 formulas into each row of C.

In other words I need Cn=An*Bn where n=row number.

Thanks

 

[trip_to_tokyo]

Do a Ctrl-C of the formula in C

- then highlight, for example, C 3 to C 900 inclusive

- the Ctrl-V to paste the formula

Please hit Yes if my comments have helped.

Thanks.

 

[Joe User]

Suppose column A has "quantity" values, column B has "amount" values, and I
want column C to be their products. I have 950 rows of this and I don't want
to enter 950 formulas into each row of C.
In other words I need Cn=An*Bn where n=row number.

Start with column C in the first row, say C2. Enter the formula that you
want, say:

=A2*B2

Now, put the cursor in C2, and copy it. Several ways to do that; I usually
just press ctrl+C.

Now, enter C3:C950 into the Name Box. In Excel 2003, that is in the upper
left corner under the toolbar. That will effectively select the entire range
of cells. Much easier than trying to select all the cells manually or
dragging C2 down 950 rows by using the handle in the lower right of the cell
C2.

Then paste into the selected range. Several ways to do that; I usually just
press ctrl+V.

If you look at C3 etc, you will see that the relative references A2 and B2
are automagically updated to reflect the current row, e.g. A3 and B3.

 

[Gord Dibben]

Enter =A1*B1 in C1

Double-click on the fill handle of C1


Gord Dibben MS Excel MVP