Wrong calculation

[Franck_Gentilin]

Hello, in the following formula the result is false
Thanking you in advance for your return

Price €699 * insurance : 1.5% = € 10.49 * amount : 2, total 20.98 - The formula gives €20.97

[Bill_French]

Franck_Gentilini1:

in the following formula the result is false

Floating point error -

Floating Point Error - Addition/Subtraction Formulas

There is a floating point bug that I can only get to rear its head in a particular way. I have distilled down to this simple example. Add three particular numbers (haven’t played around with which numbers cause the problem, but these do), subtract the sum from the same number in another field and the result is displayed as zero, as it should. Put an IF statement in another field comparing the result to zero, and the comparison fails. I was able to get the IF statement to display the floating poi…

[Franck_Gentilin]

Hello, I used following method by adapting it to my problem, Thank you for your help

Floating Point Error - Addition/Subtraction Formulas

The ROUND function can takes a “precision” argument, which, for two decimal places is “2”. Does the below formula work for you? =ROUND({Reference Instrument Temperature}-{DUT Temperature},2) Alternatively, there’s the… classic but dumb way of doing it, which is to multiply the numbers by 100 before any arithmetic, then dividing it by 100 at the end: =(ROUND({Reference Instrument Temperature}*100,0)-ROUND({DUT Temperature}*100,0))/100