Forum Discussion
M_Nuris_Hidayat
Apr 22, 2019Copper Contributor
Wrong summary result for larger number. Different result while data is sorted .
Dear Experts, I had problem with these numbers. The results is different when I do Summary. Sort Min to Max, get different result with sort Max to Min. Try to SUM these number in 3 mode: 1. Origi...
Twifoo
Apr 22, 2019Silver Contributor
That is floating point arithmetic, as explained here:
https://support.microsoft.com/en-ph/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel
https://support.microsoft.com/en-ph/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel