dimanche 1 janvier 2017

Google Spreadsheets formula to extract and convert currency from EUR/USD to Korean Won

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