How to Fix IFS Function Unavailable in Older Excel Versions
Question details
The user encounters a missing or unrecognized function error when trying to use the IFS function in an older version of Microsoft Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or creating a workbook that relies on the IFS function for evaluating multiple conditions.
- Observed behavior
- The IFS function is completely unavailable, often resulting in a #NAME? error or a formula breakdown because the Excel version is too old to support it.
Verify your current version of Microsoft Excel to confirm whether it supports the newer IFS function, which was only introduced in Excel 2019 and Microsoft 365.
Replace the IFS Function with Nested IF Statements
Since older versions of Excel do not support the IFS function, you can achieve the exact same multi-condition logic by combining multiple standard IF functions.
The standard IF function has been available in all versions of Excel. By placing an IF function inside the 'value_if_false' argument of another IF function, you can create a chain that acts exactly like the IFS function.
While this approach requires careful attention to parentheses, it ensures your spreadsheet remains fully compatible with older versions like Excel 2010, 2013, or 2016.
A single IF statement evaluates one condition: =IF(logical_test, value_if_true, value_if_false).
Instead of using the IFS structure (=IFS(condition1, result1, condition2, result2)), replace it with nested IFs: =IF(condition1, result1, IF(condition2, result2, default_result)).
Select the cell where you want the result to appear, type your newly structured nested IF formula into the formula bar, and press Enter. Ensure that the number of closing parentheses at the end matches the number of IF statements you opened.

Upgrade Your Spreadsheet Software
If you frequently work with modern formulas like IFS, XLOOKUP, or dynamic arrays, upgrading to a modern spreadsheet application is the most efficient long-term solution.
Use the IFS Function Directly in WPS Office for Free
Avoid the hassle of nested IF statements or expensive software upgrades. WPS Office Spreadsheets natively supports the IFS function and handles all your multi-condition logic flawlessly.
- 1. Download and Install WPS Office: Download WPS Office from the official website and install it on your computer for free.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbook.
- 3. Use the IFS Function: Select a cell, type '=IFS(' into the formula bar, and enter your logical tests and results.
- 4. Press Enter to Apply: Hit Enter. WPS Spreadsheets will instantly calculate the modern IFS formula without any compatibility errors.

Frequently Asked Questions
Which versions of Microsoft Excel support the IFS function?
The IFS function is only available in Microsoft 365, Excel 2019, Excel 2021, and Excel for the web. Older standalone versions like Excel 2016, 2013, and 2010 do not support it.
Why does my IFS formula show a #NAME? error?
A #NAME? error typically appears when you open a workbook containing an IFS formula in an older version of Excel that does not recognize the function name. Upgrading your software or changing the formula to nested IF statements will resolve this.
What is the maximum number of conditions I can test with nested IF statements?
In modern versions of Excel (2007 and later), you can nest up to 64 IF functions in a single formula to test multiple conditions. However, using the IFS function or alternative lookup functions is generally easier to read for complex logic.
Can I use the IFS function in WPS Office?
Yes, WPS Office Spreadsheets fully supports the IFS function natively. You can open workbooks containing IFS formulas or create new ones without experiencing compatibility issues.




