Hacker News new | ask | show | jobs
by SAI_Peregrinus 660 days ago
MS Excel uses floating point, and it's used a ton in finance. Don't use floating-point for monetary amounts if you don't know what rounding mode you've set.
1 comments

It's somewhat acceptable with double precision floats - never single precision floats.

But far better to just use integer cents.

Integer cents implies a specific rounding mode (truncation). That's probably not what you should be using. Floating point cents gets the best of both worlds (if you set the right rounding mode).