excel中，当某一单元格是特定文字时，如何在另一单元格显示对应的数字？

1、以在单元格中输入数字，在另一单元格内显示生肖为例，首先在单元格A1中输入数字“10”。 2、然后在B1单元格中输入公式： =CHOOSE(MOD(A1,12),"猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡")。意思是