EXCEL多个假设条件如何设置

Question

用于倒宝塔的绩效计算，条件描述：若D1大于A1*1.1，则E1=C1*50%,若D1在A1与A1*1.1之间，则E1=C1*80%；若D1=A1，则E1=C1；若D1小于A1，且大于（A1-B1)/3时，则（A1-D1)/（A1-B1)*C1/(A1-B1)*0.9

Answer 1

在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 中输入数字，就可以看到结果。

Answer 2

E1中的公式如下：
=IF(D1>A1*1.1,C1*0.5,IF(AND(D1>A1,D1<A1*1.1),C1*0.8,IF(D1=A1,C1,IF(AND(D1<A1,D1>((B1-A1)/3)),(A1-D1)/(A1-B1)*C1/(A1-B1)*0.9))))

Answer 3

在E1输入公式=IF(D1>A1*1.1,C1*0.5,IF(AND(D1>A1,D1<A1*1.1),C1*0.8,IF(D1=A1,C1,IF(AND(D1<A1,D1>(A1-B1)/3),(A1-D1)/(A1-B1)*C1/(A1-B1)*0.9,""))))本回答被提问者和网友采纳

Answer 4

=IF(D1>A1*1.1,C1*0.5,IF(AND(D1>A1,D1<A1*1.1),C1*0.8,IF(D1=A1,C1,IF(AND(D1<A1,D1>((B1-A1)/3)),(A1-D1)/(A1-B1)*C1/(A1-B1)*0.9))))

Answer 5

if(d1>(a1*1.1),c1*.5,if（d1=a1,c1,if(d1>a1,c1*.8,if(d1