This article explains the function list separator used in Excel functions.

By default, Excel uses the list separator defined under regional controls in Control Panel.

This impacts how functions are entered in Excel.

There’s a problem with this formula

In the United States, and countries like Canada, Australia, United Kingdom, etc.

functions are entered withargumentsseparated by commas.

In other countries like Spain, France, Italy, Netherlands, Germany, functions are entered with semicolons.

There’s a problem with this formula

If for some reason this box is unchecked, Excel won’t inherit the regional list separator described above.

There’s a problem with this formula

There’s a problem with this formula

There’s a problem with this formula

Windows advanced regional settings button

Excel list separator options