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;
• Alphabetical currency code;
• Digital currency code.

Main Features Functions ISOCOUNTRY

Syntax:

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

Parameters:

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

Example Usage

The ISOCOUNTRY() function is easy to use. You just need to specify the name or country code and the type of data you want to retrieve and LibreOffice 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 - The name of the country for which we are looking for information ("Albania").
• DataType: E2 - Type of data we want to get: three-letter country code ("3").
• CurrentCell: E4 - Current formula cell.

Features of application

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

Download the extension

You can use the ISOCOUNTRY() function by installing the extension "YLC_Utilities.oxt" .

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