How to Convert Currencies in Google Sheets | Scribe

    How to Convert Currencies in Google Sheets

    • |
    • 6 steps |
    • 15 seconds
    1

    Create a new Google Sheet at [https://sheets.new](https://sheets.new)

    2

    Create a column of prices in USD

    3

    Add a column of currency codes

    4

    Double-click here:

    5

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

    6

    Copy and paste the formula for other rows.