How to Convert Currencies in Google Sheets
Created by Aaron from Scribe | 6 steps
Create a new Google Sheet at 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)
![Screenshot of: 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=AKIA2JDELI43YPETRQSC&Signature=TLdld8bmqGuhDbO0llWZuaH721o%3D&Expires=1679688791)
Zoom Saved
Aaron made this Scribe in 15 seconds.
Have something to say?Create an account to leave messages for the author to see!
Message sent!
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe