• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula help Add Subtract negative number

rbobcat1

rbobcat1

Member
How do I get the proper difference

Cell B1 '=SUM(B2-A2) = 226,789.34 But the true answer should be 2754.86
Cell A2 has a negative number -112,017.24 / Cell B2 has a positive number 114,772.10

How do I get the proper amount of 2754.86
 
You must log in or register to reply here.
Back
Top