Correct this Conditional Statement

[StellaBon]

IF Contains([Concat_Product_Category], "Technology")

AND
IF Contains([Concat_Shipping Method], "Freight")
THEN "REVIEW"
ELSE Null()
ENDIF

I have tried the Null with and without quotation marks and I'm still getting an error that this is a malformed statement. 

Thank you!

[Oswaldo · Accepted solution]

You need to wrap the conditional statement with parenthesis.

IF (Contains([All Product Categories],"Technology") AND Contains([All Shipping Methods],"Freight")) THEN "REVIEW" ELSE Null() ENDIF

[StellaBon]

Thank you! I also had a second unnecessary IF in there. Thanks so much for your help, this was driving me crazy!

StellaBon

[Oswaldo]

You're right, I didn't notice the second IF. You're welcome!