Do you know that it is possible to change the currency in Google Sheet.? In this guide, I will explain to you how to do this. The online spreadsheet app comes with the function GOOGLEFINANCE. It can convert the currencies of one type to another based on the latest exchange rates. Here lies the twist. You do not have to find out or know the exchange rates. This function does that job for you.
The exchange rates on Google Sheets keep updating every 20 minutes. Now, that’s just Google’s way of doing things. I have explained the format of the GOOGLEFINANCE function and how to use it. Also, I have demonstrated how to find the exchange rate when trying to change from one currency to another. Let’s get into the guide.
Also Read
How To Change Currency In Google Sheets
First, let’s see how to get the exchange rate for comparing or converting two currencies. Though Google Sheet provides the latest exchange rate, it mentions that exchange rates may be delayed. Its quotes are not sourced from all the financial markets of the world. It disclaims all the data they provide is solely for information purposes. People are advised not to use it for trading or similar activities.
Finding the Exchange rate on Google Sheets
Here are the steps. Let’s check for exchange rates for USD and INR. USD is US Dollar and INR is the Indian currency.
- Open Google Sheets
- In the fx section put the following format =GOOGLEFINANCE(“Currency:USDINR”)
- You can use any currency you want to instead of the ones that I have used
- As you press enter you should see the current exchange value between the two currencies
- For USD and INR you will see the exchange rate is 73.7383
