B2=MAX((A2)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0)
或者=IF(A2> 80000,A2*0.45-13505,IF(A2 > 55000,A2*0.35-5505,IF(A2 > 35000,A2*0.3-2755,IF(A2 > 9000,A2*0.25-1005,IF(A2 > 4500,A2*0.2-555,IF(A2 >1500,A2*0.1-105,IF(A2 >0,A2*0.03,0 )))))))
向下复制
温馨提示：答案为网友推荐，仅供参考
相似回答