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:

Step 1: Set Up Your Google Sheet:

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:

  1. Click on “Add-ons” in the menu bar.
  2. Select “Get add-ons” from the dropdown menu.
  3. In the Add-ons store, search for “Google Workspace Marketplace” or “GOOGLEFINANCE.”
  4. Click on “Install” to add the add-on to your Google Sheets.

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.
  2. Click on the “Format” menu in the top menu bar.
  3. Go to “Number” > “More Formats” > “Currency.”
  4. Choose the desired currency format from the list. For Euros (EUR), select “Euro (€).”

Step 5: Drag to Apply the Formula (Optional):

If you want to convert multiple values at once, you can drag the formula down to apply it to other cells. The formula will adjust automatically for each row, converting the respective values in column A to Euros in column B.

That’s it! Now you have a currency conversion formula set up in Google Sheets, and it will automatically update the converted values whenever the exchange rate changes or when you enter new values in column A.

Leave a Reply