PDA

View Full Version : Solved: Formula problem



Poshfox
12-25-2008, 02:32 AM
I wonder if someone could help in a formula that I require in my spreadsheet.
I have tried endlessly but still cant fathom it out :dunno

See the attached sample to see what I am trying to achieve.
In the first column is week 1's totals and in the second column is week 2's, but sometimes these can be a negative number, now the third coloumn is where I require the formula to give the results shown.
Basically all the third coloumn is, is the points that have been gained in week 2 only.
my real spreadsheet contains a lot more weeks and totals which is why I require the formula to work it out.

Thanks if you are clever enough to provide a solution for me

Fox

Bob Phillips
12-25-2008, 03:09 AM
Surely, it is nothing more than

=E10-D10

rbrhodes
12-25-2008, 03:36 AM
could be a couple of things... first thing that comes to mind is an explanation...

Here's 3 stabs at it.

:dunno