[已解决]请教大家一个满足两个以上条件的计算问题？

hnnylf

我的问题是：当B2中有数据，同时D2中也有数据时，I2才计算结果，否则为“0”。谢谢！

最佳答案

月排行榜 / 总排行榜

yyyydddd8888

2014-1-1 10:23

i2中输入公式：

1. =IF(D2,1,0)*F2*CHOOSE(MATCH(B2,{"","人保","平安","人寿"},),0,0.05,0.08,0.07)

复制代码

1. =IF(OR(B2="",D2=0),0,IF(B2="人保",F2*0.05,IF(B2="平安",F2*0.08,IF(B2="人寿",F2*0.07,))))

复制代码

跳转到最佳答案楼层

1091126096

=IF(AND(B2<>"",D2=0),0,IF(B2="",0,IF(B2="人保",F2*0.05,IF(B2="平安",F2*0.08,IF(B2="人寿",F2*0.07,)))))

yyyydddd8888

i2中输入公式：

1. =IF(D2,1,0)*F2*CHOOSE(MATCH(B2,{"","人保","平安","人寿"},),0,0.05,0.08,0.07)

复制代码

1. =IF(OR(B2="",D2=0),0,IF(B2="人保",F2*0.05,IF(B2="平安",F2*0.08,IF(B2="人寿",F2*0.07,))))

复制代码

yewei113

围观

as0810114

数组公式

1. =(D2<>0)*F2*SUM((B2={"人保","平安","人寿"})*{0.05,0.08,0.07})

复制代码

yewei113

yyyydddd8888 发表于 2014-1-1 10:23
i2中输入公式：

学习了

tgydslr

1. =(D2<>0)*CHOOSE(MATCH(B2,{"","人保","平安","人寿"},),,5,8,7)*F2/100

复制代码

Frank100344

学校了

hnnylf

感谢大家指导，问题解决的很好！多种思路。谢谢！

likui700304

多种思路。谢谢！