=IF(AND(G2<1000,C2="住宅"),0,IF(AND(G2>=1000,G2<2000,C2="住宅"),0,IF(AND(G2>=2000,G2<20000,C2="住宅"),0,IF(AND(G2>=20000,C2="住宅"),G2*0.015*F2,IF(AND(G2<1000,C2="非住宅"),0,IF(AND(G2>=1000,G2<2000,C2="非住宅"),0,IF(AND(G2>=2000,G2<20000,C2="非住宅"),0,IF(AND(G2>=20000,C2="非住宅"),G2*0.015*F2,"/"))))))))
=IF(AND(G2<1000,C2="住宅"),0,IF(AND(G2>=1000,G2<2000,C2="住宅"),0,IF(AND(G2>=2000,G2<20000,C2="住宅"),0,IF(AND(G2>=20000,C2="住宅"),G2*0.015*F2,IF(AND(G2<1000,C2="非住宅"),0,IF(AND(G2>=1000,G2<2000,C2="非住宅"),0,IF(AND(G2>=2000,G2<20000,C2="非住宅"),0,IF(AND(G2>=20000,C2="非住宅"),G2*0.05*F2,"/"))))))))
一开始的公式有误,最后的改为G2*0.05*F2。
你说对了,详情再看补充问题。另一条公式里面,0变成了一条有2个不同系数的计算方式,一个是0.04,一个是0.06。
追答=IF(G2<20000,0,IF(C2="住宅",G2*0.015*F2,IF(C2="非住宅",G2*0.05*F2,"/")))
楼主看看这样可以吗