Fix Excel IFS Function Showing _xlfn and #NAME?
Question details
The user needs to restore an IFS formula that now shows the _xlfn prefix and returns a #NAME? error.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook containing a previously working IFS formula is opened in the current Excel installation.
- Observed behavior
- Excel displays _xlfn. before IFS and returns #NAME?, indicating that the installation does not recognize the function.
Open the affected workbook and select the cell with the error to inspect its formula in the formula bar. Check which Excel installation and account you are using, especially if the formula worked on another device or before an update.
Check and Update the Excel Installation
Use this approach to keep the IFS formula without rewriting it.
The _xlfn prefix indicates that Excel does not recognize a function in the workbook. IFS is supported in Microsoft 365 and Excel 2019 and later, but not in all older perpetual-license editions.
In Excel, open File > Account and check Product Information and About Excel. On a Mac, open Excel > About Microsoft Excel.
Under File > Account, check that the expected Microsoft 365 or Excel product is activated and that you are signed in with the account associated with it.
On Windows, select File > Account > Update Options > Update Now. On a Mac, select Help > Check for Updates, then install available updates.
Close and reopen the workbook in the updated, activated Excel installation, then select the affected cell to check whether IFS calculates normally.

Open the Workbook in a Compatible Excel Version
Use a supported Excel installation or Excel for the web when the current edition cannot run IFS.
Replace IFS With Nested IF Statements
Use nested IF statements if the workbook must calculate in an Excel edition that does not support IFS.
Work With Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. It can help you migrate spreadsheet work without changing your Excel installation; check formulas and results when opening a workbook because function compatibility can vary.

Frequently Asked Questions
What does _xlfn mean in my Excel formula?
The _xlfn prefix marks a function that the current Excel installation does not recognize. Check File > Account or Excel > About Microsoft Excel to identify the edition and version.
Why did IFS stop working after an update?
The update may have coincided with a change in the Excel edition, account, license, or installation. Check the product and activation details under File > Account before assuming the update removed the function.
Will installing a compatibility package add IFS?
Not necessarily. Function support depends on the Excel edition and installation. Check your version and install available Office updates, but use a supported Excel edition or a nested IF formula if IFS remains unavailable.
Can I remove _xlfn from the formula to fix it?
Removing the prefix alone will not make an unsupported Excel edition recognize IFS. Open the workbook in a supported Excel version or replace IFS with equivalent nested IF functions.




