+ Reply to Thread
Results 1 to 5 of 5

right calculation wrong answer

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    al-ain UAE
    MS-Off Ver
    Excel 2007
    Posts
    1

    right calculation wrong answer

    what is the problem? if =A1-A2 BUT the answer is addition please me, i need an answer.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: right calculation wrong answer

    Maybe A2 is negative number?

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: right calculation wrong answer

    Your questions s not very clear. Can you try explaining again?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    10-12-2008
    Location
    Maldives
    MS-Off Ver
    MS 2010
    Posts
    59

    Re: right calculation wrong answer

    (50.00) - (40.00) = (10.00) , A5-B5
    50.00 - 40.00 = 10.00 , A6-B6
    (50.00) - 40.00 = (90.00) , A7-B7
    50.00 - (40.00) = 90.00 , A8-B8

    If this does not help please explain your problem little bit more, or attach the sheet in which you are having the problem.

    Regards

  5. #5
    Registered User
    Join Date
    09-22-2011
    Location
    Washington, USA
    MS-Off Ver
    Excel 2003,2007, 2010
    Posts
    85

    Re: right calculation wrong answer

    When you subtract a negative number it is equivalent to saying minus a minus. So subtracting a negative is the same as adding - just the way math works.

    Negative - Positive = Negative
    Positive - Negative = Positive + Positive = Positive
    Negative - Negative = Negative + Positive = Use the sign of the larger number and subtract (Change double negatives to a positive)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1