Question

EXCEL请教一下，在excel把十二生肖各生肖所属的几个数字变成所属的生肖文字，

自己用IF函数公式，说太长了，用不了，请高手指教，就是在B10输入1在C10就相对蛇 上一部份给你们看看

=IF(B10=1,"蛇",IF(B10=13,"蛇",IF(B10=25,"蛇",IF(B10=37,"蛇",IF(B10=49,"蛇",IF(B10=61,"蛇",IF(B10=73,"蛇",IF(B10=85,"蛇",IF

(B10=97,"蛇",IF(B10=109,"蛇",IF(B10=121,"蛇",IF(B10=133,"蛇",IF(B10=145,"蛇",IF(B10=157,"蛇",IF(B10=169,"蛇",IF

(B10=181,"蛇",IF(B10=193,"蛇",IF(B10=205,"蛇",IF(B10=217,"蛇",IF(B10=229,"蛇",IF(B10=241,"蛇"IF(B10=2,"龙",IF(B10=14,"龙",IF

(B10=26,"龙",IF(B10=38,"龙",IF(B10=50,"龙",IF(B10=62,"龙",IF(B10=74,"龙",IF(B10=86,"龙",IF(B10=98,"龙",IF(B10=110,"龙",IF

(B10=122,"龙",IF(B10=134,"龙",IF(B10=146,"龙",IF(B10=158,"龙",IF(B10=170,"龙",IF(B10=182,"龙",IF(B10=194,"龙",IF

(B10=206,"龙",IF(B10=218,"龙",IF(B10=230,"龙",IF(B10=242,"龙"IF(B10=3,"兔",IF(B10=15,"兔",IF(B10=27,"兔",IF(B10=39,"兔",IF

(B10=51,"兔",IF(B10=63,"兔",IF(B10=75,"兔",IF(B10=87,"兔",IF(B10=99,"兔",IF(B10=111,"兔",IF(B10=123,"兔",IF(B10=135,"兔",IF

(B10=147,"兔",IF(B10=159,"兔",IF(B10=171,"兔",IF(B10=183,"兔",IF(B10=195,"兔",IF(B10=207,"兔",IF(B10=219,"兔",IF

(B10=231,"兔",IF(B10=243,"兔"

Answer 1

=CHOOSE(MOD(B10,12)+1,"猪","鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗")
不太清楚你的生肖排序是什么，上面公式是按正常的生肖排序排的，如有需要自己调整。
即B10输入1-12时得到鼠、牛、虎、兔、龙、蛇、马、羊、猴、鸡、狗、猪。

Answer 2

将公式改一下就行了.
我是按这个顺序写公式的.
1鼠 2牛 3虎 4兔 5龙 6蛇 7马 8羊 9猴 10鸡 11狗 12猪

=CHOOSE(MOD(B10,12),"鼠", "牛", "虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")

Answer 3

可以把数字和文字排成两列，然后用vlookup吧

追问

能举个例子吗，谢谢