3 ms·
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.
by SAI_Peregrinus 2y 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.
- koverstreet 2y agoIt's somewhat acceptable with double precision floats - never single precision floats. But far better to just use integer cents.
- IX-103 2y agoInteger 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).