Recently I needed to convert some figures from British pounds to dollars for use in a spreadsheet. My original idea was that I’d just plug the numbers into a converter on the internet and then copy and paste. That would have worked well enough, but it wasn’t the best way.

Google has all kinds of little tricks up their sleeve and built right into Google Spreadsheets. You can even build a formula that asks Google Finance for the latest info on currency exchange rates between the currency of interest. It looks like this:

=B3*GoogleFinance(“Currency:gbpusd”)

The gbp is for pounds, and usd for dollars, and you can easily swap them if you want to convert the other way, or find the symbols for other currencies. Of course, you replace the cell number with the one you’re using.

Awesome.

Advertisements