如何运用if函数的计算提成操作实例

Question

提成=销售额*销售提成系数
销售提成系数比例：达标率≤60% ,提成系数2%，60%<个人达标率≤75%，提成系数2.3%，75%<个人达标率≤85%，提成系数2.6%，85%<个人达标率≤100%，提成系数3%，100%<个人达标率，提成系数3.5%
例：销售额252500 ，达标率120%。
请问如何运用函数计算公式？？？

Answer 1

假设个人达标率数据写在A1单元格,销售额数据写在B1单元格,则计算公式为
=IF(A1="","",B1*IF(A1<=0.6,0.02,IF(A1<=0.75,0.023,IF(A1<=0.85,0.026,IF(A1<=1,0.03,0.035)))))
或
=IF(A1="","",B1*IF(A1>1,3.5%,IF(A1>85%,3%,IF(A1>75%,2.6%,IF(A1>60%,2.3%,2%)))))
再或
=IF(A1="","",B1*LOOKUP(A1,{0,60.01,75.01,85.01,1.01}%,{2,2.3,2.6,3,3.5}%))