Previous Topic Next Topic

Stupefying differential result!

Solved/Closed
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Apr 4, 2016 at 07:33 PM
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Apr 5, 2016 at 08:06 PM
Hello, in the attached picture you can see that in cell E23 I inserted my budget and in cell E23 I inserted what I actually spent (the same amount) should therefore the result no be -0- ??? why am I getting a DOUBLING result???

My formulas in these examples are =F9-E9 and =F23-E23

http://speedy.sh/4kEdm/A1-MONTHLY-Budget-month-NEW.xlsx

I appreciate the time and effort of anyone helping me resolve this.

Grateful, Jose Cruz



Related:

2 responses

Answer 1 / 2
MathWizard
Apr 5, 2016 at 05:46 PM
You should be able to solve it from this: 


2 + 2 = 4
2 - 2 = 0
(-2) + 2 = 0
(-2) - 2 = -4
0
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Apr 5, 2016 at 07:49 PM
Done! Thank you!
0
Answer 2 / 2
RayH
Apr 5, 2016 at 08:02 PM
You don't have any deposits.

Your formula (Transactions!Z:Z) equates to:

0 (deposit) - 4736.74 (Payment) = (-4736.74)
0
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Apr 5, 2016 at 08:06 PM
Thank you very much, RayH!

I REALLY appreciate your feed-back. It's done! I had the columns inverted...stupid me!!!
Take care!
0