IsoCountry function

ISOCOUNTRY() Description

The ISOCOUNTRY() function returns the name and codes for the specified country according to ISO (International Standard Organisation) standard. Additional data is also available.

List of available information:

• ISO country name;
• Digital code;
• Two-letter code;
• Three-letter code;
• Short name of the country;
• Telephone code;
• Currency name;
• Currency letter code;
• Digital currency code.

Main Features ISOCOUNTRY Functions

Syntax:

=ISOCOUNTRY(Country; DataType; CurrentCell; [SearchType])

Parameters:

• Country: Country name or code. If a country code is specified, the appropriate search type must be specified in the parameter "SearchType" .
• DataType: The type of data you want to retrieve: 0-ISO country name, 1-digit code, 2-two-letter code, 3-three-letter code, 4-short country name, 16-telephone code, 17-currency name, 18-letter currency code, 19-digit currency code.
• CurrentCell: The cell reference of the current formula.
• [SearchType]: Optional. Search type: 0-country name, 1-digit code, 2-two-letter code, 3-three-letter code. Default is 0.

Example Usage

The ISOCOUNTRY() function is easy to use. You just need to specify the country name or code and the type of data you want to retrieve and LO Calc will automatically return the selected values for the specified country:

=ISOCOUNTRY(Country; DataType; CurrentCell)

We will have the following result:

This example uses the following values:

• Country: A4 - Name of the country for which we are looking for information ("Albania") .
• DataType: E2 - Type of data we want to retrieve: three-letter country code ("3") .
• CurrentCell: E4 - The cell of the current formula.

Application features

This function performs an approximate search if the country name is misspelled or in a different format. For this, the function is used FUZZYLOOKUP() If the value found is the result of an approximate search, the cell text will be highlighted in red.

Download extension

You can use the function ISOCOUNTRY() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in LibreOffice Calc .