This is pretty useful and I can never remember the exact syntax, so here it is for me (and now you) to remember.
In a Google spreadsheet, you can do an online currency conversion that looks up the exchange rate in real time, making my life much easier.
For example to get EUR to GBP just type
=googlefinance(("CURRENCY:EURGBP"))
(note: if you copy and paste this and get an error, replace the quotation marks ( ” ) with your own. For some reason the blog template sometimes changes the quote symbol into it’s own format. I think I’ve fixed it but just in case…)
which will give you the rate ( you can then use that to convert existing cells to whatever currency you wish)
This makes it really easy to build an expense forecasting sheet like this that auto updates the exchange rate
|