CODEWITHSUNDEEP
google-sheetsgoogle-docscurrency
Даниил Пронин
Даниил Пронин

Reputation: 1306

How to convert currency in Google Docs Spreadsheet cell?

Okay I have a cell with Russian Roubles and want to convert them into US Dollars. What is the formula? I tried to find some keywords with =something (currency,finance,convert,dollar,double,ruble and much more) but found nothing.

Upvotes: 1

Views: 1943

Answers (1)

EnGassa
EnGassa

Reputation: 2937

There are certain function available in Google Spreadsheets to interact with other Google services such as Finance. To get the realtime exchange rate between currencies and set up conversion you could follow these steps:

  • Get the exchange rate between currencies in a cell, or use it directly in a formula using the function: GoogleFinance("CURRENCY:EURUSD"). The format is GoogleFinance("CURRENCY:<from-currency><to-currency>")
  • Use it in a formula: =C4*GoogleFinance("CURRENCY:EURUSD")

Upvotes: 2

Related Questions