IIf statement with two or more choices

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Another option is to use the Switch function:

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