Function Problems

Fix Excel for Mac IFS Function Showing _xlfn and #NAME?

Anum MushtaqAnum Mushtaq Nov 20, 2026 869 views

Question details

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

Fix the IFS Function Showing _xlfn and #NAME? 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?.
Before you start

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.

Solution 1Recommended

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.

1
Check for Office updates

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.

2
Check macOS updates

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.

3
Restart and test the formula

Restart the Mac, reopen the workbook in Excel, and select the affected cell to check whether the IFS formula now calculates.

4
Update installed add-ins

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.

Update Excel for Mac and Check IFS Support
Check your Excel edition: An update cannot add IFS to an Excel edition that does not support it. Use a supported edition or replace the formula with nested IF functions.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesReview spreadsheet formulas and use nested IF expressions where appropriateNavigate a familiar interface that makes moving from Excel easierWork with a free, lightweight office suite
microsoft office alternative - wps office

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.