If statement

[hymenlabitowitz]

Hello all. My questions this, how do I write a statement to return a single outcome in one cell drawing from multiple other cells looking for multiple answers that would rate that one outcome?
Exp.
=if(a1 or a3 or a4="rob" or "paul" or "Mary",1,0)

I know this is atroshious looking but you get the gist.

 

[tc88]

Hello all. My questions this, how do I write a statement to return a single outcome in one cell drawing from multiple other cells looking for multiple answers that would rate that one outcome?
Exp.
=if(a1 or a3 or a4="rob" or "paul" or "Mary",1,0)

I know this is atroshious looking but you get the gist.

=IF(OR(A1="Rob",A1="Paul",A1="Mary",A3="Rob",A3="Paul",A3="Mary",A4="Rob",A4="Paul",A4="Mary"),1,0)

 

[cgclower]

Try this:

=IF(OR(A1={"rob","paul","Mary"},A2={"rob","paul","Mary"},A3={"rob","paul","Mary"}),1,0)

probably a way to make it a bit shorter, but not sure how. This works for me though.

 

[Jonmo1]

Welcome to the board...

There's probably better ways, but this should do

=--OR(A1={"rob","paul","mary"},A3={"rob","paul","mary"},A4={"rob","paul","mary"})

 

[Jonmo1]

And there are better ways...

If you actually meant A1 A2 A3 and A4 (you skipped A2 in your post)
Then try
=--(SUM(COUNTIF(A1:A4,{"rob";"paul";"mary"}))>0)