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)