1.如何在excel把十二生肖各生肖所属的几个数字变成所属的生肖文字
假如A列是1-12的数字,B列是生肖,从1至12依次为:"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪"
在B1中输入:
=CHOOSE(MOD(A1,12),"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")
或=MID("鼠牛虎兔龙蛇马羊猴鸡狗猪",MOD(A1,12),1)
下拉即可。
假如A列是出生年份,如A1为“1988”,在B1中输入:
=MID("鼠牛虎兔龙蛇马羊猴鸡狗猪",MOD(A1-4,12)+1,1)
转载请注明出处育才学习网 » 在excel里的羊怎么写