CURRENCY
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! |
|
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
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 ...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 ...PRICEDISC
Calculates the price per 100 currency units of face value for a discounted security. Syntax PRICEDISC(settlement; maturity; discount; redemption_value; [basis]) settlement: The date of purchase of the security. Eg., "2/1/19" maturity: Date on ...ODDFPRICE
Returns the price per 100 currency units of a security having an odd or irregular first period. Syntax ODDFPRICE(settlement; maturity; issue_date; first_interest_date; rate; yield; redemption_value; frequency; [basis]) settlement: The date of ...