IF公式多条件嵌套

Dragonfly7995 · 发表于 2023-8-4 09:54

我想用if 多条件嵌套，把D列四位数字以后的类型给找出来放在H列，类型有爆品、秒杀、拼团、预售等，请指导！

hugeinfo · 发表于 2023-8-4 09:58

丢丢表格 · 发表于 2023-8-4 10:01

H2

=LOOKUP(,-FIND({"","爆品","秒杀","拼团","预售"},D2),{"","爆品","秒杀","拼团","预售"})

无聊的黑猫 · 发表于 2023-8-4 10:01

=MID(D2,IFERROR(FIND("[",D2)+1,5),IFERROR(FIND("]",D2)-FIND("[",D2)-1,FIND(" ",D2)-4))

yysiss · 发表于 2023-8-4 10:01

=INDEX({"秒杀","爆品","拼团","预售"},,MATCH(1,FIND({"秒杀","爆品","拼团","预售"},D2)^0,))

正冬 · 发表于 2023-8-4 10:02

为什么一定要用if多层嵌套呢=LOOKUP(1,0/FIND({"爆品","秒杀","拼团","预售"},D2),{"爆品","秒杀","拼团","预售"})

mtvcs · 发表于 2023-8-4 10:04

=MID(D2,5,IFERROR(FIND(" ",D2),FIND("】",D2))-4) 试试这样行不行

象山海鲜 · 发表于 2023-8-4 10:05

复制代码

wofuocibei2008 · 发表于 2023-8-4 10:43

MID(D2,SUM(IFERROR(FIND({"爆品","秒杀","拼团","均价","预售","跨界","周末"},D2),0)),2)数组

丢丢表格 · 发表于 2023-8-4 10:52

wofuocibei2008 发表于 2023-8-4 10:43
MID(D2,SUM(IFERROR(FIND({"爆品","秒杀","拼团","均价","预售","跨界","周末"},D2),0)),2)数组

连均价，周末都要的话，那可以写成：

=MID(D2,4+MATCH(1=1,MID(D2,{5,6},1)>"吖",),2)

（我认为均价，周末是剔除的。）

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

[已解决] IF公式多条件嵌套