Converts the given value from one currency to another specified currency value.
Syntax
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"
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 |
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
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.