View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default 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