QS=
- =IF(OR(AND(业主资料!IO2="首套房",业主资料!IV2<90.01),(AND(业主资料!IO2="二套房",业主资料!IV2<90.01))),业主资料!C2*1%,IF(AND(业主资料!IO2="首套房",业主资料!IV2>90),业主资料!C2*1.5%,IF(AND(业主资料!IO2="二套房",业主资料!IV2>90),业主资料!C2*2%,IF(AND(OR(业主资料!IO2="三套房及以上",业主资料!IO2="商铺",业主资料!IO2="车位"),TEXT(业主资料!IS2,"yyyy-mm-dd")<="2016-08-31"),业主资料!C2*4%,业主资料!C2*3%))))
复制代码 |