View Single Post
Old Sep 16, 2008 | 10:07 AM
  #1  
Iain Mac's Avatar
Iain Mac
PassionFord Post Whore!!
 
Joined: Jun 2003
Posts: 4,903
Likes: 6
From: Scotland
Default Excel has stopped doing sums!

I created a simple spreadsheet yesterday to track revenue from ticket sales.
The formula is as simple as A2 (the number of tickets sold) x 8 (the value of a ticket.)

Today I updated sales for one person and noticed that the revenue didn't increase and, on checking, none of the other lines will work either.

Instead of £8 x 2 = £16 becoming £8 x 4 = £32 it has stayed as £16.

I've tried opening a new spreadsheet and it is the same.

What am I doing wrong? It isn't an absolute value thing because I'm not using an Absolute Cell Ref.
Reply