Can some please advise why when I am adding two number - 6145860.05+ -6145450.00, I receive a result of 410.05. However when I go to expand the decimals it results in 410.0499999, etc. when if I expand my original two numbers I do not see anything to indicate why this is happening.
Advice?
use this formula
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
This is due to what is known as Floating Point arithmetic.
Have a read of...
https://support.microsoft.com/en-ca/...sults-in-excel
Basically 0.05 (and many decimals) can't be expressed in binary in finite number of 0s & 1s.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks