Hi guys.
Did you meet a following issue in number addition?
If I add a following numbers (from A1 to A5):
2,390000000000000000000000000000
2,390000000000000000000000000000
349,960000000000000000000000000000
-349,960000000000000000000000000000
-4,780000000000000000000000000000
SUM(A1:A5) of them in Excel is:
-0,000000000000027533531010703900
???
Jan
Last edited by Jan Zitniak; 01-19-2017 at 03:54 AM.
It's well known:
https://support.microsoft.com/en-gb/...sults-in-excel
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks Glenn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks