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)
  • 1
    Aside: A would be divided by 1 not by 0. The conversion factor from a currency to itself is 1.
    – user135384
    Apr 27, 2018 at 17:05

1 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")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.