咨询报告编制公式编程.docVIP

工程咨询常用计取费公式编程 工程设计费（H3为工程费（建筑安装费）） =CHOOSE(FIND(1,(AND(H3=200,H3=500))*1(AND(H3500,H3=1000))*1(AND(H31000,H3=3000))*1(AND(H33000,H3=5000))*1(AND(H35000,H3=8000))*1(AND(H38000,H3=10000))*1(AND(H310000,H3=20000))*1(AND(H320000,H3=40000))*1(AND(H340000,H3=60000))*1(AND(H360000,H3=80000))*1(AND(H380000,H3=100000))*1(AND(H3100000,H3=200000))*1(AND(H3200000,H3=400000))*1(AND(H3400000,H3=600000))*1(AND(H3600000,H3=800000))*1(AND(H3800000,H3=1000000))*1(AND(H3=2000000))*1(OR(H3200,)*1),9+(H3-200)/300*11.9,20.9+(H3-500)/500*17.9,38.8+(H3-1000)/2000*65,103.8+(H3-3000)/2000*60.1,163.