IF and AND statement formulae

Question

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 Answer

Hi @Bryth

The ELSE is missing.

Syntax is:

IF condition

THEN

ELSE

ENDIF

Many thanks

Shanker V

Emmanuel_G · Accepted Answer

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