第一问答网»论坛 › 中问网 › 问答 › excel 函数关于生肖2010年

excel 函数关于生肖2010年

[复制链接]

11 |

4 | 2012-4-10 03:20:49 | 显示全部楼层 |阅读模式

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

使用道具举报

千问 | 2012-4-10 03:20:49 | 显示全部楼层

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

使用道具举报

千问 | 2012-4-10 03:20:49 | 显示全部楼层

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

使用道具举报