Function Problems

How to Fix IFS Function Unavailable in Older Excel Versions

John WilsonJohn Wilson Nov 10, 2026 870 views

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.

How to Fix the IFS Function Unavailable Error in Older Excel Versions
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.
Before you start

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.

Solution 1Recommended

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.

1
Understand the standard IF logic

A single IF statement evaluates one condition: =IF(logical_test, value_if_true, value_if_false).

2
Structure your nested IF formula

Instead of using the IFS structure (=IFS(condition1, result1, condition2, result2)), replace it with nested IFs: =IF(condition1, result1, IF(condition2, result2, default_result)).

3
Apply the nested IF formula to your worksheet

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.

Replace the IFS Function with Nested IF Statements
Parentheses check: When using nested IFs, Excel requires you to close every open parenthesis at the end of the formula. For example, three IF statements will end with three closing parentheses: ')))'.

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. 1. Download and Install WPS Office: Download WPS Office from the official website and install it on your computer for free.
  2. 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbook.
  3. 3. Use the IFS Function: Select a cell, type '=IFS(' into the formula bar, and enter your logical tests and results.
  4. 4. Press Enter to Apply: Hit Enter. WPS Spreadsheets will instantly calculate the modern IFS formula without any compatibility errors.
Natively supports modern functions including IFS, XLOOKUP, and TEXTJOINFully compatible with Microsoft Excel formats (.xlsx, .xls) so you won't lose your workLightweight and runs smoothly on both newer and older devicesFree to download and use with a highly familiar user interface
microsoft office alternative - wps office

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.