|
=IF(K3<=$AG$2,AD3+1400,IF($AG$2<K3<=$AH$2,AD3+1100,IF($AH$2<K3<=$AI$2,AD3+800,AD3+200)))
K3是个日期,AD3是个数值,AG2是2010/12/31,AH2是2011/12/31,AI2是2012/12/31
这样对么为什么我就返回AD3+1400和AD3+200两个数值
本帖最后由 E路人 于 2013-12-6 11:01 编辑
- =IF(K3<=$AG$2,AD3+1400,IF(K3<=$AH$2,AD3+1100,IF(K3<=$AI$2,AD3+800,AD3+200)))
复制代码
|
|