All Collections
Frequently Asked Questions
Troubleshooting
International Syntax for Custom Functions
International Syntax for Custom Functions

Learn how to use the list separator feature in the Cryptosheets API Console Query Builder

C
Written by Chris Ware
Updated over a week ago

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 ,

Did this answer your question?