How to Convert Currencies in Google Sheets
Aaron Podolny
|
6 steps
|
15 seconds
Google Sheets
1
Create a new Google Sheet at [https://sheets.new](https://sheets.new)
2
Create a column of prices in USD
3
Add a column of currency codes
4
Double-click here:
5
Add this formula: [[=A2*GOOGLEFINANCE("CURRENCY:USD"&B2)]]
6
Copy and paste the formula for other rows.