How to convert currencies in Google Sheets?
Tagged: google sheets
Viewing 1 post (of 1 total)
- AuthorPosts
- August 6, 2021 at 12:28 PM #5099
Santhosh Kumar D
Keymaster@santhoshWe can use the
GOOGLEFINANCE
function to get live currency rates in Google Sheets. Let’s learn how we can use theGOOGLEFINANCE
function to convert currencies in Google Sheets.For example, to convert 100 U.S dollars to Indian rupees, select the cell you want the result to be displayed and type the formula
=A2*GOOGLEFINANCE("CURRENCY:USDINR")
where A2 is the cell number of the value that you want to convert, USD is the currency you want to convert, and INR is the currency you want to convert to.Once the formula has been entered, press
ENTER
and you will see a result like the following.
- AuthorPosts
Viewing 1 post (of 1 total)
Advertisement
RECENT TIPS
- How to send email as an alias in Gmail?
- How to stop Google from tracking your location?
- Command to check the Ubuntu version
- How to add a percentage in Excel?
- How to convert currencies in Google Sheets?
- How to voice type on Google Docs?
- What is Django framework?
- How to turn Google Assistant off?
- How to check the Python version?
- How to create a virtual environment in Python?
- How to change the directory in the Command Prompt?
- How to add a shortcode in WordPress PHP template file?
- Useful websites to research stocks
- How to check Linux uptime?
- How to check Linux last reboot time?