Question

excel表格中,A1设置序列为1、2,如何实现当A1选择为1时,B1返回公式： =(C1-D1)

excel表格中,A1设置序列为1、2,如何实现当A1选择为1时,B1返回公式： =(C1-D1)x80%;A1选择2时,B1返回公式: =IF((C1-D1)<100,(C1-D1)x70%,IF(C1-D1)>100,(C1-D1)x90%))

Answer 1

b1输入
=if(a1=1,(c1-d1)*0.8,if(a1=2,if((c1-d1)<=100,(c1-d1)*0.7,(c1-d1)*0.9),""))
条件中缺少如果a1=2时，c1-d1=100的情况

Answer 2

B1的公式
=IF(A1=1,(C1-D1)*80%,IF(A1=2,IF((C1-D1)<100,(C1-D1)*70%,(C1-D1)*90%),""))

Answer 3

=if(D1="","",Choose(D1,(C1-D1)x80%,IF((C1-D1)<100,(C1-D1)x70%,IF(C1-D1)>100,(C1-D1)x90%)))

Answer 4

=IF(A1=1,(C1-D1)x80%,IF(A1=2,IF((C1-D1)<100,(C1-D1)x70%,IF(C1-D1)>100,(C1-D1)x90%)),""))