IIf statement with two or more choices

K

kw_uh97

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
 
K

kw_uh97

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
 
D

Douglas J. Steele

Another option is to use the Switch function:

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