谁能帮忙解读一下这个公式,谢谢
=IF(E5=0,0,IF($O$1<E5,0,IF(DATEDIF(E5,$O$1,"m")=K5,ROUND(I5-M5-N5*(K5-1),2),ROUND(IF(...
=IF(E5=0,0,IF($O$1<E5,0,IF(DATEDIF(E5,$O$1,"m")=K5,ROUND(I5-M5-N5*(K5-1),2),ROUND(IF(OR((TRUNC($O$1-E5)/365*12)>K5,(TRUNC($O$1-E5)/365*12)<1),0,N5),2))))
展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询