EXCEL多个假设条件如何设置答:在E1单元格内输入内容:=IF(D1>A1*1.1,C1*50%,IF(AND(D1>A1,D1<A1*1.1),C1*80%,IF(D1=A1,C1,IF(AND(D1<A1,D1>(A1-B1)/3),(A1-D1)/(A1-B1)*C1/(A1-B1)*0.9,"")))然后在A1,B1,C1,D1 中输入数字,就可以看到结果。
excel如何设置假设条件的公式答:=IF(D3<=0,5*C3,IF(AND(D3>0,D3<=200),B3*1.2,IF(AND(D3>200,D3<=300),B3*0.15,IF(D3>300,B3*0.2,"")))