Operation on columns

  • Thread starter Thread starter Jean-louis
  • Start date Start date
J

Jean-louis

Hello,

I have the following problem to solve with excel.
I have two column. On the first one some values.
On the second one I would like to put the result of a simple math operation
from the values of the first column.

A B
10 = 10x2
20 = 20x2
30 = 30x2
40 = 40x2
60 = 60x2
50 = 50x2

As you can see I have the values in the column A and I would like to put in
the column B the result
of the computation A?x2.

Do you have a idea?

Thanks,


Jean-louis
 
Assuming you have header titles in row 1, type this formula in cell B2 and
copy it down column B.....

=A2*2

as you copy it down column B it will change to =A3*2 in cell B3 and to =A4*2
in cell B4, etc etc

Vaya con Dios,
Chuck, CABGx3
 
Back
Top