Gone are the days or keying in and manually updating an exchange rate in a cell of a spreadsheet and using that to perform currency conversions. Many of the formulas and functions available in Google docs spreadsheets are plugged into the real time web. Currency conversion calculations can always be up to date without having to look up an exchange rate. Here’s one way to do it:
- In a Google Docs spreadsheet use the GoogleFinance() function to get an exchange rate. For example, to get the exchange rate from US dollars to Euros you would enter:
- To convert the value in a cell representing an amount in one currency to another currency, multiply the cell reference by the currency conversion formula above in another cell. For example, if the amount in US dollars is in cell A2, we can put the equivalent amount in Euros in cell B2 by entering the following formula in B2:
Why This Works
Currency conversions using the GoogleFinance() function take the following form:
=GoogleFinance("CURRENCY:<from currency symbol><to currency symbol>)
For example, to go from Canadian dollars to Philippine pesos, you’d use the following formula:
where CAD is the currency symbol for Canadian dollars and PHP is the currency symbol for Philippine pesos. You can find a complete and searchable list of currency symbols that can be used with this formula here.