=IF(D955=0,0,IF((YEAR($B$3)-YEAR(D955))0,0,IF((YEAR(S955)-YE
来源:学生作业帮 编辑:神马作文网作业帮 分类:数学作业 时间:2024/09/30 00:28:04
=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.
现在来看,就是如果“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)))的复制单元格