在EXCEL中,如果设02468为偶数,13579

在EXCEL中,如果设02468为偶数,13579为奇数,假如A1=036的三位数,那么A2按百十个位.显示偶奇偶,请问

1个回答

a1= 036
a2 =IF(MOD(LEFT(A1),2),"奇","偶")&IF(MOD(MID(A1,2,1),2),"奇","偶")&IF(MOD(RIGHT(A1),2),"奇","偶")