Excel Error Codes

Fix Excel IFS Function Showing _xlfn and #NAME?

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

The user needs to restore an IFS formula that now shows the _xlfn prefix and returns a #NAME? error.

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

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.

Solution 1Recommended

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.

1
Check the Excel version

In Excel, open File > Account and check Product Information and About Excel. On a Mac, open Excel > About Microsoft Excel.

2
Verify the license

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.

3
Install available updates

On Windows, select File > Account > Update Options > Update Now. On a Mac, select Help > Check for Updates, then install available updates.

4
Reopen the workbook

Close and reopen the workbook in the updated, activated Excel installation, then select the affected cell to check whether IFS calculates normally.

Check and Update the Excel Installation
Updates and compatibility packages: An update or compatibility package does not necessarily add IFS to an unsupported Excel edition. If the function disappeared after an update, check whether the installed edition, signed-in account, or license also changed.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet formulas and calculation results in WPS SpreadsheetsUse a familiar interface for a smoother transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.