We can use the GOOGLEFINANCE function to get live currency exchange rates directly within Google Sheets. Let’s learn how we can use the GOOGLEFINANCE function to easily convert currencies in Google Sheets.
How to Convert Currencies in Google Sheets
For example, if you want to convert 100 U.S. dollars into Indian rupees, you can do this by selecting the cell where you want the result to be displayed and typing the following formula:
=A2*GOOGLEFINANCE("CURRENCY:USDINR")
In this formula:
- A2 is the cell reference containing the value that you want to convert (e.g., 100).
- USD is the base currency you are converting from.
- INR is the target currency you are converting to.
Once the formula has been entered, simply press the ENTER key, and the cell will display the live converted amount based on current exchange rates.
