Comments on: Google Sheets Currency Conversion: The Easy Method https://spreadsheetpoint.com/convert-currency-google-sheets/ Google Sheets Tips & Tutorials Tue, 02 Apr 2024 15:18:35 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: jmarkus https://spreadsheetpoint.com/convert-currency-google-sheets/#comment-12491 Mon, 16 Oct 2023 16:11:39 +0000 https://spreadsheetpoint.com/?p=2764#comment-12491 In reply to Swadhin Agrawal.

Hi Swadhin, The formula updates the data dynamically. I hope this helps!

]]> By: Francesco https://spreadsheetpoint.com/convert-currency-google-sheets/#comment-12361 Mon, 02 Oct 2023 19:31:34 +0000 https://spreadsheetpoint.com/?p=2764#comment-12361 If I have a spreadsheet with mixed currencies (perhaps taken from ETF valuations), the unit conversion is not done for example:
EUR EUR =GOOGLEFINANCE(“CURRENCY:”&A1&B1) gives me #N/D instead of 1
USB EUR =GOOGLEFINANCE(“CURRENCY:”&A1&B1) gives me’ 0.95

]]> By: Swadhin Agrawal https://spreadsheetpoint.com/convert-currency-google-sheets/#comment-10237 Wed, 14 Sep 2022 11:56:57 +0000 https://spreadsheetpoint.com/?p=2764#comment-10237 Hi Sumit,
Thank you so much for this tutorial. One doubt that I have is, when we convert the currency, say USD to INR using the formula: =GOOGLEFINANCE(“CURRENCY:”&A2&B2), would it change the converted data every day when the spreadsheet loads (to replace the market value of that day) or it will show the converted value of the day the data was added even if we open after a year.

Thanks so much,
-Swadhin

]]>