formula for column

O

OM

First of all, I am not a Excel person and this question might be very
simple for most of the users here.

I have imported a column of data onto a sheet and need to formulate the
the cells within the column. The formula would be existing value / 100 +
2. I am able to get the right value for the first cell by putting =
existing value / 100 + 2. However, I can't seem to use the same formula
for the rest of the cells. I dragged the lower right corner of the first
cell to last cell of the column, but I got the same value for all the
cells. Can someone tell me what is wrong with my doing?

Thanks
 
M

Mel

Well I am a bit like the blind leading the blind, but I would use a second
column next to your first with =C1/100+2 then drag down on that column. C1
being the first cell you have your existing data in.
 
R

Roger Govier

Hi

Did you use an absolute reference for the starting cell?
If you used
=$A$1/100+2
then you would get the same value all the way down.
The cell reference needs to be relative
=A1/100+2
then it will adjust as you copy down.

Alternatively, maybe you are set to manual calculation mode.
What happens if you press F9?
Go to Tools>Options>Calculation and make sure Automatic is selected.
 
Top