Results 1 to 6 of 6

XL Currency Converter

This is a discussion on XL Currency Converter within the Excel Questions forums, part of the Question Forums category; I can use XL but I'm not very good designing sheets, what I need to do is make a "currency ...

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    197

    Default

    I can use XL but I'm not very good designing sheets, what I need to do is make a "currency converter" like those on the WWW. Basically I need a cell people can enter the amount, then a "pull down" menu so they can choose currency (GBP, USD etc), then a result cell also with a pull down menu to choose output currency.

    Can any one send me an example or give me some advise?

  2. #2
    Board Regular
    Join Date
    Sep 2002
    Location
    Simsbury CT USA
    Posts
    1,542

    Default

    Hello Mattrixdesign:

    Might I ask what is the source of the currency data? This currency data is so volitile it changes every second....Is your source of data on a worksheet or from some www page?

    care to show your data and expected outcome?....

    pll

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    197

    Default

    the rate is fixed for a year, so 2002 is...
    to USD...

    Euro Zone 1.12444
    British Pound 0.72376
    Danish Krone 8.43333
    Norwegian Krone 9.11733
    Russian Rouble 32.23333
    Swedish Krona 9.81667
    Swiss Franc 1.75100
    Turkish Lira 1736667

    does this help?

  4. #4
    Board Regular
    Join Date
    Jul 2002
    Location
    Derbyshire, UK
    Posts
    1,369

    Default

    You can use a combination of Data Validation and Lookup to produce your results.
    ******** ******************** ************************************************************************>
    Microsoft Excel - Book2___Running: xl2002 XP : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    G
    H
    I
    1
    Euro*Zone*.1.2444*******
    2
    British*Pound*.0.72376***Amount*to*Convert100**
    3
    Danish*Krone*.8.43333*******
    4
    Norwegian*Krone*.9.11733***Result72.376**
    5
    Russian*Rouble*.32.23333****CurrencyExchange*Rate*
    6
    Swedish*Krona*.9.81667****British*Pound*.0.72376*
    7
    Swiss*Franc*.1.751*******
    8
    Turkish*Lira**1736667*******
    9
    *********
    Sheet1*

    [HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


    To get the currency use Data Validation>List>and select your list of currencies.
    To get the exchange rate use the lookup formula in cell H6
    The conversion formula is in cell G4
    You can pretty it up with Formatting, this is just quickly thrown together to give you an idea.
    i will email the example sheet if you want

    NB- CURRENCIES SHOULD BE SORTED ALPHABETICALLY FOR LOOKUP TO WORK

    [ This Message was edited by: royUK on 2002-10-09 07:24 ]

    [ This Message was edited by: royUK on 2002-10-09 09:43 ]

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    197

    Default

    pls email a sample to

    matt@mattrixdesign.co.uk (EDIT)

    MANY MANY thanks for your help!

    [ This Message was edited by: Mattrixdesign on 2002-10-09 09:33 ]

    [ This Message was edited by: Mattrixdesign on 2002-10-09 09:34 ]

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    197

    Default

    Roy its doing something weird I cant understand, can I email u what I have?

    I can't email u through the forum and the link does not work as I have Lotus Notes setup as the default email prog.

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