Question

诚请大师帮我做一个EXCEL表在表的左边输入中奖号码在右边自动出现其对应的生肖。如输入 13 25时自动生"蛇

Answer 1

在A列中输入数字
在B1中输入或复制粘贴此公式
=MID("龙蛇马羊猴鸡狗猪鼠牛虎免",MOD(A1,12)+1,1)
或
=CHOOSE(MOD(A1,12)+1,"龙","蛇","马","羊","猴","鸡","狗","猪","鼠","牛","虎","兔",)
下拉填充

Answer 2

在b1单元格输入公式=IF((MOD(A1,12)=1),"蛇","")后，在a1单元格输入数字试试看。