CURRENCY function - Zoho Sheet - Help Guide

CURRENCY

Converts the given value from one currency to another specified currency value.

 

Syntax

 

CURRENCY(value; "from"; "to")

value: The value to be converted. Eg., 3500

from: The currency from which the value is to be converted. Must be given as a currency code. Eg., "USD"

to: The currency into which the value is to be converted. Must be given as a currency code. Eg., "INR"

   

Supported Currency Codes


Currency Code

Currency Name

Country

AED

UAE Dirham

United Arab EmiratesAFN

AFN
Afghan Afghani
Afghanistan
ALL
Albanian Lek
Albania
AMD
Armenian Dram
Armenia
ANG
Netherlands Antillian Guilder
Netherlands Antilles
AOA
Angolan Kwanza
Angola

ARS

Argentine Peso

Argentina

AUD

Australian Dollar

Australia

AWG
Aruban Florin
Aruba
AZN
Azerbaijani Manat
Azerbaijan
BAM
Bosnia and Herzegovina Mark
Bosnia and Herzegovina
BBD
Barbados Dollar
Barbados
BDT
Bangladeshi Taka
Bangladesh

BGN

Bulgarian Lev

Bulgaria

BHD
Bahraini Dinar
Bahrain
BIF
Burundian Franc
Burundi
BMD
Bermudian Dollar
Bermuda
BND
Brunei Dollar
Brunei
BOB
Bolivian Boliviano
Bolivia

BRL

Brazilian Real

Brazil

BSD

Bahamian Dollar

Bahamas

BTN
Bhutanese Ngultrum
Bhutan
BWP
Botswana Pula
Botswana
BYN
Belarusian Ruble
Belarus
BZD
Belize Dollar
Belize

CAD

Canadian Dollar

Canada

CDF
Congolese Franc
Democratic Republic of the Congo

CHF

Swiss Franc

Switzerland

CLP

Chilean Peso

Chile

CNY

Chinese Renminbi

China

COP

Colombian Peso

Colombia

CRC
Costa Rican Colon
Costa Rica
CUP
Cuban Peso
Cuba
CVE
Cape Verdean Escudo
Cape Verde

CZK

Czech Koruna

Czech Republic

DJF
Djiboutian Franc
Djibouti

DKK

Danish Krone

Denmark

DOP

Dominican Peso

Dominican Republic

DZD
Algerian Dinar
Algeria

EGP

Egyptian Pound

Egypt

ERN
Eritrean Nakfa
Eritrea
ETB
Ethiopian Birr
Ethiopia

EUR

Euro

Asutria, Belgium, Cyprus, Estonia, Finland, France, Germany, Greece, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Portugal, Slovakia, Slovenia, Spain

FJD

Fiji Dollar

Fiji

FKP
Falkland Islands Pound
Falkland Islands
FOK
Faroese Króna
Faroe Islands

GBP

Pound Sterling

United Kingdom

GEL
Georgian Lari
Georgia
GGP
Guernsey Pound
Guernsey
GHS
Ghanaian Cedi
Ghana
GIP
Gibraltar Pound
Gibraltar
GMD
Gambian Dalasi
The Gambia
GNF
Guinean Franc
Guinea

GTQ

Guatemalan Quetzal

Guatemala

GYD
Guyanese Dollar
Guyana

HKD

Hong Kong Dollar

Hong Kong

HNL
Honduran Lempira
Honduras

HRK

Croatian Kuna

Croatian

HTG
Haitian Gourde
Haiti

HUF

Hungarian Forint

Hungary

IDR

Indonesian Rupiah

Indonesia

ILS

Israeli Shekel

Israel

IMP
Manx Pound
Isle of Man

INR

Indian Rupee

India

IQD
Iraqi Dinar
Iraq
IRR
Iranian Rial
Iran

ISK

Icelandic Krona

Iceland

JEP
Jersey Pound
Jersey
JMD
Jamaican Dollar
Jamaica
JOD
Jordanian Dinar
Jordan

JPY

Japanese Yen

Japan

KES
Kenyan Shilling
Kenya
KGS
Kyrgyzstani Som
Kyrgyzstan
KHR
Cambodian Riel
Cambodia
KID
Kiribati Dollar
Kiribati
KMF
Comorian Franc
Comoros

KRW

South Korean Won

Korea

KWD
Kuwaiti Dinar
Kuwait
KYD
Cayman Islands Dollar
Cayman Islands

KZT

Kazakhstani Tenge

Kazakhstan

LAK
Lao Kip
Laos
LBP
Lebanese Pound
Lebanon
LKR
Sri Lanka Rupee
Sri Lanka
LRD
Liberian Dollar
Liberia
LSL
Lesotho Loti
Lesotho
LYD
Libyan Dinar
Libya
MAD
Moroccan Dirham
Morocco
MDL
Moldovan Leu
Moldova
MGA
Malagasy Ariary
Madagascar
MKD
Macedonian Denar
North Macedonia
MMK
Burmese Kyat
Myanmar
MNT
Mongolian Tögrög
Mongolia
MOP
Macanese Pataca
Macau
MRU
Mauritanian Ouguiya
Mauritania
MUR
Mauritian Rupee
Mauritius
MVR
Maldivian Rufiyaa
Maldives
MWK
Malawian Kwacha
Malawi

