How to Convert Currencies in Google Sheets | Scribe

    How to Convert Currencies in Google Sheets

    • Google SheetsGoogle Sheets
    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.