Excel中怎么用函数判断闰年和平年答:=IF(OR((MOD(TEXT(A1,"yyyy"),4)=0)*(MOD(TEXT(A1,"yyyy"),100)<>0),AND(MOD(TEXT(A1,"yyyy"),{100,400})=0))=FALSE,"不是闰年","是闰年")
excel的题目,使用函数判断是否为闰年,这个函数怎么写,求高手赐教答案...答:B1=IF(OR(AND(MOD(A1,100)=0,MOD(A1,400)<>0),MOD(A1,4)<>0),"平年","闰年")