IF and AND statement formulae

[Bryth]

Hello team, I am quite new to Alteryx and still learning. I need to write a formulae, using IF and AND function. this is what I have written. I have a filed called match( created this field with a formulae. I want to update another field called Team with either FMR or SOCA if the match field is "N" I used the IF and AND combination to write the formulae but I get this error all the time. what am I doing wrong with this. thank you in advance. 

IF [match]="N" AND [Team]= "FMR" THEN "SOCA" EndIF

[ShankerV · Accepted solution]

Hi @Bryth 

The ELSE is missing.

Syntax is:

IF condition

THEN

ELSE

ENDIF 

Many thanks

Shanker V

[BS_THE_ANALYST]

You need an ELSE criteria aswell @Bryth .. see picture below

[Emmanuel_G · Accepted solution]

Hi @Bryth 

As @BS_THE_ANALYST  and @ShankerV  said, the else statement is missing in your statement and it is mandatory.

If you don't want to write it explicitly in all your if statements, you can use IIF function according to this syntax : IIF(logical_test,value true,value fase) as in excel.

In your case, the result is IIF([match]="N" AND [Team]= "FMR","SOCA",Null()) endif

[Bryth]

Thank you guy's. i appreciate it a lot. it worked.