求助,关于大小单双的问题我以前用的区分大小（大于10为大；小于等于10为小)的公式为=IF(SUMPRODUCT(--COUNTIF($I3,CHOOSE(COLUMN(A1),{1,2,3,4,5,6,7,8,9,10},{10,11,12,13,14,16,15,17,18,19,20,21,22}))),CHOOSE(COLUMN(A3),"小

Question

求助,关于大小单双的问题
我以前用的区分大小（大于10为大；小于等于10为小)的公式为
=IF(SUMPRODUCT(--COUNTIF($I3,CHOOSE(COLUMN(A1),{1,2,3,4,5,6,7,8,9,10},{10,11,12,13,14,16,15,17,18,19,20,21,22}))),CHOOSE(COLUMN(A3),"小","大"),"")
单双用的公式为
=IF(SUMPRODUCT(--COUNTIF($I3,CHOOSE(COLUMN(A1),{2,4,6,8,10,12,14,16},{1,3,5,7,9,11,13,15}))),CHOOSE(COLUMN(A3),"双","单"),"")
我的问题是,是否还有其他公式区分大小,单双的
如
A列 B C D E
22 大 双
05 小 单

Answer 1

大小=IF($A1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小",""))
单双=IF(MOD($A1,2),IF(COLUMN(A1)=2,"单",""),IF(COLUMN(A1)=1,"双",""))