=IF(D955=0,0,IF((YEAR($B$3)-YEAR(D955))0,0,IF((YEAR(S955)-YE

来源：学生作业帮编辑：搜搜做题作业网作业帮分类：数学作业时间：2024/06/01 23:21:20

=IF(D955=0,0,IF((YEAR($B$3)-YEAR(D955))0,0,IF((YEAR(S955)-YEAR($B$3))=0,MONTH(S955),12)))))

如果你能把表格描述一下或者发上来,就更好给你解释了.
现在来看,就是如果“D955=0”,结果就是0.
如果“D955不等于0”,就比较D955和YEAR($B$3),YEAR($B$3)小于0时结果等于0,YEAR($B$3)等于D955时结果是月份的差,YEAR($B$3)大于D955时就比较$B$3和S955的年份.
$B$3的年份大于S955时结果为0,年份相等时结果为S955的月份,$B$3的年份小于S955时结果为12.

=IF(D955=0,0,IF((YEAR($B$3)-YEAR(D955))0,0,IF((YEAR(S955)-YE EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100) if (year < 2000) year=year+1900 if( ((LunarCalendarTable[year-1901] & 0x0060) >> 5) == 1) C 语言 if(year%400==0||(year%4==0&&year%100!=0))/*判断是不是闰年*/ c语言,if(year%4==0&&year%100!=0) printf("%d is a leap year.\n" 阿门~判断闰年的代码是if (year % 4 == 0 && year % 100 = 0 || year % 400 if(year%400=0||(year%4==0&&year%100!=0)) leap=1; else leap=0 C语言判断闰年if((year%4==0 && year%100!=0) || (year%400==0 C语言解惑if(year%400==0||(year%4==0&&year%100!=0))/*判断是不是闰年* if(year@00||(year@&&year\x100! 公式=IF(L8"",YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格