假设总价金额右侧单元格为B6,收费计算公式如下:
=HLOOKUP(B6,{100,200,400,600,800,1000,1200,1400;50,62,72,90,106,118,128,134},2,1)+(B6-LOOKUP(B6,{0,100,200,400,600,800,1000,1200,1400}))*HLOOKUP(B6,{100,200,400,600,800,1000,1200,1400;0.12,0.1,0.09,0.08,0.06,0.05,0.03,0.02},2,1)
本回答被网友采纳