How to convert currency in Excel and Google Sheets

Excel & Google Sheets

=A2*B2

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

=A2*B2→92

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Formula

Runs server-side · free · no signup

1Enter the original amount in column A and the exchange rate in column B (e.g., 1.08 to convert USD to EUR at 1.08).
2In the Converted Amount column, enter =A2*B2 to compute the converted value.
3For multiple currencies, create a rate lookup table and use =A2*VLOOKUP(currency_code,rate_table,2,0) to pull the correct rate automatically.

In Google Sheets, you can use the GOOGLEFINANCE function to pull live exchange rates: =GOOGLEFINANCE("EURUSD") returns the current EUR/USD rate.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Use Excel's built-in Currencies data type (Insert > Data > Currencies) or connect to a web data source via Power Query to pull live rates.

Divide by the rate instead of multiplying: =A2/B2 converts from the target currency back to the source.

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026