Multi if statement in 1 formula

[Bronnad]

Here is the formula I was trying to run...

if {data.DESCRIPTION} = ("Regular", "Bereavement", "Paid Bank", "Jury Duty", "Military - Hours", "Temp Disability/Sick", "Temp Dis-State tax exempt", "Temp Dis - Hours", "Temp Dis-State taxable", "FMLA- FLA", "Military Wages to offset reg", "Bank - Non-Eligible 401k")
then "Base Pay"
else {data.DESCRIPTION},
If {data.DESCRIPTION} = ("Severance-Welfare Plan", "Severance - Non Welfare")
then "Severance"
else {data.DESCRIPTION},

I failed, and I'm not sure why.

 

[briangriffin]

Try this:

if {data.DESCRIPTION} in ["Regular", "Bereavement", "Paid Bank", "Jury Duty", "Military - Hours", "Temp Disability/Sick", "Temp Dis-State tax exempt",
"Temp Dis - Hours", "Temp Dis-State taxable", "FMLA- FLA", "Military Wages to offset reg", "Bank - Non-Eligible 401k"]
then
"Base Pay"

else

If {data.DESCRIPTION}, in ["Severance-Welfare Plan", "Severance - Non Welfare"]
then
"Severance"

else {data.DESCRIPTION}

 

[Bronnad]

Thank you...I see my error.