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)
TAGS: troublshooting, formula, name!, error, international, googlesheets, google sheets, =CS.PRICE("BTC","USD"), CS.PRICE("BTC";"USD"),
=CSPRICE("BTC","USD"), CSPRICE("BTC";"USD"), ; vs ,