EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/05 23:16:46

EXCEL的题目
=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)=0,IF(MOD(YEAR(TODAY()),400)=0,"闰年","平年"),"闰年"),"平年"）这里每个if的内容是什么太混乱了

先看最里面的也就是第三个IF(MOD(YEAR(TODAY()),400)=0,"闰年","平年")
表示在MOD(YEAR(TODAY()),400)=0成立的时候显示闰年,不成立显示平年.
然后看中间一层的也就是第二个IF(MOD(YEAR(TODAY()),100)=0,IF(MOD(YEAR(TODAY()),400)=0,"闰年","平年"),"闰年")
表示在MOD(YEAR(TODAY()),100)=0成立的时候,再经第一个IF判定,显示第一个IF的结果,如果不成立直接显闰年.
最后看大的IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)=0,IF(MOD(YEAR(TODAY()),400)=0,"闰年","平年"),"闰年"),"平年"）
表示在MOD(YEAR(TODAY()),4)=0成立的时候经过上边第二个判定,显示其结果,如果不成立,直接显示平年.

EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100) EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),1 公式=IF(L8"",YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格 EXCEL中解释下=if(mod(A1,2),B1, IF函数:=IF(MOD(单号,2)0,1,0) 在excel中YEAR(TODAY())-IF(LEN(C2)=15,"19"&MID(C2,7,2),MID(C2,7 excel公式中 =IF(MOD(MID(E4,17,1),2)=0,"女", 请帮我解释一下excel中这个语句是什么意思 =IF(MOD(6,2),1,0) 在excel中 0.55*100是偶数?用的公式为=if（mod（0.55*100）,"奇数","偶数"） =IF(MOD(ROW(),3),OFFSET(工资表!$A$1,(MOD(ROW()-1,3)>0)*ROUND(RO =IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!B$1,INDEX(She IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!A$1,INDEX(Shee