IF(A2<>"",ROUND(IF(0<A2<=1600,0,SUM(IF((A2-1600>={0,500,2000,5000,20000,40000,60000,80000,100000})+(A2-1600<{500,2000,5000,20000,40000,60000,80000,100000,100001})=2,(A2-1600)*{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}-{0,25,125,375,1375,3375,6375,10375,15375},0))),2),"")<br/><br/><br/>这
个方法中,为什么一定要有A2<>""?并且为什么要有(A2-1600>=
{0,500,2000,5000,20000,40000,60000,80000,100000})+(A2-1600<
{500,2000,5000,20000,40000,60000,80000,100000,100001})=2, =2 是什么意思呢?
百思不得其解啊,<br/><img border="0" align="middle" alt="图片点击可在新窗口打开查看" src="Skins/Default/emot/em06.gif" title="dvubb"/><br/><br/>恳请解答!!!万分感谢 |