You should now see column B populated with prices in INR.Double click on the fill handle of cell B2 to copy the formula to the rest of the cells of column C.Select the first cell of the column where you want the results to appear (B2).To convert the money in the table above from USD to INR, follow these steps: Let us assume we have the following list of prices in dollars and we want to convert them to INR. The above steps only get you the conversion rates between two currencies, but they don’t actually convert money from one currency to another. How to Convert USD to INR Using GOOGLEFINANCE You should now see conversion rates for USD to all three currencies shown in the sheet. Double click on the fill handle of cell C2 to copy the formula to the rest of the cells of column C.Alternately, you could even include references to cells in the function, by combining them with the ampersand operator, as follows: =GOOGLEFINANCE(“CURRENCY:”&A2&B2).You should see the current exchange rate for conversion of USD to INR in cell C2. Type the formula: =GOOGLEFINANCE(“CURRENCY:USDINR”).Select the first cell of the column where you want the results to appear (C2).Here are the steps you need to follow in order to get the exchange rate of dollars to the three currencies in column B: Here we have three currencies in column B and we want to convert the currency in column A to those in column B: How to use GOOGLEFINANCE to Fetch Currency Exchange Rates Here are some other currency codes: Currency Notice that there is no space between the two currency codes. t arget_currency_symbol is a three-letter code for the currency you want to convert to.įor example, if you want the conversion rate from dollars to rupees, you will enter the function: =GOOGLEFINANCE("CURRENCY:USDINR").source_currency_symbol is a three-letter code for the currency you want to convert from.The basic syntax of the GOOGLEFINANCE FUNCTION is as follows: =GOOGLEFINANCE("CURRENCY:") So whatever conversion rates you were planning to Google, are directly available within your Google Sheets! All you need is the correct formula. The GOOGLEFINANCE function in Google Sheets is a really convenient tool that fetches currency conversion rates in real-time (well almost in real-time).Īs the name suggests, the function makes use of financial data provided by Google. Using GOOGLEFINANCE to Convert Currency in Google Sheets How to Use GOOGLE FINANCE to Fetch Historical Exchange Rates.Using GOOGLEFINANCE to Convert Currency in Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |