3 ms·
It's all fun and games until you realize that adding a large set of numbers in different orders gives you significantly different results. Floats are fine for
by TillE 9y ago
It's all fun and games until you realize that adding a large set of numbers in different orders gives you significantly different results.
Floats are fine for a lot of things, but you have to be really really careful not to overstep into the situations they can't adequately handle.
- cm2187 9y agoEven in accounting a certain rounding error is accepted depending on the size of the company. And for pricing financial instruments, prices pretty much always get rounded on the execution (you will never communicate a price with 20 decimals to a client on the phone). Excel rounding is a non problem in finance. Except when you are making exact payments. But payment systems aren’t run in excel anyway.