请问EXCEL中的公式:ROUND(SUM(TEXT(A14-2000-{0,1,4,10,40,80,120,16...答:这里巧妙的利用一个数组公式来计算.我帮你解答下计算过程.A14-2000-{0,1,4,10,40,80,120,160,200}*500这一句你这样理解.假设A14=4000 1.=4000-2000-{0,1,4,10,40,80,120,160,200}*500 2.=2000-{0,1,4,10,40,80,120,160,200}*500 3.=2000-{0,500,2000,5000,20000,40000,...