

This means we want real-time price quotes fetched from Google Finance. This is a string value and its default value is “ price”.
Currency converter pound to real how to#
Related Reading: How to Remove a Dollar Sign in Google Sheets How to Use GOOGLE FINANCE to Fetch Historical Exchange Rates For example, you can use it to display historical exchange rates too. However, there are other optional parameters that the GOOGLEFINANCE function lets you enter in order to get specifically what you need. Notice we simply multiplied the result of the GOOGLEFINANCE function with the cell value in column A, in order to convert the price to INR.Įntering your parameters along with just the general GOOGLEFINANCE function is enough to give you an accurate conversion rate. 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 in Google Sheets, but they don’t actually convert money from one currency to another. How to Convert USD to INR Using GOOGLEFINANCE Note: The Google finance currency codes are the same as the shorthand codes on the international currency exchanges. 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. Select the first cell of the column where you want the results to appear (C2).Here’s how to convert currency in Google Sheets 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 currencies in column A to those in column B: How to Use GOOGLEFINANCE for Real-Time Currency Conversion Here are some other GOOGLEFINANCE currency codes: Currency Notice that there is no space between the two currency codes.
Currency converter pound to real code#
