function?

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: function?

  1. #1
    Board Regular
    Join Date
    Jul 2002
    Location
    Portugal
    Posts
    343
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: function?

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

  3. #3
    Board Regular
    Join Date
    Jul 2003
    Location
    Manchester (UK)
    Posts
    4,482
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Have you seen the EUROCONVERT XL function?

    HTH

    Alan
    HTH

    Alan

    --------------------------------------------------------
    Vlookup not sufficient? Follow the link for latest version of FuzzyVLookup or RuleLookup .
    Alternatively to compare two worksheets try Compare Two Sheets
    --------------------------------------------------------
    There are 10 kinds of people - those who understand binary and those who don't

  4. #4
    Board Regular
    Join Date
    Jul 2002
    Location
    Portugal
    Posts
    343
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

  5. #5
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote 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. #6
    Board Regular
    Join Date
    Jul 2003
    Location
    Manchester (UK)
    Posts
    4,482
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by Andrew Poulsom
    Quote 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. #7
    Board Regular
    Join Date
    Jul 2002
    Location
    Portugal
    Posts
    343
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

  8. #8
    Board Regular
    Join Date
    Jul 2003
    Location
    Manchester (UK)
    Posts
    4,482
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: function?

    Quote 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).
    Thank you for replying,
    MrDoc
    Perhaps it has now been withdrawn (I've got Excwl 2000)

    Alan

  9. #9
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: function?

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

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

  10. #10
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,637
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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.
    "Fair Winds and Following Seas"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com