Fix the _xlfn.IFS Prefix in Excel After Mac Migration
Question details
Restore support for IFS formulas that display the _xlfn. prefix after files are moved to a new Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- Mac; macOS version not provided
- Scenario
- A user opens an Excel workbook containing IFS formulas after migrating to a new Mac.
- Observed behavior
- Excel displays the IFS function with the _xlfn. prefix, indicating that the installed Excel environment does not recognize the function.
Open the affected workbook and select a cell showing _xlfn.IFS to confirm which formula is affected. Have the Microsoft account and license used to install Office available in case you need to reinstall it.
Check the Excel edition and install available updates
Use this first to confirm that your Excel installation supports IFS and is up to date.
The _xlfn. prefix indicates that Excel does not recognize a function in the workbook. IFS is supported in Microsoft 365 and Office 2019 or later; a perpetual Office 2016 installation does not support it.
In Excel, select Excel > About Excel and note the complete version and license information. The major version number 16 alone does not identify the Office edition.
Select Help > Check for Updates and install any available Office updates. If you installed Excel through the Mac App Store, check the App Store's Updates section instead.
Quit Excel, reopen the workbook, and select the affected formula cell to see whether IFS is recognized.
If your license is for an unsupported edition, install a supported version of Excel, such as Microsoft 365 or Office 2019 or later, and open the workbook again.

Reinstall Office if a supported Excel version still shows _xlfn.IFS
Use this if IFS should be supported but checking the edition and installing updates did not resolve the issue.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easy to move existing files into another workspace. It does not repair your Microsoft Excel installation.

Frequently Asked Questions
What does _xlfn.IFS mean in Excel?
The _xlfn. prefix means the Excel environment does not recognize the IFS function. Check Excel > About Excel to confirm the installed edition and version.
Does every Excel version numbered 16 support IFS?
No. Multiple Office editions use version numbers beginning with 16. Check the complete version and license information under Excel > About Excel rather than relying on the major number alone.
Why does IFS still show the prefix in a supported Office edition?
The installation or its settings may have been affected during migration. Try Help > Check for Updates first; if the issue remains, follow Microsoft's instructions to remove and reinstall Office.
Can I fix the formula by deleting the _xlfn. prefix?
Deleting the prefix does not add function support. Check that you have a supported Excel edition, update it, and reopen the workbook before changing the formula.




