重新發送了

你好，有round的都去掉就行

去掉報錯了，有些是有連接關系的，不知道咋弄，可以幫忙編輯一下嗎，麻煩了

=IF(IF(E2<=0.5,0.5,IF(ROUND(E2,0)-E2>=0,ROUND(E2,0),ROUND(E2,0)+1))<=0.5,VLOOKUP(@D:D,價格表!A:C,2,0),IF(IF(E2<=0.5,0.5,IF(ROUND(E2,0)-E2>=0,ROUND(E2,0),ROUND(E2,0)+1))<=1,VLOOKUP(@D:D,價格表!A:C,3,0),IF(IF(E2<=0.5,0.5,IF(ROUND(E2,0)-E2>=0,ROUND(E2,0),ROUND(E2,0)+1))<=2,VLOOKUP(@D:D,價格表!A:D,4,0),IF(IF(E2<

你替換，把round(e2,0)替換為e2即可

=0.5,0.5,IF(ROUND(E2,0)-E2>=0,ROUND(E2,0),ROUND(E2,0)+1))<=3,VLOOKUP(@D:D,價格表!A:E,5,0),(IF(E2<=0.5,0.5,IF(ROUND(E2,0)-E2>=0,ROUND(E2,0),ROUND(E2,0)+1)-1))*VLOOKUP(@D:D,價格表!A:G,7,0)+VLOOKUP(@D:D,價格表!A:F,6,0)))))

我先試試哈

ok，等著你的成功運行

弄好了，謝謝老師

客氣，非常榮幸能夠給您支持