# function?

This is a discussion on function? within the Excel Questions forums, part of the Question Forums category; Hi, I frequently need to convert currency form Euro to US Dollar, and from USD to Euro. What would be ...

1. ## function?

Hi,

I frequently need to convert currency form Euro to US Dollar, and from USD to Euro. What would be the best way to create 2 formulas or functions, either using VBA or not, that I could use from any open workbook, so always accessible, to perform those currency conversions? Something like:

1000 * (USD_TO_EURO), where the input (1000) is in USD and the result in Euro, and also the other way around. Of course the "input" would be a value taken from any cell in the workbook.

Thank you in advance for any help.
Best Regards,
MrDoc

2. ## Re: function?

How would you determine the exchange rate, which changes all the time?

3. Hi,

Have you seen the EUROCONVERT XL function?

HTH

Alan

4. ## Re: function?

Hi Andrew,

The exchange rate would be updated in a cell in the worksheet, so it wouldnīt really matter to the function/formula. I also often need to convert from euro to former portuguese currency (escudo) and back, and in this case there is a fixed value: 1 Euro = 200,482 escudos. It never changes.
MrDoc

5. Originally Posted by al_b_cnu
Hi,

Have you seen the EUROCONVERT XL function?

HTH

Alan
That only works for members of the Euro countries, where there are fixed exchange rates.

6. Originally Posted by Andrew Poulsom
Originally Posted by al_b_cnu
Hi,

Have you seen the EUROCONVERT XL function?

HTH

Alan
That only works for members of the Euro countries, where there are fixed exchange rates.
I wondered why there was no exchange rate parameter.

Thanks for that

Alan

7. ## Re: function?

Hi Alan,

The EUROCONVERT function would probably solve some of my problems, but I canīt find it in my Excel (2002 or XP).
MrDoc

8. ## Re: function?

Originally Posted by MrDoc
Hi Alan,

The EUROCONVERT function would probably solve some of my problems, but I canīt find it in my Excel (2002 or XP).
MrDoc
Perhaps it has now been withdrawn (I've got Excwl 2000)

Alan

9. ## Re: function?

For the US Dollar, just divide the dollars by the exchange rate.

10. ## Re: function?

Well what I do is to define different names.

Insert - Name - Define referring i.e EUR-USD to the appropriate cell with the exchange rate and then use that in my calculations. I don't think any functions could make that easier.

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•