excel函数分段计算（excel分段函数的公式）

假定金额在B2单元格，则用公式：=IF(B2<=100000,B2*2.05%,IF(B2<=200000,100000*2.05%+(B2-100000)*1.45%,IF(B2<=300000,100000*2.05%+100000*1.45%+(B2-200000)*0.85%,100000*2.05%+100000*1.45%+100000*0.85%+(B2-300000)*0.25%)))注意：你一会儿说 *1.45%一会儿说 *.0.145%