EXCEL用公式如何实现：如果是“姓名1”或“姓名2”或“姓名3”“，结果是一部，否则是二部。求高手解答。

Question

如题所述

Answer 1

设姓名在a列，在b2输入：
=if(or(a2="姓名1",a2="姓名2",a2="姓名3"),"一部","二部")

Answer 2

比如要判断的姓名在A1，公式：
=if(or(a1={"姓名1","姓名2","姓名3"}),"一部","二部")

Answer 3

假设姓名在A1
B1输入公式
=IF(OR(A1={"姓名1","姓名2","姓名3"}),"一部","二部")

Answer 4

b1输入
=if(or(a1={"姓名1","姓名2","姓名3"}),"一部","二部")
下拉填充公式
公式是假设从A1开始向下输入的姓名本回答被提问者采纳

Answer 5

=IF(OR(A1="张三",A1="李四",A1="王五"),"一部","二部")