MXN

Mexican Peso

Mexico

MYR

Malaysian Ringgit

Malaysia

MZN
Mozambican Metical
Mozambique
NAD
Namibian Dollar
Namibia
NGN
Nigerian Naira
Nigeria
NIO
Nicaraguan Córdoba
Nicaragua

NOK

Norwegian Krone

Norway

NPR
Nepalese Rupee
Nepal

NZD

New Zealand Dollar

New Zealand

OMR
Omani Rial
Oman

PAB

Panamanian Balboa

Panama

PEN

Peruvian Nuevo Sol

Peru

PGK
Papua New Guinean Kina
Papua New Guinea

PHP

Philippine Peso

Philippines

PKR

Pakistani Rupee

Pakistan

PLN

Polish Zloty

Poland

PYG

Paraguayan Guarani

Paraguay

QAR
Qatari Riyal
Qatar

RON

Romanian Leu

Romania

RSD
Serbian Dinar
Serbia

RUB

Russian Ruble

Russian Federation

RWF
Rwandan Franc
Rwanda

SAR

Saudi Riyal

Saudi Arabia

SBD
Solomon Islands Dollar
Solomon Islands
SCR
Seychellois Rupee
Seychelles
SDG
Sudanese Pound
Sudan

SEK

Swedish Krona

Sweden

SGD

Singapore Dollar

Singapore

SHP
Saint Helena Pound
Saint Helena
SLL
Sierra Leonean Leone
Sierra Leone
SOS
Somali Shilling
Somalia
SRD
Surinamese Dollar
Suriname
SSP
South Sudanese Pound
South Sudan
STN
São Tomé and Príncipe Dobra
São Tomé and Príncipe
SYP
Syrian Pound
Syria
SZL
Eswatini Lilangeni
Eswatini

THB

Thai Baht

Thailand

TJS
Tajikistani Somoni
Tajikistan
TMT
Turkmenistan Manat
Turkmenistan
TND
Tunisian Dinar
Tunisia
TOP
Tongan Paʻanga
Tonga

TRY

Turkish Lira

Turkey

TTD
Trinidad and Tobago Dollar
Trinidad and Tobago
TVD
Tuvaluan Dollar
Tuvalu

TWD

New Taiwan Dollar

Taiwan

TZS
Tanzanian Shilling
Tanzania

UAH

Ukrainian Hryvnia

Ukraine

UGX
Ugandan Shilling
Uganda

USD

US Dollar

United States

UYU

Uruguayan Peso

Uruguay

UZS
Uzbekistani So'm
Uzbekistan
VES
Venezuelan Bolívar Soberano
Venezuela

VND

Vietnamese Dong

Vietnam

VUV
Vanuatu Vatu
Vanuatu
WST
Samoan Tālā
Samoa
XAF
Central African CFA Franc
CEMAC
XCD
East Caribbean Dollar
Organisation of Eastern Caribbean States
XDR
Special Drawing Rights
International Monetary Fund
XOF
West African CFA franc
CFA
XPF
CFP Franc
Collectivités d'Outre-Mer
YER
Yemeni Rial
Yemen

ZAR

South African Rand

South Africa

ZMW
Zambian Kwacha
Zambia
ZWL
Zimbabwean Dollar
Zimbabwe

Note : The data provided is for informational purpose only and may be delayed up to 30 minutes. 


Examples  

 

Formula

Result

=CURRENCY(3500;"USD";"INR")

250392.584995

=CURRENCY(A3;B3;C3)

1.108267113

=CURRENCY(50;"CNY";"INR")

507.275089725


Get a hands-on experience of the function in the embedded range below.



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.


    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • What are all the cell formats available in Zoho Sheet?

                                                                                                                Zoho Sheet supports the following cell formats: General Number Accounting Currency Date Time Percentage Fraction Scientific Text Regional And custom made formats.
                                                                                                              • DOLLAR

                                                                                                                Converts the given number to text and applies a currency symbol based on the user's locale settings.   Syntax   DOLLAR(number; [decimals]) number: The number you want to convert into text, currency format. E.g. 12.5 decimals: The number of decimal ...
                                                                                                              • Unsupported features in file export

                                                                                                                While Zoho Sheet supports an extensive set of features for users to collect, organize, scrutinize, and visualize their data, some of these options may not be available on exporting the spreadsheet. Here's the list of features or options that will not ...
                                                                                                              • Locale and calculation settings in your spreadsheet

                                                                                                                To customize the gridline color and font of your spreadsheet: Go to File > Spreadsheet Settings. In the Spreadsheet Settings tab under General, select the preferred Font Name, Font Size, Text Color, and Gridline Color. Click OK. To customize the ...
                                                                                                              • PRICE

                                                                                                                Returns the price per 100 currency units of a security with periodic interest.   Syntax   PRICE(settlement; maturity; rate; yield; redemption_value; frequency; [basis]) settlement: The date of purchase of the security. Eg., "2/1/2018" maturity: Date ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources