Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry

    I have a spreadsheet which I can convert from USD to other currencies with user-entered rate, however I need to take it to the next step and let user select any to any (with them entering the exchange rate).

    I have a lookup table for the currency names, and today's rate (relative to USD). I want them to be able to select the from and to currencies and enter the exchange rate and get the answer for the entered number. It seems I have to reset it back to USD first and then do the other currency. Is there an easier way? I attached the spreadsheet I have used so far.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See the attached version. It uses two lookups.
    Note that I added a row for USD to USD to avoid problems.
    Attached Files Attached Files

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Nice job, thank you. I ended up making two changes:

    1. rearrange the currencies to match the drop down list (two were off)
    2. changing column G to be =1/rate instead of 'rate' otherwise it wasn't calculating the conversion correctly (compared to the currency exchange site I listed as a reference)

    I attached this updated version.
    Attached Files Attached Files

Posting Permissions

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