Comment by belter

HN ignorance on display...

The Journal of Accountancy - "Bugged by Excel’s calculation errors" - https://www.journalofaccountancy.com/issues/2014/mar/excel-c...

ICAEW (Institute of Chartered Accountants) — "Rounding Errors Revisited" (Excel Tips #447) - https://www.icaew.com/technical/technology/excel-community/e...

Just a reminder that an accountant who might say "I use Currency format" is still working in binary floating point as the format is just used as a display mask. And using VBA macros with the Currency type will hit problems at the boundary, when values move between the worksheet and the macro. The tool is broken in a way that proper accounting software is not...

"Floating-point arithmetic may give inaccurate results in Excel" - https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...