Excel的choose函数!!

发布网友 发布时间：2022-04-22 22:18

我来回答

共4个回答

热心网友 时间：2022-05-07 04:42

这个函数排列有误。

这里给个正确的函数：

=CHOOSE(MOD(YEAR(A3)-4,12)+1,"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")

解释：
1.year函数，获取A3的年份，并减去4.

2.用mod函数取模。也就是，将年份减去4之后，除以12，取余数。然后再将该数值加上1.

3.用choose函数将按余数的顺序来取值。例如用mod函数之后得到11，则将取“鼠”……里的第十一个也就是“狗”。

热心网友 时间：2022-05-07 06:00

经过验证：因为你只是F7内输入19，而非真正的日期模式。你的公式应写成（复制）以下公式：
=CHOOSE(MOD(ABS(F7+1-1904),12),"龙","蛇","马","羊","猴","鸡","狗","猪","鼠","牛","虎","兔")

热心网友 时间：2022-05-07 07:35

我看不管那年都是兔 ,如果是把公历年份转为农历生肖我看这样就行
=CHOOSE(MOD(F7,12)+1,"猴","鸡","狗","猪","鼠","牛","虎","兔","龙","蛇","马","羊",)

热心网友 时间：2022-05-07 09:26

正确的公式如下，应该先取余数再求绝对值
=CHOOSE(ABS(MOD(YEAR(A1)-1977,12))+1,"蛇","马","羊","猴","鸡","狗","猪","鼠","牛","虎","兔","龙")
A1=1883-1-1