sin(x)^2+cos(x)^2 = 1 on different calcs

[Thomas Okken]

(09-26-2018 07:37 AM)J-F Garnier Wrote:  And I'm happy that excel is using binary arithmetic, I never encountered such situations in real life but had to deal with very large and complex spreadsheets to do system simulations, and speed was the main point.

...but when calculating with money, decimal fractions really should be exact, and spreadsheets are very commonly used for calculations involving money (which, presumably, is why Excel tries to cheat).