Question

excel 函数问题

=CHOOSE(MOD(YEAR(F1)-4,12)+1,"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")
为什么年那里要减去4呢？别人说什么1900/4余数为4是什么意思啊

Answer 1

那个是先减后除。。一般算法是先除后减。。算法对换了而已。。但是性质一样

Answer 2

都是单元格名子，Excel的列用字母表示，行用数字表示，列从A开始直到Z，然后AA，AB，直到AZ等等，行用数字1一直到65535.你上边的AE12就是第AE列12行那个单元格，其它类似，不再叙述。

Answer 3

这样就不要减4了，=CHOOSE(MOD(YEAR(F1),12)+1,"猴","鸡","狗","猪","鼠","牛","虎","兔","龙","蛇","马","羊")