How to create a multi-currency converter
fabriceklepper
Posted messages
2
Status
Member
-
fabriceklepper Posted messages 2 Status Member -
fabriceklepper Posted messages 2 Status Member -
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 answer
-
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.
