displaying currency symbols based other field contents
I imagine this is quite a basic problem (hope so)...
I'd like to be able to select a currency from a drop down list. Examples are "US Dollars" "Euro" "British Pounds Sterling" etc., but I would like to display them on another layout as just the appropriate symbol: $, €, £, etc.
I'm able to do this with just one symbol:
If ( currency = "US Dollars" ; "$" ; "" )
but don't know the syntax for doing this for more than one currency.
If there's a better way, please let me know.
Thanks for any help.