请问B9中是项目A,B,C，D9是一种表示；是项目D,E,F，D9则是另一表示，函数该怎么写？

拿个破仑子

各位老师，请问我需要设置B9单元格中如果是项目A,B,C，D9中的费用2为费用1/3；如果是项目D,E,F，D9中的费用2为费用1/2，这个函数该怎么写？我使用了LOOKUP函数，=LOOKUP(B9,{"A","B","C","D","E","F"},{"c9/3","c9/3","c9/3","c9/2","c9/2","c9/2"})        ，但D9中不显示数值

无聊的黑猫

=C9/(3-ISNUMBER(FIND(B9,"DEF")))

w4275

1. =C9/((MATCH(B9,B2:G2,)<4)+2)

复制代码

mtvcs

=C9/LOOKUP(B9,{"A","B","C","D","E","F"},{3,3,3,2,2,2})

拿个破仑子

无聊的黑猫 发表于 2023-8-3 09:48
=C9/(3-ISNUMBER(FIND(B9,"DEF")))

请问B9中再增加一个项目G，这个公式可以吗？

橒♂蝣

=LOOKUP(B9,{"A","B","C","D","E","F"},CHOOSE({1,2,3,4,5,6},C9/3,C9/3,C9/3,C9/2,C9/2,C9/2))