When I copy down into the next cell the formula changes correctly.

When I copy down into the next cell the formula changes correctly however the
result keeps reading from the line I copied from. It is not an absolute cell.
The formula is correct. If I delete the result and type the formula manually
into the cell it works. Why would this be - Is there a button I need to tick
off? It only seems to happen on my computer

Calculation is probably set to manual. To change it, choose Tools>Options.
On the Calculation tab, select Automatic
Click OK

Jason30 wrote:
> When I copy down into the next cell the formula changes correctly however the
> result keeps reading from the line I copied from. It is not an absolute cell.
> The formula is correct. If I delete the result and type the formula manually
> into the cell it works. Why would this be - Is there a button I need to tick
> off? It only seems to happen on my computer


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html