Multi Condition Formula

[roham]

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

[Claje · Accepted solution]

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.

[roham]

That worked, Thanks.