12/27/2023 0 Comments Google currency converter![]() We will refer to these cells to specify the currency pair that we are converting between in the GOOGLEFINANCE function. In this example, the first currency code (the currency that we are converting from) is entered into cell A2, and the second currency code (the currency that we are converting to) is entered into cell B2. This makes it easy to change the codes for the conversions. ![]() This will allow you to enter the three letter currency code into the cells, instead of having to type them directly into the formula. If you want, you can use cell references when converting currencies with the GOOGLEFINANCE function. Using cell references to convert currency Later I will show you how to use this conversion rate to find the actual amounts when converting currencies, but first let's go over how to use cell references in these currency conversion formulas.Ĭheck out this lesson if you want to learn how to format values as currency. Dollars and Euros).Īs you can see in the image above, the formula entered into cell A2 shows that the conversion rate for the USD / EUR currency pair was 0.91474 (at the time the image was captured).Ī conversion rate of 0.91474 means that each unit of the first currency (USD) is worth 0.91474 of the second currency (EUR). This tells Google Sheets to retrieve the conversion rate between two currencies (U.S. The entire criteria for the function looks like this: "CURRENCY:USDEUR" The final formula will look like this =GOOGLEFINANCE("CURRENCY:EURUSD") To convert currencies in Google Sheets, use the GOOGLEFINANCE function like this =GOOGLEFINANCE("CURRENCY:Currency1Currency2") where "Currency1" is the 3-letter currency code of the currency you are converting from, and where "Currency2" is the three-letter currency code of the currency you are converting to. When we specify the currency pair that we are converting between, we simply type the first currency code followed by the second currency code, with no spaces or characters between them, like this: USDEUR In this example we are going to use the GOOGLEFINANCE function to convert from U.S. Now let's go over an example of converting from one currency to another currency. Converting back to the original currencyĬonverting currency with the GOOGLEFINANCE function.Finding the converted currency amount (Multiplying rate by the amount).Using cell references to convert currency.Converting currency with the GOOGLEFINANCE function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |