How to Convert Currencies in Google Sheets
5 steps | 15 seconds | Created by Aaron from Scribe
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)
![Add this formula: [[=A2*GOOGLEFINANCE("CURRENCY:USD"&B2)]]](https://colony-recorder.s3-accelerate.amazonaws.com/files/2022-03-25/e8b16815-801c-4201-b59e-317b715b80d6/user_cropped_screenshot.jpeg?AWSAccessKeyId=AKIA2JDELI434TBIMF7V&Signature=80QXgALdMYva9IXTuJlXqxdCJrc%3D&Expires=1653669928)
Zoom Saved