formula for column

  • Thread starter Thread starter OM
  • Start date Start date
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
 
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.
 
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.
 
Back
Top