Save
this Page
This guide was created with Scribe in
15 seconds.
Sign in and create your own!
How to Convert Currencies in Google Sheets
Created by Aaron from Scribe
|
6 steps
Google
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
Have something to say?
Create an account to leave messages for the author to see!
Create an account
Message sent!
Feedback
This Scribe is in tip-top shape!
Leave feedback if there are any issues with this Scribe