6 ms·
That’s true for only a subset of spreadsheets. There’s no requirement for formulas to work left to right and top to bottom. Also, the moment you write = (A1 +
by Someone 5y ago
That’s true for only a subset of spreadsheets. There’s no requirement for formulas to work left to right and top to bottom.
Also, the moment you write = (A1 + A2)/2, not all intermediate values are visible anymore (although Excel has support for temporarily making them visible (https://support.microsoft.com/en-us/office/evaluate-a-nested-formula-one-step-at-a-time-59a201ae-d1dc-4b15-8586-a70aa409b8a7 https://support.microsoft.com/en-us/office/evaluate-a-nested...))
Also, in my experience, it’s fairly normal to have hidden rows or columns (https://support.microsoft.com/en-us/office/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8 https://support.microsoft.com/en-us/office/hide-or-show-rows...) or hide entire sheets (https://support.microsoft.com/en-us/office/hide-or-unhide-worksheets-69f2701a-21f5-4186-87d7-341a8cf53344 https://support.microsoft.com/en-us/office/hide-or-unhide-wo...)
And of course, the ultimate “not all intermediate values are visible” is the use of macro functions or iterations (https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4 https://support.microsoft.com/en-us/office/change-formula-re...)