Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula that will do C1=A1*B1...Cn=An*Bn
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula that will do C1=A1*B1...Cn=An*Bn
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. "Ryan" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula that will do C1=A1*B1...Cn=An*Bn
"Ryan" wrote:
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula that will do C1=A1*B1...Cn=An*Bn
Enter =A1*B1 in C1
Double-click on the fill handle of C1 Gord Dibben MS Excel MVP On Thu, 7 Jan 2010 23:24:01 -0800, Ryan wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|