How to create a multi-currency converter
fabriceklepper
Posted messages
2
Status
Membre
-
fabriceklepper Posted messages 2 Status Membre -
fabriceklepper Posted messages 2 Status Membre -
Hello,
I would like to create a currency converter in Excel, but I know absolutely nothing about Excel, so here it is, I would like to make 3 columns to put a different currency in each column and that I can change the rates and the names of the currencies, and that as soon as I write an amount in one currency, the others are automatically converted and I can see the 3 conversions in the same document
could you please help me
thank you in advance
I would like to create a currency converter in Excel, but I know absolutely nothing about Excel, so here it is, I would like to make 3 columns to put a different currency in each column and that I can change the rates and the names of the currencies, and that as soon as I write an amount in one currency, the others are automatically converted and I can see the 3 conversions in the same document
could you please help me
thank you in advance
1 réponse
Hello,
in column A you enter the values to convert, in B1 the rate for the dollar, in C1 the rate for the pound sterling, in D1 the rate for the dirham, etc.
in B2 this formula =A2*$B$1 in C2 =A2*$C$1, etc. and you drag it down
you can refine the formula =if(A2="","",A2*$B$1) the same for the other columns
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
in column A you enter the values to convert, in B1 the rate for the dollar, in C1 the rate for the pound sterling, in D1 the rate for the dirham, etc.
in B2 this formula =A2*$B$1 in C2 =A2*$C$1, etc. and you drag it down
you can refine the formula =if(A2="","",A2*$B$1) the same for the other columns
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
fabriceklepper
Posted messages
2
Status
Membre
Thank you very much, Mike.