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"

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.

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.

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.

CURRENCY function - Zoho Sheet - Help Guide

CURRENCY