3个条件判断？

gt5626 · 发表于 2024-5-5 15:43

本帖最后由 gt5626 于 2024-5-5 16:39 编辑

如果L2包含“B"字符，显示为”封锁“
如果L2不包含“B"字符，显示为”未封“
例如29行，如果此行为空(无数据)，显示为”“

hxj119 · 发表于 2024-5-5 15:53

本帖最后由 hxj119 于 2024-5-5 15:55 编辑

=IF(AND(A2:L2=""),"",IF(LEFT(L2)="B","封锁","未封"))

miaojohn45 · 发表于 2024-5-5 15:57

=IF(TRIM(L2)="","未封","封锁")

gt5626 · 发表于 2024-5-5 16:07

hxj119 发表于 2024-5-5 15:53
=IF(AND(A2:L2=""),"",IF(LEFT(L2)="B","封锁","未封"))

=IF(AND(A2:L2=""),"",IF(LEFT(L2)="B","封锁","未封"))
显示为：#VALUE!

gt5626 · 发表于 2024-5-5 16:08

miaojohn45 发表于 2024-5-5 15:57
=IF(TRIM(L2)="","未封","封锁")

空行会显示为“未封”

hxj119 · 发表于 2024-5-5 16:15

gt5626 发表于 2024-5-5 16:07
=IF(AND(A2:L2=""),"",IF(LEFT(L2)="B","封锁","未封"))
显示为：#VALUE!

试试三键结束

gt5626 · 发表于 2024-5-5 16:18

hxj119 发表于 2024-5-5 16:15
试试三键结束

可以了，谢谢

leepoison · 发表于 2024-5-5 16:21

=IF(PRODUCT(1*(A2:L2=""))=1,"",IF(LEFT(L2)="B","LOCK","UNLOCK"))

痛痛痛痛 · 发表于 2024-5-5 16:47

=IFS(LEFT(L2)="B","封锁",AND(A2:L2=""),"",1,"未封")

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

[已解决] 3个条件判断？