Formula for displaying certain text based on field 1

[Opsdiva]

I'm trying to format a report to display one of three different things (either "Current Installation", "Active in Manufacturing" or nothing at all) based on a certain field. There are actually 13 different options in that field. The best formula (in all of my inexperience) I can come up with is below. But I get an error message "a number, currency amount, boolean, date, time, date-time, or string is expected here". Can anyone help? I'm using Crystal Reports 11.0.0.1282

If {Leads.lopclosedreasonid} = "INOP5" Then
formula = "Current Installation"
ElseIf {Leads.lopclosedreasonid} = "PORCV" Then
formula = "Active in Manufacturing"
ElseIf {Leads.lopclosedreasonid} = "INOP6" Then
formula = "Current Installation"
ElseIf {Leads.lopclosedreasonid} = "UND" Then
formula = " "
ElseIf {Leads.lopclosedreasonid} = "SHIP" Then
formula = "Current Installation"
ElseIf {Leads.lopclosedreasonid} = "REMOV" Then
formula = " "
ElseIf {Leads.lopclosedreasonid} = "INOP4" Then
formula = "Current Installation"
ElseIf {Leads.lopclosedreasonid} = "DEAD3" Then
formula = " "
ElseIf {Leads.lopclosedreasonid} = "DEAD2" Then
formula = " "
ElseIf {Leads.lopclosedreasonid} = "DEAD1" Then
formula = " "
ElseIf {Leads.lopclosedreasonid} = "DEADL" Then
formula = " "
ElseIf {Leads.lopclosedreasonid} = "INOP2" Then
formula = "Current Installation"
ElseIf {Leads.lopclosedreasonid} = "INOP1" Then
formula = "Current Installation"
End If

Thanks so much!

 

[IanWaterman]

Try

If {Leads.lopclosedreasonid} in ["INOP5", "INOP6", "INOP4", "SHIP", "INOP2", "INOP1"] Then
"Current Installation"
Else If {Leads.lopclosedreasonid} = "PORCV" Then
"Active in Manufacturing"
Else If {Leads.lopclosedreasonid} in ["UND", "REMOV", "DEAD3", "DEAD2", "DEAD1", "DEADL"] Then
" "

Ian

 

[Opsdiva]

Thanks so much, that worked perfectly!!