I have a field which accepts a retail price. I am trying to write a formula that will reference a customer field to determine what type of currency format to use.
Example: Suppose retail is 14.95
If Customer field shows “Macy’s” it will format as $14.95. If Customer filed shows “Galeries Lafayette” it would show €14.95, if customer is “Harrods of London” it would show £14.95, etc.
Is there any way to do this?