Results needed, if the Behavioral Health results reflect Yes (this would be on the only results or blank in that cell), then add "suppress from printing" in the Comments column.
Then
If the there is a flag in the FLAG_CD cell then add comment of 'remove from 12219' in the comment column, this comment can override any comments already populated in the comments column.
Then
If there is a TIN in the 'PT-TINs No match from10 counties to remove from12219' cell then add 'remove from 12219' in the comment column, this comment can override any comments already populated in the comments column. but do not want an Else as this would override any other data in other fields. What can else can I try?
If !IsEmpty([Behavioral Health?])
Then "suppress from printing"
ElseIF IsNull([FLAG_CD]) THEN 'remove from 12219'
Elseif !IsEmpty([PT-TINs No match from10 counties to remove from12219 ])
then "Remove from 12219"
ENDIF