Fix Formula Separator Errors When Entering Formulas in Excel for Mac
Question details
The user needs to enter formulas successfully in Excel for Mac when the formula is rejected because of an argument separator mismatch.

- 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.
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.
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.
Click the cell containing the error, or select an empty cell where you want to enter the formula.
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).
Press Return to enter the formula. If the separator matches your Excel regional settings, Excel calculates the result instead of showing a formula error.

Review the macOS region used by Excel
Use this solution if both comma- and semicolon-based formulas fail, or if formulas behave differently after changing regions.
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.

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.




