B2=LOOKUP(A2,$D$2:$E$4)*A2
或者=LOOKUP(A2,{0,0.85;20000.01,0.9;40000.01,0.95})*A2
或者=IF(A2<=20000,0.85,IF(A2<=40000,0.9,0.95))*A2
公式向下复制
=LOOKUP(A1,{0,20000,40000},{85,90,95}%)*A1
