Excel 某个单元格如果不包含哪个字，返回一个值

Question

如题所述

Answer 1

见截图

比如A列不包含数字3，就返回“少3”

B1输入

=IF(ISNUMBER(FIND(3,A1)),"","少3")

下拉

Answer 2

你好,
=CHOOSE(COUNT(FIND("项目",A1))+1,"否","是")