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

Question

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.

Capture.PNG

grazitti_sapna · Accepted Answer

@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!