(资料图片仅供参考)
1、数据在a1大小:=IF(-- MID(A1,1,1)>4,"大","小")&IF(-- MID(A1,2,1)>4,"大","小")&IF(--MID(A1,3,1)>4,"大","小")&IF(--MID(A1,4,1)>4,"大","小")&IF(--MID(A1,5,1)>4,"大","小")单双:=IF(mod(-- MID(A1,1,1),2)=0,"双","单")&IF(mod(-- MID(A1,2,1),2)=0,"双","单")&IF(mod(-- MID(A1,3,1),2)=0,"双","单")&IF(mod(-- MID(A1,4,1),2)=0,"双","单")&IF(mod(-- MID(A1,5,1),2)=0,"双","单")。
本文就为大家分享到这里,希望小伙伴们会喜欢。
关键词: