请问EXCEL中的公式：ROUND(SUM(TEXT(A14-2000-{0,1,4,10,40,80,120,160,

这里巧妙的利用一个数组公式来计算。我帮你解答下计算过程。A14-2000-{0,1,4,10,40,80,120,160,200}*500这一句你这样理解。假设A14=40001。=4000-2000-{0,1,4,10,40,80,120,160,200}*5002。=2000-{0,1,4,10,40,80,120,160,200}*5003。=2000-{0,500,2000,5000,20000,40000,60000,80000,100000} 500依次乘以花括号中的数值,花括号用于表示数组。4。={2000,1500,0,-3000,-18000,-38000,-58000,-78000,-98000} 现在我们再把这个套进函数里去。ROUND(SUM(TEXT({2000,1500,0,-3000,-18000,-38000,-58000,-78000,-98000} ,"[