# How to Convert Currency in Google Sheets – How-To Geek

To convert currency in Google Sheets, you can use the “GOOGLEFINANCE” function along with a simple multiplication formula. Here’s a step-by-step guide to help you do it:

Open Google Sheets and create a new spreadsheet or open an existing one where you want to perform the currency conversion.

Step 2: Enable the “GOOGLEFINANCE” Function:

If you haven’t used the “GOOGLEFINANCE” function before, you may need to enable it in Google Sheets. To do this:

Step 3: Enter the Currency Conversion Formula:

Now, you can use the “GOOGLEFINANCE” function along with a multiplication formula to convert currency. For example, let’s say you want to convert the value in cell A1 from US Dollars (USD) to Euros (EUR). In cell B1, you want to display the converted value.

1. In cell B1, enter the following formula:
```=A1*GOOGLEFINANCE("CURRENCY:USDEUR") ```

This formula will take the value in cell A1, multiply it by the current exchange rate between USD and EUR (fetched using “GOOGLEFINANCE”), and display the converted amount in Euros in cell B1.

2. Press Enter to apply the formula.

Step 4: Format the Cells:

By default, Google Sheets may display a lot of decimal places for the converted value. To format the cells with the appropriate currency format:

1. Select cell B1.