Hi

Not sure whether you want to match or not to match.

1. to match N3 with the array

=IF(ISNA(MATCH(I3,{14,51,61},0)),IF(MATCH(N3,{"CA" ,"CN","KR"},0),IF(AND(K3>=$KP$1,K3<=$KQ$1),(U3*206 53750)/$D$3257,0),IF(I3=14,IF(AND(K3>=$KP$1,K3<=$KQ$1),(U 3*150030)/$D$3262,0),0)))

2. This will exclude the match

=IF(ISNA(MATCH(I3,{14,51,61},0)),IF(ISNA(MATCH(N3, {"CA","CN","KR"},0)),IF(AND(K3>=$KP$1,K3<=$KQ$1),( U3*20653750)/$D$3257,0),IF(I3=14,IF(AND(K3>=$KP$1,K3<=$KQ$1),(U 3*150030)/$D$3262,0),0)))