Function Problems

Fix the _xlfn.IFS Prefix in Excel After Mac Migration

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

Restore support for IFS formulas that display the _xlfn. prefix after files are moved to a new Mac.

Fix the _xlfn.IFS Prefix in Excel After Mac Migration
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the full version

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.

2
Check for updates

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.

3
Reopen the workbook

Quit Excel, reopen the workbook, and select the affected formula cell to see whether IFS is recognized.

4
Upgrade if necessary

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.

Check the Excel edition and install available updates
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesReview formulas in a familiar spreadsheet interfaceUse a free, lightweight Office alternativeMove existing documents into WPS Office without starting from scratch
microsoft office alternative - wps office

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.