Excel has stopped doing sums!
Thread Starter
PassionFord Post Whore!!
Joined: Jun 2003
Posts: 4,903
Likes: 6
From: Scotland
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.
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.
Thread
Thread Starter
Forum
Replies
Last Post
mark94
Ford Mondeo Including ST
5
Oct 10, 2023 06:52 PM
nicodinho
Ford Non RS / XR / ST parts for sale.
6
Oct 7, 2015 12:56 PM