IIf statement with two or more choices

[Guest]

Is there a similar function to the IIf function for more then two options or do I have to do some complicated programming to get my results

Here is my table and value
[STATUS





This would work great for two choices,
=IIf([STATUS]="C","CLOSED","READY"

but, as you can see I have four choices

Thanks In Advance

 

[Guest]

Thanks To Al

Read through some of the posts and found my answer

Nested IIf statements if you want more than two option

Thanks Agai
Ken

 

[Douglas J. Steele]

Another option is to use the Switch function:

=Switch([Status] = "C", "Closed", _
[Status] = "R", "Ready", _
[Status] = "M", "Maybe", _
[Status] = "H", "Help")