判斷同格二數 偶單數 (14117)

C2=MOD(MOD(LEFT(B2,FIND(",",B2)-1),2)+MOD(MID(B2,FIND(",",B2)+1,9),2)*2-1,4)+1

另解=TEXT(MOD(LEFT(B2,FIND(",",B2)-1),2)+MOD(MID(B2,FIND(",",B2)+1,9),2)*2,"0;;4")

另解=MOD(SUM(MOD(TEXT({1,-1}%,SUBSTITUTE(B2,",",";")),2)*{1,2})-1,4)+1

另解=CHOOSE(NPV(1,MOD(TEXT({1,-1}%,SUBSTITUTE(B2,",",";")),2))*4+1,4,2,1,3)