Parse Error: Malformed If Statement - Need Assistance

[Cassie_Shaw]

Hi! i need help with this if formula  - I am trying to say if (x) = none and if any of these columns (transactions 1-6) have "BCS - no further benefits letter" then return "no benefits due" if not, return (x).  I am not sure what I am doing wrong:

[ChrisTX]

After your first AND, remove the characters "IF"

Chris

[MarqueeCrew]

@Cassie_Shaw ,

How about:

IF
[X] = "NONE" AND
!CONTAINS([Tran 1]+[Tran 2]+[Tran 3]+[Tran 4]+[Tran 5]+[Tran 6],"BCS - no further benefits letter") THEN "No Benefits Due"
ELSE [Y]
ENDIF

I think that this is readable.

Cheers,

Mark

[Cassie_Shaw]

@MarqueeCrew & @ChrisTX - Thank you both!

[MarqueeCrew]

@Cassie_Shaw ,

 you're welcome ☺️