Excel中怎么用函数判断闰年和平年答:=IF(OR((MOD(TEXT(A1,"yyyy"),4)=0)*(MOD(TEXT(A1,"yyyy"),100)<>0),AND(MOD(TEXT(A1,"yyyy"),{100,400})=0))=FALSE,"不是闰年","是闰年")
闰年的条件为:如果能被4整除但不能被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),"平年","闰年"))