How to convert currencies in Google Sheets?

We can use the GOOGLEFINANCE function to get live currency rates in Google Sheets. Let’s learn how we can use the GOOGLEFINANCE 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.