Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert currency in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=A2*B2✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Amount (USD) | Exchange Rate | Converted Amount |
| 100 | 0.92 | |
| 500 | 1.25 | |
| 1000 | 0.75 | |
| 250 | 1.1 |
=A2*B2→92
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 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.
Tips
- In Google Sheets, you can use the GOOGLEFINANCE function to pull live exchange rates: =GOOGLEFINANCE("EURUSD") returns the current EUR/USD rate.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I get live exchange rates in Excel?
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.
How do I convert in the other direction?
Divide by the rate instead of multiplying: =A2/B2 converts from the target currency back to the source.
More on Finance basics
See all →How-to
How to calculate tiered commission
Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.
How-toHow to calculate gross margin
Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.
How-toHow to calculate compound interest
Compute a compounded future value with principal × (1 + rate)^years using POWER. Identical in Excel and Google Sheets.
How-toHow to calculate cost per unit
Divide total cost by total units to find cost per unit using a simple formula in Excel or Google Sheets.
How-toHow to calculate a selling price from a target margin
Use cost and target gross margin percentage to back-calculate the required selling price in Excel or Google Sheets.
How-toHow to calculate simple interest
Multiply principal, rate, and time to compute simple interest using a straightforward formula in Excel or Sheets.