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