求excel计算诉讼费的公式答:B1中输入公式 =IF(A1<10000,50,IF(A1<100000,A1*0.025-200,IF(A1<200000,A1*0.02+300,IF(A1<500000,A1*0.015+1300,IF(A1<1000000,A1%+380,A1*0.009+4800)))下拉复制到你需要的行
请电脑高手编写诉讼费及律师费EXCEL计算公式,计算方式见补充内容,计 ...答:算诉讼费的公式:(公式中的A11改为实际价额的单元格即可)=CHOOSE(LOOKUP(A11,{0,10000,100000,200000,500000,1000000,2000000,5000000,10000000,20000000},{1,2,3,4,5,6,7,8,9,10}),50,50+(A11-10000)*0.025,2300+(A11-100000)*0.02,4300+(A11-200000)*0.015,8800+(A11-500000)*0....