How to format a formulaic field (called "Price") to display a Euro symbol or the letters EUR to the left of a product price? This field is used to calculate the Total Price of a line item by multiplying the "Quantity" field X "Price" field, and, of course, I have no problem doing this in a non-formulaic field through the properties for that field. I've read past posts about this in the Community Forum related to this, but am not grasping how to achieve this.

Below are two formulas I tried and the error message they return.

Below formula formatted as Formula Numeric-Currency, Formula-Numeric, and Formula-URL fields basically returns an error of "Expecting number"

If ([Price List to Use]="US List Price", [US List Price],

[Price List to Use]="Asia Dist Price", [Asia Dist Price],

[Price List to Use]="Asia List Price", [Asia List Price],

[Price List to Use]="EUR Dist Price", €&[EU Dist Price],

[Price List to Use]="EUR List Price", €&[EU List Price])

Below formula formatted as a Formula-Rich Text Field returns numbers that are not lined up at the decimal point and there is no comma between every three numbers (the [Euro Symbol] field was added to hold the symbol)

If ([Price List to Use]="US List Price", "$"&ToText([US List Price]),

If ([Price List to Use]="Asia Dist Price", "$"&ToText([Asia Dist Price]),

If ([Price List to Use]="Asia List Price", "$"&ToText([Asia List Price]),

If ([Price List to Use]="EUR Dist Price", ToText([Euro Symbol] & [EU Dist Price]),

If ([Price List to Use]="EUR List Price", ToText([Euro Symbol] & [EU List Price]))))))

Can anyone help with this? Or, is there another way to do this?

Below are two formulas I tried and the error message they return.

Below formula formatted as Formula Numeric-Currency, Formula-Numeric, and Formula-URL fields basically returns an error of "Expecting number"

If ([Price List to Use]="US List Price", [US List Price],

[Price List to Use]="Asia Dist Price", [Asia Dist Price],

[Price List to Use]="Asia List Price", [Asia List Price],

[Price List to Use]="EUR Dist Price", €&[EU Dist Price],

[Price List to Use]="EUR List Price", €&[EU List Price])

Below formula formatted as a Formula-Rich Text Field returns numbers that are not lined up at the decimal point and there is no comma between every three numbers (the [Euro Symbol] field was added to hold the symbol)

If ([Price List to Use]="US List Price", "$"&ToText([US List Price]),

If ([Price List to Use]="Asia Dist Price", "$"&ToText([Asia Dist Price]),

If ([Price List to Use]="Asia List Price", "$"&ToText([Asia List Price]),

If ([Price List to Use]="EUR Dist Price", ToText([Euro Symbol] & [EU Dist Price]),

If ([Price List to Use]="EUR List Price", ToText([Euro Symbol] & [EU List Price]))))))

Can anyone help with this? Or, is there another way to do this?