ROUND(MAX((H5-I5-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)
EXCEL的个税公式？
用if()或者SWITCH()加 EVAL() 吧（SWITCH()判断出个税公式，EVAL()计算公式）
为什么要乘那么多数字？
ROUND(MAX((H5-I5-5000)*[0.03,0.1,0.2,0.25,0.3,0.35,0.45]-[0,210,1410,2660,4410,7160,15160],0),2)
把{}换成[]试一下,我是来一下可以。
1min目标场景问卷
立即参与
ROUND(MAX((H5-I5-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)
