Report

Stupefying differential result! [Solved]

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Latest answer on Apr 5, 2016 08:06PM
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
See more 
Helpful
+0
moins plus
You should be able to solve it from this:


2 + 2 = 4
2 - 2 = 0
(-2) + 2 = 0
(-2) - 2 = -4
j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Apr 5, 2016 07:49PM
Done! Thank you!
Reply
Add comment
Helpful
+0
moins plus
You don't have any deposits.

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

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

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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!