Save for Later
This guide was created with Scribe in
15 seconds.
Sign in and create your own!
How to Convert Currencies in Google Sheets
Aaron Podolny
|
0 step
|
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
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
6
Copy and paste the formula for other rows.
Zoom Saved
Was this Scribe helpful?
Save this document for future reference.
Save for Later
Have something to say?
Create an account to leave messages for the author to see!
Create an account
Feedback
This Scribe is in tip-top shape!
Leave feedback if there are any issues with this Scribe