Results 1 to 34 of 34

Floating-point arithmetic... (=SUM) doesn't work correctly for my basic decimal numbers

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2018
    Location
    Finland
    MS-Off Ver
    365
    Posts
    12

    Floating-point arithmetic... (=SUM) doesn't work correctly for my basic decimal numbers

    I will be crazy. Maybe I am very tired. I do not understand why my SUM formula is not working correctly.
    Please help me

    More details:
    I believe my problem is very small. However, I do not know how to solve. I have a very large and complicated excel file, there are several formulas etc etc...One day, I noticed that my result are not correct. I check all the formulas, lines.. I could not find the reason...Then I decided to split the excel file by formula...Finally, I found out that the problem, as in the excel file in my first message.
    I suppose that my formula (=SUM) result should be zero. However the result is not real zero...
    I hope someone can tell me and show me a result.
    Please check my attachmet, you will see the problem easily.

    More information:
    Let me make it easy
    Please calculate your self in excel. My result is "-0.0000000000000222044604925031000". Why my result is not "zero"?

    What is the SUM of these values;
    49.350
    -12.600
    21.000
    -0.025
    -5.250
    -6.300
    -6.275
    63.000
    -12.600
    -4.200
    -10.500
    -4.200
    -6.300
    -4.200
    -2.100
    -4.200
    -6.300
    -4.200
    63.000
    -4.200
    -8.400
    -4.200
    -5.250
    -12.600
    -4.200
    -4.200
    -5.250
    -3.150
    -7.350
    -4.200
    -2.100
    -4.200
    -5.250
    -4.200
    -12.600
    -2.100
    -4.200
    -5.250
    -4.200
    Attached Files Attached Files
    Last edited by mengince; 02-22-2018 at 09:49 AM. Reason: more information to my first message

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vlookup and Sum in same formula not working correctly
    By mrichard in forum Excel General
    Replies: 5
    Last Post: 08-31-2015, 08:18 PM
  2. [SOLVED] Formula not working out correctly
    By ladbroke in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-26-2015, 01:24 AM
  3. Formula not working correctly
    By Burt_100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2014, 07:08 AM
  4. [SOLVED] Basic Formula Not Subtracting/looking at Imported time Correctly
    By jayclinton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2014, 09:10 PM
  5. If then formula not working correctly
    By chappie97 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-23-2013, 01:22 AM
  6. [SOLVED] IF formula not working correctly
    By ErikaC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-18-2013, 03:38 PM
  7. Replies: 9
    Last Post: 03-08-2013, 11:50 AM

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