How to Fix Excel Adding the @ Symbol to IFS Formulas (#NAME? Error)
Question details
Users experience Excel for Mac automatically inserting the @ symbol into IFS formulas upon reopening workbooks, which results in a #NAME? error.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Reopening a saved workbook containing IFS formulas, often inside Excel tables with structured references.
- Observed behavior
- The formulas automatically display the @ symbol (implicit intersection operator) and return a #NAME? error instead of the calculated result.
Ensure your current version of Excel natively supports the IFS function (requires Microsoft 365, Excel 2019, or newer), as opening these formulas in older versions will trigger errors regardless of syntax.
Verify Excel Version Compatibility
The IFS function is not supported in older versions of Excel (such as Excel 2016). Opening a workbook in an unsupported version causes the #NAME? error and prompts Excel to add the @ symbol.
When Excel encounters a function it does not recognize, it returns a #NAME? error. Furthermore, newer dynamic array features may cause legacy versions to prefix unrecognized functions with the implicit intersection operator (@). Upgrading your software is the most straightforward fix.
Open Microsoft Excel on your Mac. Click on the 'Excel' menu in the top-left corner of the screen and select 'About Microsoft Excel'.
Look at the version number and license type in the dialog box. If you are using a version older than Excel 2019 (e.g., Office 2016), the IFS function is not supported.
Update your software to Microsoft 365 or a newer standalone version. Alternatively, you can open the file in a compatible program like WPS Office that supports modern functions.
Replace IFS with Nested IF Functions
Rewrite the formula using nested IF functions to ensure backward compatibility and eliminate the @ symbol issue across all Excel versions.
Manually Remove the Implicit Intersection Operator
If you are on a supported version of Excel but the @ symbol was inserted due to a legacy array calculation context, manually deleting the symbol can restore the formula.
Open and Edit Spreadsheets Flawlessly with WPS Office
If Excel's formula compatibility issues and unexpected implicit intersection operators (@) are disrupting your work, try WPS Office. It provides high compatibility with Microsoft Excel files and modern formulas without the subscription fees.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free version of WPS Office for your Mac or PC.
- 2. Open your Excel File: Launch WPS Spreadsheets and open your existing .xlsx file that contains the IFS formulas.
- 3. Edit Without Errors: WPS Office will automatically recognize modern formulas, allowing you to view and edit your data without dealing with unexpected #NAME? errors.
Frequently Asked Questions
What is the implicit intersection operator (@) in Excel?
The @ symbol is used in newer versions of Excel to indicate that a formula should return a single value rather than an array. Excel automatically adds it to formulas created in older versions during file opening to maintain compatibility with dynamic arrays.
Why does my IFS formula work on one computer but show #NAME? on another?
The IFS function was introduced in Microsoft 365 and Excel 2019. If you create the file on a newer version and open it on a computer running an older version (like Excel 2016), the older software will not recognize the function, resulting in a #NAME? error.
Can structured references in Excel tables cause formula errors?
Yes. When mixing structured references (like [@ColumnName]) with functions that are not natively supported by your exact Excel version, Excel may misinterpret the syntax or add unnecessary implicit intersection operators, leading to broken formulas and errors.
