Problem with rounding

Hi everyone,

I have a set of functions that are executed one after another.
The result is a value (A) and I need to subtract the value (B) from it. The final result is the value (A-B).

The problem is that the value (A-B) that is the result of the subtraction is not exactly what I expect. It is larger by 0.0000000000001.

I tried to isolate the values into a different sheet using "copy & paste as value" and trying to do the subtraction there, but the problem persists.

Next I entered the values by hand (Manual Input) and it worked as expected.

Can anyone tell my why this happens?

Please see the attached sheet (just click where it says "Download: Weird.xlsx" at the top of the page)

Thanks for the quick reply,

The selected cell is the cell that I copy & pasted as value from the process. It appears to be a pure number (as seen in the formula tab) without any traces of functions. Is it still supposed to behave the way it does though?

1zyf13s.jpg

You can use the "=fixed" function to round your numbers down to one decimal place. Attached uses this function in two slightly different ways. Subsequent comparisons confirm the numbers match.

Thanks for the replies,

I guess I'll have to make my code more robust using rounding and/or the "fixed" method.

Cheers!