[已解决]请教一个多条件计算问题？

砂海 · 发表于 2013-12-23 13:13

=IF(A7="",0,B7*LOOKUP(A7,{"平安","人保","天安"},{0.16,0.12,0.2})+C7*LOOKUP(A7,{"平安","人保","天安"},{0.06,0.05,0.03}))

砂海 · 发表于 2013-12-23 13:24

=SUM((A7={"平安","人保","天安"})*(B7*{0.16,0.12,0.2}+C7*{0.06,0.05,0.03}))
Ctrl+Shift+Enter,三键数组公式

1091126096 · 发表于 2013-12-23 16:09

本帖最后由 1091126096 于 2013-12-23 16:10 编辑

复制代码

		自动登录	找回密码
密码			注册

这个字符更少，但更难理解。