Forum Discussion
Why 4 equals 5?
Please calculate the following formular without any division in it: =int((6.05-6)*100)
In Excel your are more or less limited to this:
How to correct rounding errors in floating-point arithmetic
Hi, I am not rounding, I use the integer operation. Ot just cuts everything after the decimal point. I strongly believe the minus operation calculates wrong at the second place after the decimal point. Financial institutions shoul better know it an not using Excel to calculate. Again, use Spss to calculate the same formula. It calculates correct.