New answers tagged

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