Error: Formula (38): Parse Error at char(119): Malformed If Statement (Expression #4)

[Karl_Spratt]

Hi Community ,

Need some help please, I'm trying to write a IF formula to say 

If the Frame column contains the value SIMMERN  ( there are F1 SIMMERN and F2 SIMMERN values in this column along with other values, also GD Or Champ Item contains the partial value IR

This is what I wrote, and I'm getting the error 

IF Contains([Frame], "SIMMERN")
AND If Contains([GD Or Champ Item], "IR")
THEN 'IR /GD Brand' ELSE 'Non IR Brand' ENDIF

Can someone please explain the fix here please. 

[binu_acs]

@Karl_Spratt 

IF Contains([Frame], "SIMMERN") AND Contains([GD Or Champ Item], "IR")
THEN 'IR /GD Brand'

ELSE 'Non IR Brand'

ENDIF

[grazitti_sapna · Accepted solution]

@Karl_Spratt, the formula you mentioned contains an IF after and operator which is incorrect

IF Contains([Frame], "SIMMERN")
AND If Contains([GD Or Champ Item], "IR")
THEN 'IR /GD Brand' ELSE 'Non IR Brand' ENDIF

Correct Syntax:

IF Contains([Frame], "SIMMERN")
AND Contains([GD Or Champ Item], "IR")
THEN 'IR /GD Brand' ELSE 'Non IR Brand' ENDIF

I hope this helps!

Thanks!