Multiple conditions (IF)

[Thomas Kuriakose]

Respected Sirs,

I am not able to get the expected results with multiple conditions in the attached file. The expected result is in column K.

Any guidance on this is highly appreciated,

Thank you very much always.

with regards,
thomas

 

[bosco_yip]

Maybe,

I2, copied down :

=IF(AND([@US]="@1",[@ST]="A10",[@A1]="CF",OR([@A3]={"RL","CR"}),OR([@A9]={"RL","CR"})),1,0)

Regards
Bosco

 

[Thomas Kuriakose]

Respected Sir,

Thank you so much for this solution. This worked perfectly.

Very much appreciated,

with regards,
thomas