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:

=SUM(A1,C1,E1)

And like this in Italy:

=SUM(A1;C1;E1)

Link to further explanation

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

=CSPRICE("BTC","USD"), CSPRICE("BTC";"USD"), ; vs ,

Did this answer your question?