How to skip a cell to avoid overriding data in the cell.

[snadeau456]

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

[jdminton]

ELSE [Comment]

This would keep the value prior to the formula.

[jdminton]

@snadeau456 did this answer your question?

[snadeau456]

Thank you, thought had to enter an Else for the IF statement. 

[jdminton · Accepted solution]

@snadeau456 you do, but you can just have it be the existing value in the field as below. (This assumes your field is named "Comment")

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"

ELSE [Comment]

ENDIF