Google sheet currency conversion, automatic by GOOGLEFINANCE

Do you know just how much you need to type 100 euros to us dollars on the google search bar immediately get the exchange rate of 100 euros to the dollar.

Currency converter:

Currency converter automatically uses updated google sheets at the latest exchange rates

Convert EUR to USD by Google

And of course, this exchange rate is updated exactly by Google to the minute like gold, so it is very useful.

So if we have more than 2 types of exchange rates to convert. For example, what about Euro to Usd and want Usd to switch to Japanese Yen? Or as you need to convert a lot of different denominations, do it.

GOOGLEFINANCE function on Google Sheets uses Google data itself and is the most useful answer for this case.

Google sheet currency conversion:

= A3 * GOOGLEFINANCE ("CURRENCY: EURUSD")

In the formula, A3 is the cell value you use to convert, EUR is the currency you want to convert, USD is the currency you want to convert to.

Google sheet currency conversion

For example, in cell A3 you enter 100 Euro. In cell B3, enter the formula above and press Enter. Google Sheets will automatically calculate and convert from 100 Euro how many dollars will be generated at the latest exchange rate.

Do the same in cell C3 you enter = A3 * GOOGLEFINANCE ("CURRENCY: USDJPY")

Will convert from USD to YEN Japanese

And if you have a lot of exchange rates, just dragging the mouse from top to bottom is done very quickly right.
If you do not know the currency code of each country, please click here: link

"This table lists the ISO 4217 codes you can use to specify the currency of monetary values."

A little trick if you don't know how to display the currency symbol equivalent to each currency of the respective countries, do the following:

Select cell A3, then select Format> Number> More Formats menu> More Currency:

how to display the currency symbol equivalent to each currency

Popup Custom Currencies appear you enter the currency you want into the search box, here I need to find the form of EURO so I will enter the Euro. Click Apply to finish the other currencies.

Custom Currencies

Very beautiful, isn't it?

In case you want to present the old exchange rate and the new exchange rate, you can try adding a dash between the old exchange rate and still see the old and very coherent exchange rate. If you do not know how to add Strikethrough on google sheets, this is a guide for you: Strikethrough google docs

Post by Son Nguyen · in 05-11-2019 · view: 1325