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”))

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