問(wèn)題已解決
這個(gè)訴訟費(fèi)的計(jì)算公式,怎么在excel里用函數(shù)表達(dá)出來(lái)
溫馨提示:如果以上題目與您遇到的情況不符,可直接提問(wèn),隨時(shí)問(wèn)隨時(shí)答
速問(wèn)速答同學(xué)你好,有點(diǎn)復(fù)雜,等會(huì)上班為你寫一下
2022 05/24 08:16
胡芳芳老師
2022 05/24 11:23
同學(xué)你好,你這個(gè)分段太多了,你先試下,建議你去專門學(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%)
閱讀 1598