作者:乔山办公网日期:
返回目录:excel表格制作
=IF((B2<1000)+(B2>200000),"错误",IF(B2<=5000,1-(5000-B2)/5000*0.8,IF(B2<=10000,1+(B2-5000)/5000*0.6,IF(B2<=50000,1.6+(B2-50000)/5000*0.4,IF(B2<=100000,4.8+(B2-50000)/5000*0.2,IF(B2<=200000,6.8+(B2-100000)/5000*0.1))))))