|
=IF(AND(INT(MID(A1,1,1)/2)=MID(A1,1,1)/2,INT(MID(A1,2,1)/2)=MID(A1,2,1)/2,INT(MID(A1,3,1)/2)=MID(A1,3,1)/2),"全双",IF(INT(MID(A1,1,1)/2+ MID(A1,2,1)/2+ MID(A1,3,1)/2)= MID(A1,1,1)/2+ MID(A1,2,1)/2+ MID(A1,3,1)/2,"双",IF(AND(INT(MID(A1,1,1)/2)MID(A1,1,1)/2,INT(MID(A1,2,1)/2)MID(A1,2,1)/2,INT(MID(A1,3,1)/2)MID(A1,3,1)/2),"全单","... |
