Fix an Excel for the Web Formula with a Red Dotted Border and No Result
Question details
The user needs to troubleshoot an Excel for the web formula that is outlined with a red dotted border and does not return a calculated result.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- The user enters or edits a worksheet formula and wants it to calculate correctly.
- Observed behavior
- The formula cell shows a red dotted border and no result is returned, often because the formula syntax does not match regional separator settings or another formula requirement.
Select the affected cell and copy the formula from the formula bar so you can review its exact syntax. Check whether other working formulas in the same workbook use commas or semicolons between function arguments.
Use the Formula Argument Separator Required by Your Regional Settings
Use this solution when a formula was copied from another source or contains commas between arguments but Excel expects semicolons.
Excel uses regional settings to determine the list separator in formulas. In regions that use a comma as a decimal separator, function arguments commonly need to be separated by semicolons.
Click the cell with the red dotted border, then click in the formula bar or press F2 to edit the formula.
Review each function argument. For example, change =SUM(A1,B1) to =SUM(A1;B1) if your Excel regional settings require semicolons.
Press Enter or select the check mark next to the formula bar. If the separator was the issue, Excel should calculate and display a result.
Verify Formula Names, References, and Value Types
Use this solution if changing the separator does not resolve the formula error.
Make Sure the Formula Cell Is Not Formatted as Text
Use this solution when the formula appears in the cell instead of calculating, or when it continues not to evaluate after syntax corrections.
Create and Troubleshoot Regional Formula Separators in WPS Spreadsheets
WPS Spreadsheets provides a familiar formula bar and calculation tools for entering, reviewing, and correcting worksheet formulas. You can edit functions, verify references, adjust cell formats, and work with compatible Excel files in a lightweight office suite.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the affected Excel workbook.
- 2. Edit the formula cell: Select the formula cell and review the expression in the formula bar, including separators, function names, parentheses, and cell references.
- 3. Correct the argument separator: Replace commas with semicolons when your current formula settings require semicolons between function arguments, then press Enter.
- 4. Set an appropriate cell format: Select the cell, go to Home > Number Format, and choose General or Number if the formula had been treated as text.
Frequently Asked Questions
Why does an Excel formula use semicolons instead of commas?
Excel follows your regional list-separator settings. In many regions where commas are used as decimal separators, formulas use semicolons between arguments, such as =IF(A1>0;"Yes";"No").
What does a red dotted border around a formula cell mean in Excel for the web?
It usually indicates that Excel cannot accept or evaluate the formula as entered. Review the formula syntax, especially argument separators, parentheses, function names, and cell references.
How can I tell whether Excel is treating my formula as text?
If the cell displays the formula itself rather than a result, select it and check the Home tab Number Format. Change Text to General, then edit the formula in the formula bar and press Enter again.
Why does a formula work in one workbook but not another?
The workbooks may be opened under different regional settings, or the formula may reference unavailable sheets, named ranges, add-ins, or data types. Compare the separator style and referenced cells in both files.
Where do I set automatic calculation for an Excel workbook?
In the Excel desktop app, go to Formulas > Calculation Options > Automatic. Excel for the web normally calculates formulas automatically, but a workbook saved with manual calculation may need to be updated in the desktop app.
