Convert multiple currencies and total the results in one cell

Question

I have 4 currency columns (GBP, Euro, DKK, SKK). I then want to convert them to GBP in the 'Total Column. Is there a formula to look at all 4 currency columns and then convert to GBP in the specific exchange rate I enter?

Cell A | Cell B | Cell C | Cell D | Cell E 
GBP    | Euro   | DKK    | SKK    | (A/0, B/1.11, C/8.25, D/11.8)

Answer 1

The function googlefinance provides the current exchange rates for all these currencies. For example, this converts the amounts in A1, B1, C1, D1 from (GBP, EUR, DKK, SKK) to GBP, and adds them.

=A1 + B1*googlefinance("currency:EURGBP") 
    + C1*googlefinance("currency:DKKGBP") 
    + D1*googlefinance("currency:SKKGBP")