00:10:00
問題已解決
這個訴訟費的計算公式，怎么在excel里用函數(shù)表達(dá)出來
溫馨提示：如果以上題目與您遇到的情況不符，可直接提問，隨時問隨時答
同學(xué)你好，有點復(fù)雜，等會上班為你寫一下
2022 05/24 08:16
胡芳芳老師 
2022 05/24 11:23
同學(xué)你好，你這個分段太多了，你先試下，建議你去專門學(xué)習(xí)EXCEL的地方，找專業(yè)老師為你編程=IF(C2<=2000,IF(C2<=1000,IF(C2<=500,IF(C2<=200,IF(C2<=100,IF(C2<=50,IF(C2<=20,IF(C2<=10,C2*2.5%,10*2.5%+(C2-10)*2%,10*2.5%+10*2%+(C2-20)*1.5%,10*2.5%+10*2%+30*1.5%+(C2-50)*1%,10*2.5%+10*2%+30*1.5%+50*1%+(C2-100)*0.9%,10*2.5%+10*2%+30*1.5%+50*1%+100*0.9%+(C2-200)*0.8%,10*2.5%+10*2%+30*1.5%+50*1%+100*0.9%+300*0.8%+(C2-500)*0.7%,10*2.5%+10*2%+30*1.5%+50*1%+100*0.9%+300*0.8%+500*0.7%+(C2-1000)*0.6%,10*2.5%+10*2%+30*1.5%+50*1%+100*0.9%+300*0.8%+500*0.7%+1000*0.6%+(C2-2000)*0.5%)
閱讀 1664
描述你的問題，直接向老師提問
10970
意見反饋
