displaying data in expression builder

[BakaBard]

I'm working with a table that has abbreviations for longer items (for
example, "P", "E", "S", and "C" = the P means Professional).

I know I've done this before, but can't figure it out. Was hoping to create
an unbound text box in my form that actually shows the longer display (i.e.,
if the field "CATEGORY" = "P", it shows "Professional" instead).

I currently tried:

=If([Category]="P","Professional (Non-Equity)",if([Category]="E","Union
(Equity)",if([Category]="S","Academic",if([Category]="C","Non-Professional"))))

and it's giving me a #Name? error. I've tried taking out the quotes, moving
them to single quotes, quoting the field name instead of the brackets,
nothing helps. Can someone jog my memory?

 

[Maurice]

replace the if for iif that should do the trick:

=Iif([Category]="P","Professional (Non-Equity)",iif([Category]="E","Union

(Equity)",iif([Category]="S","Academic",iif([Category]="C","Non-Professional"))))

 

[Ron]

Just a noob here, but isn't the function "IIF" (not "If")?

-Ron