=CHOOSE(MOD(A1-1,12)+1,"龙","兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇")
按住填充柄下拉
（如果结果生肖不对,可依次调整公式中的生肖位置. ）
如何用函数把数字转生肖?在A列里有1到49个号码,如何B列里对应出生肖1肖2肖3肖4肖5肖.
=CHOOSE(MOD(A1-1,12)+1,"龙","兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇")
按住填充柄下拉
（如果结果生肖不对,可依次调整公式中的生肖位置. ）