How to Convert Currencies in Google Sheets

6 steps | 15 seconds | Created by Aaron from Scribe

Create a new Google Sheet at sheets.new

Create a column of prices in USD

Screenshot of: Create a column of prices in USD

Zoom Saved

Add a column of currency codes

Screenshot of: Add a column of currency codes

Zoom Saved

Double-click here:

Screenshot of: Double-click here:

Zoom Saved

Add this formula: =A2*GOOGLEFINANCE("CURRENCY:USD"&B2)

Screenshot of: Add this formula: [[=A2*GOOGLEFINANCE("CURRENCY:USD"&B2)]]

Zoom Saved

Aaron made this Scribe in 15 seconds.

Favorite this Scribe?

Add to your favorites for easy access and receive notifications for any changes.