关于wps，在a1单元格随便输入一个数字，（1-49），要在b1单元格显示对应生肖，是用于六和采的
发布网友
共1个回答
热心网友
=IF(A1="","",CHOOSE(MOD(A1,12)+1,"羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡","猴"))
或
=IF(A1="","",MID("羊马蛇龙兔虎牛鼠猪狗鸡猴",MOD(A1,12)+1,1))
