[已解决]计算补偿月数

lsmei · 发表于 2012-12-12 15:24

计算补偿月数，补偿月数以12个月封顶

最佳答案

业余爱好者

2012-12-12 15:35

=IF(CEILING(DAYS360(C2,"2012-11-30")/360,0.5)>12,12,CEILING(DAYS360(C2,"2012-11-30")/360,0.5))

=MINA(CEILING(DAYS360(C2,"2012-11-30")/360,0.5),12)

业余爱好者 · 发表于 2012-12-12 15:35

=IF(CEILING(DAYS360(C2,"2012-11-30")/360,0.5)>12,12,CEILING(DAYS360(C2,"2012-11-30")/360,0.5))

=MINA(CEILING(DAYS360(C2,"2012-11-30")/360,0.5),12)

		自动登录	找回密码
密码			注册