New answers tagged google-finance
0
In currency field, you need to use the currency code euro=EUR, dollar=USD...
Then I use my main currency with an IF condition. For this table:
=IF(E2="EUR";GOOGLEFINANCE(B2);GOOGLEFINANCE(B2))*GOOGLEFINANCE("Currency:"&E2&M$2))
M$2 is the cell where I put my main currency, change if necessary.
Top 50 recent answers are included