...不能被100整除,或者能被400整除,就是闰年,否则是平年。答:=IF(A2>0,IF((MOD(A2,4))+NOT(MOD(A2,100))*MOD(A2,400),"平年","闰年"),IF((MOD(ABS(A2+401),4))+NOT(MOD(ABS(401+A2),100))*MOD(ABS(401+A2),400),"平年","闰年"))
Excel中怎么用函数判断闰年和平年答:=IF(OR((MOD(TEXT(A1,"yyyy"),4)=0)*(MOD(TEXT(A1,"yyyy"),100)<>0),AND(MOD(TEXT(A1,"yyyy"),{100,400})=0))=FALSE,"不是闰年","是闰年")