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

戊辰丁巳

如果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

交通银行杨经理

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

秋水伊伊

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

无夏之年

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

骏泷

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

徐大侠

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

红色骄傲

=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}))

坚强人生

这思路
绝了 我好笨

火烧的旺

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

周大黑

太棒了，每日学习一个小技能