3 ms·
And the all suffer from rounding error problems? I mean, fixed point and a specific type for currency (which also should include the denomination, while we are
by dirkt 5y ago
And the all suffer from rounding error problems?
I mean, fixed point and a specific type for currency (which also should include the denomination, while we are at it) are not rocket science. Spreadsheets get that right, at least.
- bidirectional 5y agoExcel uses IEEE-754 floating point, so I don't get what you mean with the spreadsheet comment. It has formatting around this which rounds and adds currency symbols, but it's floating point you're working with. Rounding error doesn't matter on these types of financial applications. It's the less glamorous accounting work that has to bother with that. They're not rocket science, but they're unnecessary, and would still be off anyway. Try and calculate compound interest with your fixed point numbers.