Fix Incorrect IF and OR Formula Results in Excel for the Web
Question details
The user needs to identify why an IF and OR formula returns different results in desktop Excel and Excel for the web.
- Product
- Microsoft Excel desktop and Excel for the web
- Device & OS
- not provided
- Scenario
- Opening a workbook in Excel for the web and expecting the same formula results as in the desktop application.
- Observed behavior
- The IF and OR formula works correctly in desktop Excel but returns incorrect results in Excel for the web.
Copy the exact formula and note the values of every cell it references. Confirm whether the online workbook is stored in OneDrive or SharePoint and whether the desktop version is opening that same file.
Test the IF and OR formula in a new Excel web workbook
Use a clean workbook to determine whether the discrepancy is specific to the original file or its stored data.
In OneDrive or SharePoint, locate the workbook and open it in Excel for the web. Compare its name and folder with the file open in desktop Excel to rule out separate copies.
From Excel for the web, choose New blank workbook. Manually enter the input values into the same cell addresses used by the original formula.
Select the corresponding result cell, paste the formula into the formula bar, and press Enter. Preserve the original cell references and comparison criteria.
Compare the new workbook's result with the original web workbook and desktop Excel. If the clean test produces the expected result, investigate the original workbook's data, references, and calculation state using the checks below.
Check cell values, formula references, and recalculation
Use these checks when the original workbook produces an unexpected result or the clean test reproduces it.
Work with IF and OR Formulas in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making migration straightforward. Use WPS Spreadsheet to work with IF and OR formulas locally; it does not repair Excel for the web or its recalculation behavior.
Frequently Asked Questions
Does Excel for the web support formulas that combine IF and OR?
Yes. Excel for the web supports IF and OR, including nested formulas such as =IF(OR(A1="Yes",B1="Yes"),"Match","No match"). If results differ from desktop Excel, check the actual input values, references, file version, and calculation state.
Why should I test the formula in a new workbook?
A new workbook helps separate formula logic from issues in the original file. Create a blank workbook in Excel for the web, manually enter the same inputs, and paste the exact formula. If it works there, focus on the original workbook's data and settings.
Can number formatting cause an IF comparison to look incorrect?
Formatting can hide differences in the underlying values. Select the input cell and inspect the formula bar, or increase the displayed decimal places from the Home tab. Use ISNUMBER or ISTEXT in an empty cell to check whether an input is a number or text.
How can I check whether OR is choosing the wrong IF branch?
Enter each comparison from the OR expression into a separate empty cell. OR returns TRUE if at least one comparison is TRUE, so IF will use its true-result branch even when the other comparisons are FALSE.
What should I collect if the results still differ?
Record the exact formula, the underlying values and data types of its referenced cells, and the result in each Excel version. Also note whether the file is on OneDrive or SharePoint and whether the same formula works in a new Excel web workbook.
