List Seperator

By default, Excel & sometimes Googlesheets uses the list separator defined under regional settings in Control Panel. The US English version of Excel uses a comma (,) for list separator by default, while other international versions may use a semicolon (;).

👉 This impacts how functions are entered in Excel & Googlesheets

In the United States, and countries like Canada, Australia, United Kingdom, etc. functions are entered with arguments separated by commas.

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

For example, the SUM would be entered like this in the US:


And like this in Italy:


Link to further explanation

TAGS: troublshooting, formula, name!, error, international, googlesheets, google sheets, =CS.PRICE("BTC","USD"), CS.PRICE("BTC";"USD"),


Did this answer your question?