Report

Stupefying differential result! [Solved]

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Last answered 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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!