In this tutorial, you will learn how to convert currency in Google Sheets.
How To Convert Currency In Google Sheets
Quick Navigation
If you work with international clients or customers, you may have to convert some values to different currencies in Google Sheets.
For example, you may be tracking sales data from different countries and you need to see the total amount in USD.
Since the conversion rates for different currencies change every day, it will be a hassle to search for the new rate manually every time.
Fortunately, Google Sheets has a built-in function that can handle currency conversion for you. In this guide, we will show you how to use the GOOGLEFINANCE function to convert currency in Google Sheets.
How to Calculate Currency Conversion in Google Sheets
Here’s how to calculate currency conversion in Google Sheets.
Step 1
First, select the cell where you want to output the converted currency.
In this example, we want to return the GBP equivalent of a given USD amount in column B.
Step 2
We’ll create a formula that multiplies the original value with the conversion rate. We’ll use the GOOGLEFINANCE function to return the appropriate conversion rate.
If you want to convert from USD to GBP, we’ll simply add the argument “USDGBP”. To convert from GBP to USD, we’ll switch the currency codes to get “GBPUSD”
Step 3
Hit the Enter key to return the converted amount.
Step 4
If you plan on changing the source and target currency, we can modify the formula to allow the user to change either values. First, select the cell that will output the target currency amount.
Step 5
Next, we’ll use the formula = E3 * GOOGLEFINANCE(“Currency:”&E2”E4)
Since both the source and target currencies are cell references, the user can set either of these values at any time.
Step 6
We can also use number formatting to add the appropriate currency symbol. Select the target currency amount and click on the drop-list seen below.
Select the Custom currency option
Step 7
Scroll down until you see your desired currency. Click on Apply to proceed.
Step 8
Your cell should now have the correct currency symbol formatting.
Summary
This guide should be everything you need to convert currency in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.