Function Problems

Fix IFS and IF Formulas Not Working in Excel Online

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

The user needs to determine why IFS and nested IF formulas are not working in Excel Online.

How to Fix IFS and IF Formulas Not Working in Excel Online
Product
Microsoft Excel Online
Device & OS
not provided
Scenario
The user is entering conditional formulas in a workbook opened in Excel Online.
Observed behavior
IFS formulas and a copied nested IF formula do not work as expected.
Before you start

Open the workbook in Excel Online and note any error message or unexpected result. Check the value in B7 and whether your regional settings use commas or semicolons to separate formula arguments.

Solution 1Recommended

Test the IFS formula in a blank Excel Online workbook

Use a simple test to distinguish a formula or browser issue from a problem in the original workbook.

1
Create a test workbook

In Excel Online, select New blank workbook and enter A in cell B7.

2
Enter the IFS formula

Select another cell and enter =IFS(B7="A","Yes",B7="B","No",B7="C","Maybe",B7="D","N/A"). Press Enter; the result should be Yes.

3
Check the formula syntax

If the formula is rejected, check the quotation marks and try semicolons instead of commas if your regional settings require them. Make sure the entry begins with =.

4
Compare with the original workbook

If the test works, return to the original workbook and check B7 for extra spaces or a different value. If the formula appears as text, change the cell format from Text to General, then select the cell, re-enter the formula, and press Enter.

Test the IFS formula in a blank Excel Online workbook
No matching condition: IFS returns #N/A when none of its conditions match. Add a final TRUE condition and a default result if you want to handle other values.
Free Microsoft Office alternative

Work with Conditional Formulas in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets to continue working with conditional formulas; it does not repair Excel Online service or browser issues.

Create and edit spreadsheets with conditional formulas.Open and save Microsoft Excel XLSX files for easier migration.Use a familiar spreadsheet interface.Work in a lightweight, free Office alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Why does IFS return #N/A in Excel Online?

IFS returns #N/A if none of its conditions is true. Check the value being tested, or add a final TRUE condition with a default result.

Why is my formula showing as text instead of a result?

The cell may be formatted as Text. Change its format to General, then select the cell, re-enter the formula, and press Enter. Also check that the formula starts with =.

Why does Excel Online reject a formula copied from an example?

Your regional settings may require semicolons instead of commas between arguments. Check the separators and quotation marks, then try the formula again.

What if both IFS and nested IF fail?

Test both formulas in a blank workbook. If they still fail, try a private browser window or another updated browser, and ask your Microsoft 365 administrator to check Service health.