EXCEL题目中4.判断客户的出生年份是否为闰年,将结果“是”或者“否...答:三、假设A列为出生日期,B列为判断是否为闰年,在B2单元格里面输入公式=IF($A2="","",IF(MOD(YEAR($A2),100)=0,IF(MOD(YEAR($A2),400)=0,"是","否"),IF(MOD(YEAR($A2),4)=0,"是","否"))),即:①判断A2单元格是否为空白,如果是空白,则显示空白,否则进行后面的运算;②...
EXCEL题目中4.判断客户的出生年份是否为闰年,将结果“是”或者“否...答:假设出生年份写在A1单元格\x0d\x0a公式如下\x0d\x0a=IF(OR(MOD(A1,400)=0,AND(MOD(A1,4)=0,MOD(A1,100)0)),"是","否")\x0d\x0a \x0d\x0a如果写在A1单元格的是出生日期则公式如下\x0d\x0a=IF(OR(MOD(YEAR(A1),400)=0,AND(MOD(YEAR(A1),4)=0,MOD(YEAR(A1),...