excel表格如果包含ABCD等数字则显示X，不包含则显示Y
答案:2 悬赏:40 手机版
解决时间 2021-11-12 23:35
- 提问者网友：蓝琪梦莎
- 2021-11-12 09:11
excel表格如果包含ABCD等数字则显示X，不包含则显示Y
最佳答案
- 五星知识达人网友：冷風如刀
- 2021-11-12 10:08
假设在A列，从A1开始
包含其中1个
B1=IF(OR(ISNUMBER(FIND({"A","B","C","D"},A1))),"X","Y")
同时是同时包含ABCD
B1=IF(AND(ISNUMBER(FIND({"A","B","C","D"},A1))),"X","Y")
包含其中1个
B1=IF(OR(ISNUMBER(FIND({"A","B","C","D"},A1))),"X","Y")
同时是同时包含ABCD
B1=IF(AND(ISNUMBER(FIND({"A","B","C","D"},A1))),"X","Y")
全部回答
- 1楼网友：舊物识亽
- 2021-11-12 11:43
是单元格包含ABCD则显示X 否则Y
假设在A1
=IF(LEN(A1)>LEN(SUBSTITUTE(A1,"ABCD","")),"X","Y")
假设在A1
=IF(LEN(A1)>LEN(SUBSTITUTE(A1,"ABCD","")),"X","Y")
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