Convert multiple currencies into one
Hello guys! I am here because I need some help. I have a column with more currencies, and I want to change all those currencies to RON (Romania Leu). Can someone help me? I attached an Image and my excel sheet, just in case. Thanks in advance!Screenshot_92.pngmodari xbox.xlsm
Welcome to the forum.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hello! I highlighted the cells in the image. Anyways, can you help me?
But you didn't show what the result should be: what VALUE are you expecting in C3 (the number)?
Also, where in your workbook will we find a list of exchange rates to be used?
There is no way for Excel to tell which currency is being used in column B, so this is not possible with a formula. Shall I move the thread to the VBA section for you?
Yes please!
Done. YOu will still need exchange rates somewhere in your workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks