4 ms·
> You see, when formulas create a circular reference, Excel will run that computation up to a number of times. If, in those computations, the magnitude of the d
by readyplayernull 3y ago
> You see, when formulas create a circular reference, Excel will run that computation up to a number of times. If, in those computations, the magnitude of the difference between the most recent and previous computed values for the cell falls below some pre-defined epsilon value (usually a very small number, like 0.00001), Excel will stop recomputing the cell and pretend like it finished successfully.
https://basta.substack.com/p/no-sacred-masterpieces https://basta.substack.com/p/no-sacred-masterpieces
- dan-robertson 3y agoDon’t you need to go into the settings to turn on circular references (ie iterative calculation) and then you can choose the limits/tolerance?
- ungawatkt 3y agomy thought reading this quote was: If you squint and turn it sideways, that's a solver function. Sure enough, slightly higher in the article: > “We use a circular reference in Excel to do linear regression.”
- seanhunter 3y agoExcel has a solver function. It’s called “Goal Seek” for one unknown or “solver” for multiple. https://support.microsoft.com/en-us/office/use-goal-seek-to-find-the-result-you-want-by-adjusting-an-input-value-320cb99e-f4a4-417f-b1c3-4f369d6e66c7 https://support.microsoft.com/en-us/office/use-goal-seek-to-... https://support.microsoft.com/en-us/office/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040 https://support.microsoft.com/en-us/office/define-and-solve-...