假定你的7,200,000填基卜在单喊锋枝元格a1,计算结果希望在a2单元格则在单元格郑敏a2中填入=if(a2>5000000,(a2-5000000)*0.0008+1000000*0.0015+4000000*0.0012,if(a2>1000000,(a2-1000000)*0.0012+1000000*0.0015,a2*0.0015))
=MIN(A1*{15,12,8}%%+{0,3,23}%)
