使用excel对彩票号码进行自动归类

2024-12-28 20:32:51

推荐回答（3个）

回答1：

你的数字分类没有规律,公式简不了多少:
=IF((A1<1)+(A1>49),"",MID("金木水火土",MATCH(MATCH(A1,{8,9,16,17,24,25,38,39,46,47,6,7,20,21,28,29,36,37,4,5,12,13,26,27,34,35,42,43,1,14,15,22,23,30,31,44,45,2,3,10,11,18,19,32,33,40,41,48,49},),{1,11,19,29,38},ROW($1:$5)),1)&"号")

回答2：

=IF(OR(A1={08,09,16,17,24,25,38,39,46,47}),"金号",IF(OR(A1={06,07,20,21,28,29,36,37}),"木号", IF(OR(A1={04,05,12,13,26,27,34,35,42,43}),"水号", IF(OR(A1={01,14,15,22,23,30,31,44,45}),"火号", IF(OR(A1={02,03,10,11,18,19,32,33,40,41,48,49}),"土号","")))))
最后少了两个括号

回答3：

要不得