For a basic Excel exchange rate formula, multiply the amount by the rate when the rate tells you how many units of the target currency one unit of the original currency buys. For example, if A2 contains 250 US dollars and B2 contains 0.92 euros per US dollar, enter =A2*B2 in C2 to return 230 euros.
The basic currency conversion formula
Excel does not have one universal exchange-rate formula that automatically knows your currencies or the direction of a quote. The arithmetic is straightforward once you identify what the rate means: multiply when the rate is expressed as target currency per one unit of source currency, and divide when it is expressed in the opposite direction.
For the example above, the cell layout is A2 = 250 USD, B2 = 0.92 EUR per USD, and C2 = the converted amount in EUR. Enter =A2*B2 in C2. The result is 230 EUR because 250 × 0.92 = 230. The result is only as current or reliable as the rate entered in B2.
Use clear column labels so the number cannot be mistaken for a different currency or quote direction. For example, label B1 “EUR per USD,” not simply “Rate.” A compact table might have columns for Amount, From, To, Rate, and Converted amount. This becomes especially helpful when a workbook contains transactions in several currencies.
How to tell whether to multiply or divide
Exchange rates can be quoted in either direction. A quote of 0.92 EUR per USD means one US dollar is worth 0.92 euros. A quote of 1.09 USD per EUR means one euro is worth about 1.09 dollars. These quotes describe essentially the same relationship, but the number and the unit order differ.
If B2 contains 0.92 EUR per USD and A3 contains 230 EUR, the cell layout is A3 = the EUR amount, B2 = EUR per USD, and C3 = the USD result. Enter =A3/B2 in C3. The result is 250 USD because 230 ÷ 0.92 = 250. Dividing here reverses the original conversion direction.
A quick unit check can catch many mistakes: write out the units beside the numbers. In “250 USD × 0.92 EUR/USD,” the USD units cancel, leaving EUR. If the units do not cancel to the currency you want, reverse the rate or use division. Do not decide based only on whether an exchange-rate number is above or below 1; that depends on the currencies and quote direction.
Make a reusable conversion table
For a one-off calculation, entering the amount and rate directly is enough. For a list of transactions, put each amount and its applicable rate on the same row, then copy the calculation down. Keeping the rate beside the transaction makes it easier to review later and avoids accidentally applying one rate to every date or currency pair.
For a reusable example, assume A2:A10 contains amounts in USD, B2:B10 contains the corresponding EUR-per-USD rates, and C2:C10 is for EUR results. In C2 enter =A2*B2, then fill the formula down through C10. The relative references adjust by row, so C3 uses A3 and B3. If A2 is 250 and B2 is 0.92, C2 returns 230; another row uses its own amount and rate.
To fill the formula down, select C2 and drag the small square at the lower-right corner of the selection, or copy C2 and paste into the destination cells. In Excel for Microsoft 365 on Windows, Ctrl+C and Ctrl+V copy and paste; on Mac, use Command+C and Command+V. For a table that expands as new rows are added, select the data and choose Insert > Table. Excel tables can carry a formula into new rows automatically.
Where to get an exchange rate in Excel
A formula calculates a conversion; it does not by itself supply a trustworthy current rate. You can type in a rate from a source you trust, import rates into the workbook, or—in supported Microsoft 365 installations—try Excel’s linked Currencies data type. Rates vary by provider, purpose, and timing. A public reference rate may not match the rate a bank, card issuer, or payment service actually applies.
- Enter a rate manually: Record the source and the date or time alongside it. This is a practical choice for a fixed historical calculation or a small number of conversions.
- Use the Currencies data type: Enter a supported currency pair such as USD/EUR, select the relevant cells, and choose Data > Data Types > Currencies. If the option is available for your Excel account and region, Excel can link the pair to online data. Use the data card or Insert Data options to see which fields are available, then use the returned rate in your conversion calculation.
- Import a rate table: Power Query can bring data from a supported file or web source into a worksheet. The data source, its access rules, and its update behavior matter; an import is not automatically a live quote.
Linked data types and imported data depend on online access and service availability. Refresh linked or imported information with Data > Refresh All, where supported, and check the displayed update information. A refresh does not guarantee a particular provider, a real-time market quote, or the rate used by a financial institution. Excel for the web has a different interface in some areas, and available data features can depend on the account. On Mac, data-type availability and controls may also differ from Windows.
Format results and choose sensible precision
Formatting changes how a value appears, not the underlying calculation. To show a converted result as currency, select the result cells and choose Home > Number, then select a currency or accounting format. Choose the symbol and decimal places appropriate to the target currency. Do not assume every currency should be displayed with two decimal places; conventions differ, and a business may have its own reporting rules.
If A2 contains 250 USD and B2 contains 0.9237 EUR per USD, the cell layout is A2 = source amount, B2 = rate, and C2 = converted result. To calculate a value rounded to two decimal places, enter =ROUND(A2*B2,2) in C2. It returns 230.93 because 250 × 0.9237 = 230.925, which rounds to 230.93. The unrounded product remains available if you use the basic multiplication formula and only format the cell to show two decimals.
That difference matters when adding many rows. Formatting a value to two decimals can hide extra digits without removing them, while ROUND changes the calculated value. Follow the rounding approach required for the task and keep enough precision in intermediate calculations when appropriate. For invoices or reconciliations, compare the workbook’s rounding method with the relevant provider’s statements or documented process.
Use the right rate for the date and purpose
Exchange rates change over time, so a rate that is suitable today may not be suitable for a transaction from last month. For historical bookkeeping, analysis, or a dated report, use a rate applicable to the relevant transaction date and follow the rules or procedures that apply to that work. A current online rate is not a substitute for a historical rate simply because it is easier to retrieve.
Also distinguish a reference or mid-market rate from the amount a customer actually receives. A bank or payment provider may use its own rate, add a spread, charge a separate fee, or apply a rate at a particular processing time. Those details affect the real amount paid or received. Excel can calculate from the inputs you give it, but it cannot determine which rate or fee applies to your account.
For repeatable work, keep the source, quote direction, applicable date, and any relevant fee information with the rate. This context makes the workbook auditable: another person can tell where the number came from and why it was used. Avoid silently replacing a historical rate with a newly refreshed one if the workbook is meant to preserve a past calculation.
Common errors and how to troubleshoot them
- The result is far too large or too small: Check whether the rate is quoted in the direction your formula assumes. A reciprocal rate can turn a plausible result into a large error.
- The answer shows a symbol for the wrong currency: The cell’s number format affects the displayed symbol, not the conversion. Set the format to the target currency and verify the arithmetic separately.
- The formula returns an error: Check that the amount and rate are numeric values rather than text. Imported data can contain spaces, symbols, or text labels that prevent calculation.
- The result differs from a card or bank statement: The provider may use a different rate, processing time, or fee. Compare the inputs and transaction terms rather than assuming the spreadsheet formula is wrong.
- A linked rate does not update: Check internet access, the linked data card, and Data > Refresh All. The source may not refresh continuously, and availability can vary by account or region.
A useful check is to convert an amount and then reverse the conversion using the same unrounded rate. If the original amount is not recovered, inspect the quote direction, cell references, and rounding. Small differences can occur when you deliberately round intermediate results.
Frequently Asked Questions
What is the formula to convert USD to EUR in Excel?
Multiply the USD amount by a rate expressed as EUR per USD. If A2 contains USD and B2 contains EUR per USD, enter =A2*B2 in the result cell. Confirm the rate’s direction before using it.
Does Excel have a built-in exchange rate formula?
Excel’s basic worksheet formulas do not automatically identify and retrieve a universal live rate. You can multiply or divide using a rate in your sheet, and some Microsoft 365 versions offer linked Currencies data types or data-import options that can provide rate information.
How do I convert euros back to dollars?
If you have a EUR amount and a rate in EUR per USD, divide the EUR amount by that rate. Alternatively, use a rate quoted as USD per EUR and multiply. The units in the rate determine the correct operation.
How can I refresh exchange rates in Excel?
For linked data types or supported imports, choose Data > Refresh All. Availability and refresh behavior depend on the data source, Excel version, account, and internet connection. Check the source and timestamp rather than assuming every refresh returns a real-time rate.
Why does my Excel conversion not match the amount charged?
The payment provider may use its own exchange rate, a different processing date, or additional fees. A worksheet calculation matches only the rate and fee inputs you provide; compare it with the provider’s transaction details.
Related
- Excel Mail Merge: Create Letters, Labels, and Emails
- Excel Daylight Saving Time: How Dates and Hours Work
- Monthly Excel Budget Format: Build a Simple Template
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Consolidate Blank Cells Into One Cell With TEXTJOINYes—if by “blank wells” you mean blank cells between values, Excel can combine the nonblank entries into one…
- Excel Filters: How to Sort and Show the Rows You NeedTo filter data in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data…
- Round Excel to Significant Figures: Formulas and MethodsTo round a number in Excel to a chosen number of significant figures, put the value in A2…
- Excel Formula Solver: Goal Seek, Solver, and How to Use ThemExcel does not have a worksheet function called “formula solver.” To make Excel find an input that produces…
- Excel Time Subtraction: Formulas and Overnight TimesTo subtract one time from another in Excel, subtract the start time from the end time: with a…
- Lowercase Names in Excel: Formula, Fill Down, and ReplaceTo lowercase names in Excel, use the LOWER function in a helper column, then fill the formula down.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.