Hello,
I have a row of data starting in A2 with an amount in a given currency (e.g $100, €100,…) and in B2 the corresponding Currency code (e.g, “GBP”, “USD”, “EUR”,…) and in C2, I’m trying to do the following:
=IF(B2="GBP","£"&ABS(A2),IF(B2="USD","£"&ABS(A2)/$I$3,IF(B2="EUR","£"&ABS(A2)/$I$4,"")))
Now the whole purpose of this is to NEVER CARE what’s the given currency showed (by default or not) in A2, since the formula relies on cell B2 to convert A2 in the desired currency. So, here’s my PROBLEM:
- I needed to add “manually” the GBP symbol “£”& in each argument of the formula and IT WORKS!!,….BUT
- Is there a “smarter way to do this” instead of inserting the symbols all the time…and MOST IMPORTANTLY (as you’ll see in my xls attachment)….
- YOU CAN’T SUM THE OBTAINED CURRENCY CONVERTED VALUES.
Thank you all for your help and let me know if you need more info to solve my problem.
Bookmarks