4 ms·
> I know I can rest assured the Excel spreadsheet for my monthly and annual budget is perfectly accurate and reliable. Consider yourself lucky that your use ca
by bostik 2y ago
> I know I can rest assured the Excel spreadsheet for my monthly and annual budget is perfectly accurate and reliable.
Consider yourself lucky that your use cases are all on the happy path.
There are entire categories of bugs and inconsistencies where Excel's behaviour is known to be wrong, but which can't be fixed because the rest of the ecosystem depends on those same errors to manifest in the same ways.
For example - formulas with cycles have an upper bound as to how many times they are allowed to cycle. If you happen to hit the ceiling before your values converge, you will be left with the values calculated on the last iteration.