Posted 8 September 2017, 12:46 pm ESTHello,
I am having a problem with subtraction formula. To illustrate my problem, I am sending two files. In the first file (Sheet1.jpg), you can see several values between C3 and C8 cells. In C9 cell, I put the sum formula to add those values. The expression is =SUM(C3:C8). In this case, the operation was executed correctly.
In C10 cell, there is another value (563,28). As you can see in the next file (Sheet2.jpg), I subtracted the content of cell C10 by content of Cell9 (result of the sum operation) using the following expression: =C10-C9. The correct result of this operation is 563,28 - 565,29 = -2,01 and not -2,00999999999 as it was presented. Could you help me?
Thanks a lot.