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

HN ignorance on display... The Journal of Accountancy - "Bugged by Excel’s calculation errors" - https://www.journalofaccountancy.com/issues/2014/mar/excel-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/excel-community-articles/2022/excel-tips-and-tricks-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-apps/excel/floating-point-arithmetic-inaccurate-result https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...