D2好象不需要公式吧,因为你是从周某表提取的啊.E2中输入=IF(C2>=4,0,IF(B2>989,B2*1.55*5%,IF(B2>839,B2*1.55*3%,IF(B2>700,B2*1.55*2%,B2*1.55))))F2中输入=IF(C2>=3,0,IF(C2>0.5,B2*1.55*6%,B2*1.55*11%))H2中输入=IF(C2>=5,0,IF(G2>=4,IF(G2>=8,10%,IF(G2>=7,9%,IF(G2>=6,8%,IF(G2>=5,7%,6%)))),IF(G2<1,0,IF(G2<2,3%,IF(G2<3,4%,5%)))))I2中输入=E2+F2+H2不知道你D2的定义是什么,... |