All morning I have been in Excel trying to create a function that will give me the full Currency name based on its acronym.
For example, Column "X" contains various different currency codes (INR, CAD, USD, HKD, ect.)
I am trying to draft a function where based on the prefix of that cell, the full currency name should populate.
For example, if the cell contains CAD=Canadian Dollar.
But since there are various currency codes, I need to put various conditions.
So I tried, =IF(X1="ARS","Argentine Peso", OR(X1="CAD",X1="USD",X1="INR",X1="COP",X1="GHS")) - This didn't work, shows false for everything not ARS.
Then I tried to nest the if functions..
=IF(X1="ARS", "Argentine Peso", IF(X1="CAD", "Canadian Dollar", IF(X1="ARS", "Argentine Peso"))) - It keeps saying too many arguments. Nothing I try works!
As humbly as I can ask... pls help
Bookmarks