Forum Discussion
Excel bug incorrect calculation
same data different results, it is probably a floating point multiplication error but from paid enterprise application made to work with data I expected more
Yes I'm sure it is a floating point issue but to make things more interesting I repeated your example on row 15 but then the Function ROUND() worked fine (see row 16). I further used the Excel Labs in grid tool to show the calculations and in cell B15 it shows different result than the grid (see yellow notification and how it shows the correct 103. But in cell D15 I included the calculation directly inside the MROUND() function and both the grid and Excel Labs agree on the wrong result:
I know this doesn't help you but I thought it was interesting.