使用Excel的函数判断某年是否为闰年?这个函数怎么写?答:=IF((MOD(A1,4))+NOT(MOD(A1,100))*MOD(A1,400),"平年",“闰年“)再精简一下:=IF(MOD(A1,4)+(INT(A1%)=A1%)*MOD(A1%,4),"平年","闰年")我这段公式的特点,简洁,高效。省掉了 ...=0,...<>0 。直接利用MOD()函数的结果:为0则FALSE,非0则TRUE。参考资料:谢谢 qinqh...
...输出每年的天干、地支,判断是否闰年并统计闰年的个数?答:定义天干和地支的列表tiangan = ["甲","乙","丙","丁","戊","己","庚","辛","壬","癸"]dizhi = ["子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥"]# 定义一个函数,判断是否为闰年def is_leap_year(year): if year % 4 == 0 and year %...