This will start off as a rant. Excel still has a Transition formula evaluation setting even though the IBM ceased selling Lotus 1-2-3 more than a decade and a half ago. Nothing other than MSFT's indifference or laziness precludes a setting for Traditional formula evaluation. What would I add which was nontraditional? Damn near everything Lotus Development Corp added to 1-2-3's @CELL function in Release 3 in 1989. 3 decades ago it was possible to get another cell's formula using @CELL("formula",X99). It took MSFT more than 2 decades to add FORMULATEXT.

Why FORMULATEXT when there was a perfectly useful GET.CELL(6,...)?

One of my greater frustrations with MSFT and Excel is MSFT continuing refusal to make all XLM information functions usable in standard worksheet cell formulas. OK, not all of them since CALLER would probably trigger circular recalc and LAST.ERROR would serve no purpose. However, I have a fair few workbooks which use names defined using GET.WORKBOOK(1,!$1:$1048576).

I dread MSFT deprecating XLM and thus removing its information functions.