'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix _xlfn IFS and CONCAT Errors in Excel for Mac
Question details
The user needs to resolve an issue where the _xlfn. prefix appears before IFS and CONCAT formulas, rendering the functions unusable.
- Product
- Microsoft Excel for Mac
- Device & OS
- Mac
- Scenario
- Opening or editing a workbook containing modern Excel functions (IFS, CONCAT) on a Mac computer.
- Observed behavior
- Excel displays the _xlfn. prefix before the IFS and CONCAT functions, indicating that the functions are unavailable, unrecognized, or unsupported in the current software build.
Ensure your Mac is connected to the internet and that you have your Microsoft Office account credentials handy, as you may need to verify your license type or download software updates.
Update Excel for Mac to the Latest Version
Updating the software ensures you have the latest feature sets, which is typically required to recognize newer formulas like IFS and CONCAT.
The _xlfn. prefix indicates a compatibility issue where a newer function is opened in an older or un-updated version of Excel. Installing the latest build usually restores full functionality.
Launch Microsoft Excel on your Mac. Click on 'Excel' in the top Apple menu bar, then select 'About Microsoft Excel'. Verify if your version is older than 16.93.
Click on 'Help' in the top menu bar and select 'Check for Updates'. If Microsoft AutoUpdate opens, click 'Update' next to Excel.
Once the update is complete, restart Excel and reopen your workbook to see if the _xlfn. prefix has disappeared and the formulas calculate correctly.
Use Alternative Backward-Compatible Formulas
If you cannot update Excel immediately, you can replace the unrecognized functions with older equivalents that work on all Excel versions.
Verify License Type and File Format
Certain modern functions are restricted to Microsoft 365 subscriptions or specific modern file formats.
Edit Spreadsheets Seamlessly with WPS Office
If your current version of Microsoft Excel for Mac doesn't support the latest functions and you want to avoid subscription fees, consider switching to WPS Office. It is a free, lightweight, and easy-to-use alternative that supports advanced formulas and ensures your work remains uninterrupted.
- 1. Download and Install WPS Office: Visit the official WPS Office website and download the Mac version. Follow the installation prompts to set it up on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open the workbook that contains the IFS or CONCAT functions.
- 3. Edit Without Errors: Continue editing your formulas and data without worrying about version restrictions or the _xlfn compatibility prefix.
Frequently Asked Questions
What does the _xlfn prefix mean in Excel?
The _xlfn prefix is Excel's way of indicating that a function used in a formula is not supported by the version of Excel you are currently using. Excel preserves the formula data but cannot perform the calculation.
Which versions of Excel support IFS and CONCAT?
The IFS and CONCAT functions are available to Microsoft 365 subscribers, as well as users of Excel 2019, Excel 2021, and Excel 2024 for Mac. Older perpetual versions (like Excel 2016) do not support them natively.
Can I just delete the _xlfn prefix to make the formula work?
No. Deleting the _xlfn. prefix manually will result in a #NAME? error because the underlying Excel software still does not recognize the function name. You must either update Excel or use a compatible alternative formula.
