Buzz
Converting currency in real-time on Google Sheets can save you a lot of time when dealing with currencies.
Real-time data in Google Sheets is highly effective, and users do not need to constantly update it as the data will automatically adjust every 30 minutes. For those managing currencies and currency conversions, using Google Sheets ensures accuracy at all times.
1. Converting Currency in Google Sheets with Default Units
| =GOOGLEFINANCE("Currency:hai mã tiền tệ cần đổi") |
| Tỷ giá tiền VND sang USD |
=GOOGLEFINANCE("Currency:VNDUSD") |
|
Tỷ giá tiền USD sang VND |
=GOOGLEFINANCE("Currency:USDVND") |
|
Tỷ giá tiền USD sang KRW |
=GOOGLEFINANCE("Currency:USDKRW") |
| = GOOGLEFINANCE("Currency:Tọa độ ô một: Tọa độ ô hai") |
- Coordinate one represents the base currency needed for conversion.
Coordinate two denotes the target currency for conversion.
Step 3: Simply drag the bottom-right corner of the cell down to apply currency conversion function across all rows.
3. How to convert currencies using any unit on Google Sheets
To convert currencies and calculate based on any chosen unit, simply add a currency unit column in your Sheets table.
Step 1: Create a rate column and utilize GOOGLEFINANCE function to convert rates between the currencies you want to exchange.
Step 2: Next column, input the quantity of units you wish to convert and in the last column, enter the multiplication command to convert currencies.
Example: In this case, Column A will utilize GOOGLEFINANCE function to find the exchange rate, Column B will be the amount in VND currency to convert to USD. Finally, Column C simply needs to input multiplication between Column A and Column B, and the result will appear.
Step 3: In this scenario, 100,000,000 VND will be approximately equal to 4,334 dollars. For other currencies, simply follow the same procedure to convert values.
In this article, Software Tips has guided you on how to directly convert currencies on Google Sheets in real-time. Wishing you all a wonderful day!
