Multi Condition Formula

Question

Hi

How can I put multi condition formula?

for example in attached Excel i want to have 'Pass' if all criteria is pass and 'Fail' even if 1 criteria is fail.

I put the below formula but the result is not correct.

IF [POSITION_SOURCE(1)] AND [POSITION_SOURCE(1)] AND [LOCATION_UNCERTAINTY(1)] AND [ESRK(1)]='Pass' THEN 'Pass' ELSE 'Fail' ENDIF

Test-send to Alteryx.xlsx

Claje · Accepted Answer

Hi,

Try the following formula:

IF [POSITION_SOURCE(1)] ='Pass' AND [POSITION_SOURCE(1)] ='Pass' AND [LOCATION_UNCERTAINTY(1)] ='Pass' AND [ESRK(1)]='Pass' THEN 'Pass' ELSE 'Fail' ENDIF

Basically, you have to call out the test for each condition between AND statements.  What your previous code was doing was checking if each field (other than ESRK(1)) was equal to true or 1, since that is what an IF statement evaluates.

This is why all results were coming across as Fail.