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.

Redefine the way you work

with Zoho Workplace

Start your free trial

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.

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

Zoho Workerly Home
Forums
Connect With Us:

Zoho Recruit Home
Forums
Connect With Us:

Start tracking your website metrics today

Use PageSense to understand what your visitors are looking for, how they are behaving, and where they are facing problems on your website.

Ready to improve your website's performance?

Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.

Track and measure every business goal

Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.

Understand the customer journey on your website

Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.

Visualize your visitor's behavior with color codes

Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.

Measure customer engagement with your web forms

Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.

Record real visitor interactions on your website

Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.

Test and optimize webpages for better conversions

Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.

Give each customer a unique website experience

Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.

Grow your business through customer feedback

Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.

Send timely updates that customers love

Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.

Advertise your business to website visitors

Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.

Access more advanced settings in PageSense

Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.

Try easy-to-use extensions

Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.

Discover your favorite integrations with PageSense

Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.

Quick Links	Workflow Automation	Data Collection
Web Forms	Enterprise	Begin Data Collection
Interactive Forms	Workplace	Data Collection App
CRM Forms	Customer Service	Accessible Forms
Digital Forms	Marketing	Forms for Small Business
HTML Forms	Education	Forms for Enterprise
Contact Forms	E-commerce	Forms for any business
Lead Generation Forms	Healthcare	Forms for Startups
Wordpress Forms	Customer onboarding	Order Forms for Small Business
No Code Forms	Construction	RSVP tool for holidays
Free Forms	Travel
Prefill Forms	Non-Profit
Intake Forms	Legal	Mobile App
Form Designer	HR	Mobile Forms
Card Forms	Food	Offline Forms
Assign Forms	Photography	Mobile Forms Features
Translate Forms	Real Estate	Kiosk in Mobile Forms
Electronic Forms
Notification Emails for Forms	Alternatives	Security & Compliance
Holiday Forms	Google Forms alternative	GDPR
Form to PDF	Jotform alternative	HIPAA Forms
Email Forms		Encrypted Forms
Embeddable Forms		Secure Forms
Drag and Drop form builder		WCAG

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

Zoho Pagesense Resources

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.

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho Social?

Manage your brands on social media

Access Zoho Social

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Zoho Sheet Resources

New to Zoho Forms?

Latest Feature Updates

Explore our Pricing & Plans

Zoho Forms Resources

Secure your business

communication with Zoho Mail

Get started

Mail on the move with

Zoho Mail mobile application

Go Mobile

Stay on top of your schedule

at all times

Get started

Carry your calendar with you

Anytime, anywhere

Get started

Latest Announcements

New to Zoho Sign?

Zoho Sign Resources

Sign, Paperless!

Sign and send business documents on the go!

Get Started Now

Zoho SalesIQ Resources

New to Zoho TeamInbox?

Zoho TeamInbox Resources

Connect with us

New to Zoho ZeptoMail?

LEARN MORE

Latest Feature Updates

Zoho DataPrep Resources

New to Zoho DataPrep?

Access Zoho DataPrep

Zoho DataPrep Demo

Get a personalized demo or POC

Design. Discuss. Deliver.

Create visually engaging stories with Zoho Show.

Get Started Now

New to Zoho Workerly?

Access Zoho Workerly

New to Zoho Recruit?

Access Zoho Recruit

New to Zoho CRM?

Signup Now

Access Zoho CRM

Latest Feature Updates

New to Zoho Projects?

Access Zoho Projects

New to Zoho Sprints?

Access Zoho Sprints

New to Zoho Assist?

Access Zoho Assist

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

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 ...