Excel Floating Point Arithmetics is Wrong! Calculations to prove it!
Ok, if you are MS Excel person and someone tells you that 20 - 0.1 is not exactly equal to 19.9 you will think that guy is probably not a good accountant. Anyway, if you later take that 19.9 and compare it with 20, then the difference of 0.1 will be not equal to the 0.1, that you started with initially. Say what?
If you are a developer or mathematician, you are probably aware that 0.1 cannot be presented as a sum of 1/2^n and this video would not be for you, so find something better to do for the 10:23 minutes.
Microsoft Article - Floating Point Arithmetic Inaccurate Result:
https://learn.microsoft.com/en-US/off...
VitoshAcademy Article from 2017 about it:
https://www.vitoshacademy.com/excel-v...
Contents:
Problem statement - 0:25
Explanation why it does not work - 3:50
The "big deal" with 0.1 - 6:20
Fixing the it with `=ROUND()` - 7:35
Set precision as displayed option - 8:20
