A | B
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!