2 Replies Latest reply on Feb 19, 2016 2:01 PM by mjbenun

    Calculation to format a currency field



      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?