How to Convert Currencies in Google Sheets | Scribe

How to Convert Currencies in Google Sheets

5 steps | 15 seconds | Created by Aaron from Scribe
google.com
1
Create a new Google Sheet at 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)

Aaron made this Scribe in 15 seconds.