Currency Formula in Google Sheets: Convert and Format

For a live exchange rate in Google Sheets, enter =GOOGLEFINANCE("CURRENCY:USDEUR") in an empty cell to request the US dollar-to-euro rate. To convert an amount, multiply it by that rate; if you only want a currency symbol and number format, use the formatting menu instead of a formula.

What a currency formula can mean

People usually mean one of two different things when they ask for a currency formula. They may want to convert an amount from one currency into another using an exchange rate, or they may want a cell to display a value as dollars, euros, yen, or another currency. Conversion changes the numeric value. Formatting changes how an existing value appears, but does not convert it.

For example, formatting the number 100 as euros displays it as a euro amount, but it does not determine how many euros 100 US dollars would buy. To convert currencies, you need an exchange rate and a multiplication formula. To label a value in a particular currency, choose a number format.

Google Sheets has the GOOGLEFINANCE function for retrieving some market data, including currency exchange rates. It is convenient for a live or recently updated rate, but it is not the same as a fixed rate agreed for an invoice, a bank transaction, or an accounting record. Choose the method that fits the purpose of the sheet.

Get a live exchange rate with GOOGLEFINANCE

With no input cells required, enter =GOOGLEFINANCE("CURRENCY:USDEUR") in a blank cell to request the exchange rate from US dollars to euros. The result is a rate, not a converted amount: if the returned rate is 0.92, one US dollar is equivalent to about 0.92 euros at that rate. The quote can change, and Google Sheets does not guarantee that the value is an executable rate for a particular transaction.

The currency pair is written as a source code followed by a destination code. In USDEUR, USD is the source currency and EUR is the destination currency. To request euros to US dollars instead, reverse the pair to EURUSD. This distinction matters: multiplying a USD amount by a USD-to-EUR rate converts it to euros, while using the reverse rate would produce a different result.

Currency codes are standardized three-letter codes, such as USD for US dollars, CAD for Canadian dollars, GBP for British pounds, and JPY for Japanese yen. The function may not return data for every possible currency pair. If a pair is unsupported or data is temporarily unavailable, check the spelling and try again later.

Convert an amount using the returned rate

A clear worksheet keeps the amount, exchange rate, and converted amount in separate cells. With the amount in A2 and the USD-to-EUR rate in B2, enter =A2*B2 in C2 to calculate the euro amount. For an illustrative example, if A2 is 100 and B2 is 0.92, C2 returns 92. This arithmetic is 100 × 0.92 = 92 euros; the example rate is for demonstrating the formula, not a claim about the current market.

You can put the live rate directly into the conversion calculation. With a US dollar amount in A2 and a desired euro result in B2, enter =A2*GOOGLEFINANCE("CURRENCY:USDEUR") in B2. If A2 contains 100 and the function currently returns 0.92, the result is 92 euros. Because the quote can update or be temporarily unavailable, the precise result is not fixed. Keeping the rate in its own cell is often easier to inspect and reuse, especially when converting many rows.

For a list of amounts, place the rate in one cell and refer to that cell when copying the calculation down. With amounts in A2:A20, the rate in B1, and the converted results beginning in C2, enter =A2*$B$1 in C2 and fill it down. If A2 is 100 and B1 is 0.92, C2 returns 92; if A3 is 50, C3 returns 46. The dollar signs make B1 an absolute reference, so the rate reference stays fixed as the formula is copied.

Use a fixed rate when you need a stable result

A live quote is useful for an estimate, a personal tracker, or a quick comparison. It can be a poor choice when a record must reproduce the amount calculated on a past date. If the exchange rate updates, a formula that depends on GOOGLEFINANCE may show a different result later. For a budget, invoice, or reconciliation, decide which rate source and date are appropriate, then record the chosen rate as a value or document its source alongside the calculation.

One practical approach is to put a rate copied from an approved source into a dedicated rate cell and use that cell in the conversion formula. This makes the calculation easy to review and prevents a changing quote from silently altering an older estimate. It also makes the assumptions visible to anyone opening the sheet. Do not treat a spreadsheet quote as a bank’s final rate: providers may use different rates, spreads, fees, and transaction times.

For historical research, GOOGLEFINANCE supports historical data requests, but returned data can have limitations and may not match a bank statement or an official accounting source. Check the function’s current Google Sheets documentation and the requirements of your task before relying on historical results. For financial, tax, investment, or legal decisions, verify the relevant terms with the provider or a qualified professional; this example is spreadsheet guidance, not professional advice.

Format a value as currency without converting it

To display a number with a currency symbol, select the cell or range and choose Format > Number > Currency. For more control over the currency or the number of decimal places, use Format > Number > Custom currency and select the option you need. Menu labels and available formats can vary with the spreadsheet’s locale.

