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
Bookmarks