excel 函数关于生肖2010年

发布网友发布时间：2022-05-17 14:47

共4个回答

热心网友时间：2023-10-25 11:52

年 A2=年份生肖 B2 =CHOOSE(IF(MOD(A2-3,12)=0,MOD(A2-3,12)+12,MOD(A2-3,12)),"鼠","牛","虎","兔","龙","蛇","马",",

热心网友时间：2023-10-25 11:53

A2=choose(mod(A1,12)+1,"兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙")

热心网友时间：2023-10-25 11:53

=lookup(mod(a1-1,12)+1,row(1:12),{"虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙","兔"})
这个公式去年能用，
我觉得今年的话应该改为
=lookup(mod(a1-1,12)+1,row(1:12),{"兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙"})

热心网友时间：2023-10-25 11:54

A1轸输入年份
=MID("猴鸡狗猪鼠牛虎兔龙蛇马羊",MOD(A1,12)+1,1)

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com

excel 函数 关于生肖2010年

excel 函数关于生肖2010年