+ Reply to Thread
Results 1 to 8 of 8

how can i find a currency text in a column and multiply it by my own conversion rate using

  1. #1
    Registered User
    Join Date
    06-17-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    5

    how can i find a currency text in a column and multiply it by my own conversion rate using

    currency.xlsxcurrency.xlsxcolumns
    A | B
    Rows
    1 Other currencies | USD
    2 EUR 111
    3 POUNDS 222

    Self determine exchange rate:D1:EUR 1.6 D2: POUNDS 2.0

    how can i make use of the excel function to find the currency text example "EUR" in column A and do multiplcation between a exchange rate i entered in column D1 with the integer value in A2? same for other currencies, if "POUNDS" is detected instead of "EUR" it will multiply the integer value in A3 with D2 and display at B2. Thanks!

    updated with excel example thanks!
    Last edited by tiongsquare; 06-17-2012 at 04:31 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    You get better help if you post an Excel-example of your workbook, without confidential information.

  3. #3
    Registered User
    Join Date
    06-17-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    thanks!
    post #1 updated with excel link!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    Maybe, like this.

    Do you have questions, just ask.
    Attached Files Attached Files

  5. #5
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    Whilst not disagreeing with oeldere, who is offering a far more sensible layout for your sheet. try this ...

    In B2
    Please Login or Register  to view this content.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  6. #6
    Registered User
    Join Date
    06-17-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    thanks man!
    maybe a few questions
    1) so for column C which is the SGD, i have to enter function for each box that i going to add on?
    2) for the currency text, its not possible to put it together with the price? as in "EUR 111.0" then use a method to detect the text on the left and amt on the right?

    thanks!

  7. #7
    Registered User
    Join Date
    06-17-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    oh thanks man!
    i think for both the implementation, it boils down to whether i need to use 2 or 3 columns for these
    thanks again to both of you!!!

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: how can i find a currency text in a column and multiply it by my own conversion rate u

    Please refer in your answer to whom your replying.

    1) you need tot add every value (euro / pounds / yen) at the table with values.

    Otherwise it won't be found.

    2) Problaby it can be done, but why do you want it that (complex) way.

    You download the data from another source, and get it this way?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1