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 ToolsOptions.
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