Forum Discussion
Round Function Bug
For instance, if the function =ROUND(E11-E12,2) is rounding incorrectly when E11 and E12 are 49.995 & 49.2 respectively. I noticed its also incorrect for 39 and 59. All other values seem to round cor...
Kclark1017 That is called a "floating point error". Google for that phrase and you can learn all about it. Increase the number of decimals like in the picture below and you'll see that 49.995 minus 49.2 is not resulting in the 0.795 that you expect.