How to Convert Currencies in Google Sheets
- |
- 0 step |
- 15 seconds
Create a new Google Sheet at [https://sheets.new](https://sheets.new)
Create a column of prices in USD
Zoom Saved
Add a column of currency codes
Zoom Saved
Double-click here:
Zoom Saved
Add this formula: [[=A2*GOOGLEFINANCE("CURRENCY:USD"&B2)]]
Zoom Saved
Copy and paste the formula for other rows.
Zoom Saved
Was this Scribe helpful?
Save this document for future reference.
Save this document for future reference.
Have something to say?Create an account to leave messages for the author to see!
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe