|convert currency in google sheets||0.59||0.1||8137||49|
First, select an empty cell where you want the currency conversion rate to go. Then, type =GOOGLEFINANCE ("CURRENCY:EXAEXB") into it. Replace “EXA” with the currency code you want to convert from and “EXB” with the currency code you’re converting to.How do I convert currencies in Excel?
To convert currencies even easier, just replace the text in the formulas with cell references: Here B3 contains the formula that combines two currency names in A1 and A3: Tip. You will find a full list of all currency codes including few cryptocurrencies below.How do I convert USD to GBP in Google Sheets?
The GOOGLEFINANCE function is used in cells A3 to A5, returning the then-current USD to GBP rate. By multiplying the USD figure in column B against the USD to GBP exchange rate in column A, the converted GBP amount is returned in column C.How do I find the current exchange rate using Google Finance?
The format for a GOOGLEFINANCE formula to find the current exchange rate is =GOOGLEFINANCE ("Currency:USDGBP"), where you can replace USD and GBP with other suitable three-letter currency codes. The example above shows the then-current USD to GBP rate.