Fix Excel for Mac IFS Function Showing _xlfn and #NAME?
Question details
The user needs to resolve an IFS formula that displays an _xlfn prefix and returns a #NAME? error in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Opening or calculating a workbook that uses the IFS function after an Excel for Mac update.
- Observed behavior
- The formula may appear with an _xlfn prefix and return #NAME?.
In Excel, select Excel > About Microsoft Excel to check your version and confirm that it supports IFS. Note the affected formula and its cell so you can test it after updating.
Update Excel for Mac and Check IFS Support
Use this approach when Excel does not recognize IFS or is running an older build.
The _xlfn prefix can indicate that Excel does not recognize a function used in the workbook. IFS is available in Microsoft 365 and newer perpetual versions of Excel, including Excel 2019 and later.
Open Excel and select Help > Check for Updates. Install available Office updates using Microsoft AutoUpdate. If you installed Excel from the Mac App Store, check the App Store's Updates section instead.
Open Apple menu > System Settings > General > Software Update and install an available compatible update. On older macOS versions, look for Software Update in System Preferences.
Restart the Mac, reopen the workbook in Excel, and select the affected cell to check whether the IFS formula now calculates.
If the error persists and you use Excel add-ins, open each add-in's update settings or check its provider's instructions for a compatible update, then test the workbook again.

Replace IFS With Nested IF Functions
Use nested IF formulas when you must work in an older Excel version that does not support IFS.
Work With Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files in WPS Spreadsheets to continue working with your data, while checking formulas for compatibility during migration.

Frequently Asked Questions
What does _xlfn mean in an Excel formula?
The prefix can appear when Excel does not recognize a function in the workbook. Check your version under Excel > About Microsoft Excel and update Excel if a newer supported version is available.
How do I update Excel on my Mac?
In Excel, select Help > Check for Updates and install available updates. If Excel came from the Mac App Store, check the App Store's Updates section instead.
Can I use an IFS formula in an older version of Excel?
If your Excel edition does not support IFS, replace it with nested IF functions or open the workbook in a supported edition, such as Excel 2019 or later.
Should I remove the _xlfn prefix manually?
First confirm that your Excel edition supports IFS and install available updates. Removing the prefix alone will not make an unsupported function work.




