Formula Errors

Fix Formula Separator Errors When Entering Formulas in Excel for Mac

Elise WilliamsElise Williams Nov 12, 2026 870 views

Question details

The user needs to enter formulas successfully in Excel for Mac when the formula is rejected because of an argument separator mismatch.

Fix Formula Separator Errors When Entering Formulas in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user is typing a formula with multiple arguments, such as SUM, IF, or VLOOKUP, in an Excel worksheet.
Observed behavior
Excel displays a formula error or does not accept the formula when commas are used between arguments.
Before you start

Open a blank worksheet cell and test a simple formula before changing a longer formula. Check whether existing formulas in the workbook use commas or semicolons between function arguments.

Solution 1Recommended

Replace commas with semicolons in the Excel formula

Use this solution when Excel for Mac rejects a formula that uses commas between function arguments.

Excel uses the list separator assigned by your regional settings. In many regions, a semicolon is required as the separator because a comma is used as the decimal separator.

1
Select the formula cell

Click the cell containing the error, or select an empty cell where you want to enter the formula.

2
Change the argument separators

In the formula bar or directly in the cell, replace each comma between function arguments with a semicolon. For example, change =SUM(A1,B1) to =SUM(A1;B1).

3
Confirm the formula

Press Return to enter the formula. If the separator matches your Excel regional settings, Excel calculates the result instead of showing a formula error.

Replace commas with semicolons in the Excel formula
Use one separator consistently: Keep commas or semicolons consistent throughout the formula. The separator applies to function arguments, not to ranges such as A1:A10.
Free Microsoft Office alternative

Use WPS Spreadsheets for Compatible Formula Editing

If Excel for Mac continues to reject formulas because of regional separator behavior, try WPS Office as a free, lightweight alternative. WPS Spreadsheets offers a familiar worksheet interface, supports common Excel formulas, and lets you open and continue working with existing files without a difficult migration.

Edit formulas and functions in WPS Spreadsheets with a familiar spreadsheet layout.Open, edit, and save Microsoft Excel XLSX and XLS files with format compatibility.Use a free and lightweight Office suite for everyday spreadsheet work.Move existing Excel workbooks to WPS Office with a seamless, familiar workflow.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac require semicolons instead of commas in formulas?

Excel uses the list separator from macOS regional settings. When the selected region uses a comma as the decimal separator, Excel commonly requires semicolons between formula arguments.

How do I know whether my Excel formula should use commas or semicolons?

Check a working formula in the workbook or enter a short test in a blank cell, such as =SUM(1,2) and =SUM(1;2). The version Excel accepts is the correct argument separator for your settings.

Do semicolons replace the colon in an Excel range?

No. Keep the colon for a continuous range, such as A1:A10. Use commas or semicolons only to separate separate function arguments, depending on your regional format.

Where can I change the regional setting that affects Excel formulas on a Mac?

Open the Apple menu and go to System Settings > General > Language & Region. Review or change the Region, then quit and reopen Excel before testing the formula again.

Can I open an Excel workbook with formulas in WPS Spreadsheets?

Yes. WPS Spreadsheets supports common Microsoft Excel XLSX and XLS workbooks, including many standard formulas, so you can open the file and continue editing it.