excel 函数 =if(or(and(mod(a2,4)=0,mod(a2,100<>0,mod(a2,100)=0...答:mod(a2,100<>0,mod(a2,100)=0 这样的写法是错误的,格式,参数都错了 100<>0 意思是100不等于0,"<>"是不等于号 四年一闰,百年不闰,四百年再闰 B2单元格的公式应写成 =IF(OR(MOD(A2,400)=0,AND(MOD(A2,4)=0,MOD(A2,100)<>0)),"闰年","平年")下拉复制公式 ...
excel操作答:B5单元格输入公式 =IF(OR(B4/400=INT(B4/400),AND(B4/4=INT(B4/4),B4/100<>INT(B4/100))),"润年","平年")或 =IF(OR(MOD(B4,400)=0,AND(MOD(B4,4)=0,MOD(B4,100)<>0)),"润年","平年")