Forum Discussion
What happens to new formulae (LET, IFS, etc.) when the workbook is opened in older versions of Excel
Formulas that use functions that are not available in the older version will still display their result.
In the formula bar, such functions will be prefixed with =_xlfn.
In the screenshot below, I opened a workbook that uses XLOOKUP in Excel 2019 (the non-Microsoft 365 version).
The result will survive recalculating the worksheet, but when I edit the cell and confirm it, the result will change to #NAME! since Excel 2019 can't perform XLOOKUP:
ā
Formulas that use functions that are not available in the older version will still display their result.
In the formula bar, such functions will be prefixed with =_xlfn.
In the screenshot below, I opened a workbook that uses XLOOKUP in Excel 2019 (the non-Microsoft 365 version).
The result will survive recalculating the worksheet, but when I edit the cell and confirm it, the result will change to #NAME! since Excel 2019 can't perform XLOOKUP:
ā
HansVogelaar Thanks for this clear explanation, Hans š