I am using two different columns, one for Korean Won and one for foreign currencies (USD and EUR). I am using the normal currency conversion for showing the foreign currencies.
I want the amount of the foreign currencies in row "R" to be shown in the "Q" row.
However, the formula below gives me just a zero.
=if(R2="[\$]\d+",GoogleFinance("CURRENCY:USDKRW"),
IF(R2="[\€]\d+",GoogleFinance("CURRENCY:EURKRW")))*R2
Korean Won in row Q and foreign currencies in row R:
Aucun commentaire:
Enregistrer un commentaire