IIf Function- either or 3

[Fredgarner]

I am trying to use the 'IIf' function to do the following: display $ if a share class is a $ share class; £ if it is a £ share class; and € if it is a € share class. at hte moment I can make it display a $ sign if it is a $ share class, by using the formula:

=IIf([Class]="Class A (USD)","$")

However, I do not know how to go on and make this display the other currencies if their conditions are met (ie, either £ or € is present in the 'Class' field), because the IIf function only seems to allow for 2 possibilities.

 

[Remou]

Hi
You can nest ifs, something like:
[tt]=IIf([Class]="Class A (USD)","$",IIf([Class]="Class B (EUR)","€","£"))[/tt]

 

[HenryAnthony]

Check out the Switch function. Much easier than nested iffs.