=IF(D955=0,0,IF((YEAR($B$3)-YEAR(D955))0,0,IF((YEAR(S955)-YEAR($B_数学解答

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

人气：384 ℃　时间：2020-03-24 09:18:55

解答

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