Save this Scribe
Save
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
Zoom Saved
3
Add a column of currency codes
Zoom Saved
4
Double-click here:
Zoom Saved
5
Add this formula:
=A2*GOOGLEFINANCE("CURRENCY:USD"&B2)
Zoom Saved
Aaron made this Scribe in 15 seconds.
Show Me How
3