If the PT code is any of these listed then ineligible PT, tried several ways but not working, thank you in advance.
If ([PT Code] IN ("ABA",
"ACM",
"ADC",
"AFH",
"ALC",
"AT",
"BAA",
"BB",
"BC",
"BT",
"CS",
"DHB",
"DHY",
"DLA",
"DNT",
"ECS",
"GNC",
"HMD",
"HOM",
"IDN",
"LC",
"NSA",
"PC",
"PE",
"PER",
"PSS",
"SBH",
"SDC",
"SES",
"VIP")
Then "Ineligible Provider Type"
End""
EndIF
Solved! Go to Solution.
You have an extra parenthesis in front of [PT Code] and it should be Else "" and not End"", I updated the formula and pasted below. Other than that, the formula should work (assuming they are exact matches). You may want to consider using a Find/Replace as well since its a longer list to keep your formula from getting too large.
If [PT Code] IN ("ABA",
"ACM",
"ADC",
"AFH",
"ALC",
"AT",
"BAA",
"BB",
"BC",
"BT",
"CS",
"DHB",
"DHY",
"DLA",
"DNT",
"ECS",
"GNC",
"HMD",
"HOM",
"IDN",
"LC",
"NSA",
"PC",
"PE",
"PER",
"PSS",
"SBH",
"SDC",
"SES",
"VIP")
Then "Ineligible Provider Type"
Else ""
EndIF
Amazing, thank you very much, it worked.😊