戊辰丁巳 发表于 2021-12-17 13:53:00

判断文本，符合条件，计算

如果A1单元格是火车，计算C1=B1/1.09*0.09
如果A1单元格是飞机，计算C1=B1/1.09*0.09
如果A1单元格是高速，计算C1=B1/1.03*0.03
如果A1单元格是客车，计算C1=B1/1.03*0.03
如果A1单元格是滴滴快车，计算C1=B1/1.03*0.03

交通银行杨经理 发表于 2022-1-13 03:22:06

C1=IF(OR(A1={"火车","飞机"}),B1/1.09-0.09,IF(OR(A1={"高速","客车","滴滴快车"}),B1/1.03*0.03,)

秋水伊伊 发表于 2022-1-26 13:17:16

=LOOKUP(1,-FIND(A1,{"火车飞机","高速客车滴滴快车"}),B1/{109,103}*{9,3})

无夏之年 发表于 2022-2-8 05:38:16

=IF(OR(A1={"火车","飞机"}),B1/1.09*0.09,IF(OR(A1={"高速","客车","滴滴快车"}),B1/1.03*0.03,))

骏泷 发表于 2022-2-8 11:37:43

=B1*(0.03+0.06*OR(LEFT(A1)={"高";"客";"滴"}))/(1.03+0.06*OR(LEFT(A1)={"高";"客";"滴"}))

徐大侠 发表于 2022-2-18 12:02:11

=IF(OR(A1={"火车","飞机"}),B1/1.09*0.09,B1/1.03*0.03)

红色骄傲 发表于 2022-2-28 01:39:01

=B13/LOOKUP(1,0/(A13={"火车","飞机","高速","客车","滴滴"}),{1.09,1.09,1.03,1.03,1.03})*SUM((A13={"火车","飞机","高速","客车","滴滴"})*({0.09,0.09,0.03,0.03,0.03}))

坚强人生 发表于 2022-3-8 21:51:55

这思路
绝了 我好笨

火烧的旺 发表于 2022-3-10 20:03:34

再简单一下
=B1/IF(OR(A1={"火车";"飞机"}),981,309)%%

周大黑 发表于 2022-3-23 08:22:14

太棒了，每日学习一个小技能
页: [1]
查看完整版本: 判断文本，符合条件，计算