function?

[MrDoc]

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

[Andrew Poulsom]

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

[al_b_cnu]

Hi,

Have you seen the EUROCONVERT XL function?

HTH

Alan

[MrDoc]

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.
Thank you for your reply,
MrDoc

[Andrew Poulsom]

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.

[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

[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).
Thank you for replying,
MrDoc

[al_b_cnu]

Hi Alan,

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

Perhaps it has now been withdrawn (I've got Excwl 2000)

Alan

[Andrew Poulsom]

It's in the Euro Currency Tools Add-In (Tools|Add-ins).

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

[fairwinds]

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.