I3输入=if(H3=1,G3*$B$3*0.8,if(H3=3,G3*$B$4*0.8,"错误"))J3输入=I3+G3其中0.8为扣除利息税,错误为提示信息
在I3 输入 =IF(H3=1,G3*$B$3-G3*$B$3*0.2,IF(H3=3,G3*$B$4-G3*$B$4*0.2,""))在J3输入 =IF(H3="","",I3+G3)