求教高手,帮忙一下,如何在EXCEL表格中计算分段累进函数。具体如下...答:=if(or(C2=0,C2<0),B2*0.015,if(C2/A2<0.1,C2*0.2,if( and(or(C2/A2>0.1,C2/A2=0.1 ), C2/A2<0.2),C2*0.3,if(and(not(C2/A2<0.2),C2/A2<0.3),C2*0.4,C2*0.5)))
求excel累进分段计息公式答:=F(C2<=7,1,IF(C2<91,1.2%,IF(C2<121,1.3%,IF(C2<151,1.4%,IF(C2<181,1.5%,2.4%)))*B2