Formula Errors

How to Fix Excel Online Formula Errors Caused by Regional Settings

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is experiencing formula syntax errors in Excel Online when attempting to use multi-argument functions like SUMIF, IF, and CONCATENATE.

Product: Excel Online
Device & OS: not provided
Scenario: Writing spreadsheet formulas with multiple arguments using commas as separators.
Observed behavior: Excel Online reports an error for standard comma-separated formulas because the workbook's regional settings require semicolons as function argument separators.

Before you start

Check the numeric formatting in your workbook to see if numbers use a comma as the decimal separator (e.g., 1,50 instead of 1.50).

Solution 1Recommended

Replace Commas with Semicolons in Formulas

Update your formula syntax to use semicolons instead of commas, which resolves conflicts in regions that use commas for decimal points.

When your regional settings dictate that commas are used for decimal places, Excel requires an alternative character to separate function arguments. In this scenario, the semicolon becomes the standard argument separator.

Select the Error Cell

Click on the cell containing the formula that is returning an error (e.g., a cell with =SUMIF or =CONCATENATE).

Edit the Formula

Click into the formula bar at the top of the spreadsheet to edit the function.

Update the Separators

Locate the commas separating the function arguments and replace each comma with a semicolon. For example, change =SUMIF(range,criteria,sumrange) to =SUMIF(range;criteria;sumrange).

Apply the Changes

Press Enter to save the formula. Excel Online should now calculate the result without throwing an error.

Syntax Updated: Using semicolons allows Excel to accurately distinguish between your function arguments and decimal values.

Solution 2

Create a Sanitized Sample for Troubleshooting

If updating the argument separators does not fix the issue across multiple functions, prepare a safe sample file to share for further support.

Free Microsoft Office alternative

Switch to WPS Office for a Hassle-Free Spreadsheet Experience

If regional settings and web-based editor quirks in Excel Online disrupt your workflow, try WPS Office. It provides a robust, lightweight desktop application with a familiar UI, making it incredibly easy to manage complex formulas without unexpected cloud-sync or regional formatting bugs.

1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx files directly without requiring any file conversion.
3. Edit Formulas Seamlessly: Enjoy full compatibility with advanced functions and straightforward regional setting controls.

Fully compatible with Microsoft Excel file formats (.xls, .xlsx, .csv).Familiar, user-friendly interface for effortless migration and formula entry.Advanced formula handling with easily customizable local regional settings.Completely free, lightweight, and fast-loading spreadsheet application.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel Online show a formula error when I use commas?

In regions where commas are used as decimal separators (such as many European countries), Excel requires semicolons to separate function arguments. This prevents the system from confusing an argument separator with a decimal point.

Which Excel functions are impacted by this regional setting issue?

Any function that takes multiple arguments can be affected. Common examples include SUMIF, COUNTIF, CONCATENATE, IF, VLOOKUP, and INDEX.

Can I change my regional settings to use commas as argument separators?

Yes. You can adjust your Microsoft account or OneDrive language and region settings to a locale that uses periods for decimals (like English - United States). Once updated, Excel Online will accept standard commas as function argument separators.

Excel & Data Problems