在excel表格里,如何用一个公式表示两个变量的分段函数,举个例子就是...答:C1公式=IF(AND(A1>=4000,B1>=29),A1/100*2+(B1-19)*2.4,IF(AND(A1>=4000,B1<29),A1/100*2+(B1-29)*1.2,IF(AND(A1<4000,B1>=29),A1/100+(B1-29)*2.4,IF(AND(A1<4000,B1<29),A1/100+(B1-29)*1.2,"")))...
EXCEL怎么处理分段函数答:在B2中输入或复制粘贴此公式 =IF(A2="","",IF(A2>0,IF(A2<50,0.7*A2,IF(A2<100,0.8*(A2-50)+35,IF(A2<150,0.8*(A2-100)+75,IF(A2<200,0.7*(A2-150)+115,IF(A2>200,A2-50,""))),""))下拉填充
excel怎么设置分段函数 当x小于或等于5时 y=ax , 当x大于5小于或等于100...答:假设A1单元格写入X值,B1单元格是求Y值 B1单元格输入公式 =IF(A1="","",IF(A1<=5,A1*a,IF(A1<=100,A1*b,IF(A1<2000,A1*c,"")))公式中的"a,b,c"换成你要的常数,公式的意思为当A1为空值时,值为空,A1小于等于5时,A1乘以常数a,如果不符合,则A1小等于100时计算A1乘以常数b,如果...
excel 分段函数公式答:=LOOKUP(A1,{0,10000,100000,200000,500000,1000000,2000000,5000000,10000000,20000000},{50,50,2300,4300.88,13800,22800,46800,81800,141800})+(A1-LOOKUP(A1,{0,10000,100000,200000,500000,1000000,2000000,5000000,10000000,20000000}))*LOOKUP(A1,{0,10000,100000,200000,500000,1000000,...
请大神用excel画一下这个分段函数 谢谢答:可以利用if函数来实现:=IF(A2<=1,0.15*A2,IF(A2<=2,0.15+0.2*(A2-1),IF(A2<=4,0.35+0.25*(A2-2),IF(A2<=8,0.85+0.3*(A2-4),IF(A2<=16,2.05+0.35*(A2-8),4.85+0.4*(A2-16)))