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
|