Formatting is useful for readability, but the underlying value remains numeric and unchanged. If A2 contains 100 and you apply a euro format, the cell displays a euro-style amount; it does not look up an exchange rate or turn 100 dollars into euros. You can still use the formatted value in arithmetic, and formulas refer to its numeric value rather than the displayed symbol.

For a converted result, format the result cell after calculating it. For example, if C2 contains 92 from the USD-to-EUR calculation, applying a euro currency format makes the result easier to read. Make sure the label, such as Converted to EUR, agrees with the actual calculation. A symbol alone can be ambiguous because some currencies share symbols, and a display format does not record the source currency or rate.

Round results and choose suitable precision

Currency displays commonly show two decimal places, but display rounding and calculation rounding are not identical. A number can retain additional decimal places internally while the cell shows only two. That is often desirable for intermediate calculations; for a final amount that must be rounded to cents, explicitly round the result according to the applicable rules for the task.

With the amount in A2 and the rate in B2, enter =ROUND(A2*B2,2) in C2 to round the converted result to two decimal places. If A2 is 100 and B2 is 0.9234, the unrounded product is 92.34 and the formula returns 92.34. If the product had more than two decimal places, ROUND would round it to the nearest hundredth. The right precision depends on the currencies and the use case; some currencies are commonly handled without two minor-unit decimals, so do not assume two is always appropriate.

Rounding each row before adding can produce a slightly different total than adding unrounded conversions and rounding once at the end. When totals matter, establish whether the relevant process requires row-level rounding or total-level rounding, and apply that rule consistently. Changing the number format alone only changes what is shown; it does not force intermediate values to be rounded.

Organize the sheet so the calculation is easy to check

A small amount of structure makes a currency spreadsheet less error-prone. Use headings that identify both the amount and its currency, rather than relying on a symbol in the cell. A useful layout might have columns named Amount (USD), Rate (USD to EUR), and Converted amount (EUR). If a single rate applies to many rows, show its date or source near the rate cell.

Keep the original amount unchanged in its own column.
Store the exchange rate separately and label its direction, such as USD to EUR.
Put the converted result in a separate column and format it as the destination currency.
Record whether the rate is live, manually entered, or tied to a particular date.
Check a sample row by multiplying the amount by the rate independently.

This layout also helps when a spreadsheet contains more than one source currency. A single rate cannot correctly convert amounts in USD, GBP, and JPY unless each row uses the matching rate. Add a currency-code column or separate clearly labeled sections, and make sure each calculation uses a rate for the right source and destination pair.

Common errors and ways to troubleshoot them

If GOOGLEFINANCE shows an error or does not return a number, first confirm that the formula uses a valid-looking pair in the form CURRENCY:USDEUR, with the source code before the destination code. Check for an extra space or a mistyped currency code. A correct-looking request can still fail temporarily because data is unavailable, or because that particular pair is not supported. Retrying later can help distinguish a temporary issue from a typo.

If the result is a rate but the converted amount seems wrong, check the direction of the pair and the multiplication. A USD-to-EUR rate of 0.92 means 100 USD converts to 92 EUR, before any fees or other adjustments. Dividing by 0.92 instead would calculate a different figure. Also confirm that the source amount is actually in USD; a number in another currency cannot use the USD-to-EUR rate correctly.

If a cell displays the formula as text instead of calculating it, check that the cell is not formatted as plain text and that the formula begins with an equals sign. Re-entering the formula after changing the cell format may be necessary. If the output appears as a long decimal, use currency formatting or a suitable rounding formula rather than manually changing the underlying result.

Frequently Asked Questions

What is the formula to convert dollars to euros in Google Sheets?
For a live rate, multiply the dollar amount by a USD-to-EUR quote from GOOGLEFINANCE. If the amount is in A2 and the rate is in B2, use =A2*B2. The rate’s direction must match the conversion.

Does the Google Sheets currency formula update automatically?
GOOGLEFINANCE data may refresh, but it is not a guaranteed real-time transaction quote, and availability or update timing can vary. If a result must remain fixed, record a chosen rate as a value and note its source and date.

How do I add a dollar or euro symbol in Google Sheets?
Select the cells and choose Format > Number > Currency, or use Format > Number > Custom currency to select a particular currency format. This changes the display, not the value or its currency conversion.

Why is GOOGLEFINANCE returning an error for my currency pair?
Check that the pair uses valid three-letter codes in the correct order, such as USDEUR for USD to EUR. The pair may be unsupported or data may be temporarily unavailable, so verify the codes and retry later.

Can I use a currency formula for an old exchange rate?
Historical GOOGLEFINANCE requests are available, but their data may not be suitable as an official transaction or accounting record. Verify the date, source, and requirements for your use, and preserve a fixed documented rate when reproducibility matters.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.