formula utilizinf Or and AND function?

[bh24524]

Hi, I'm looking for a formula that might utilize both AND and OR functions but I'm not completely sure how or where. Here is what I am looking to do:

the formula is in Cell A3. If A1 reads "Test 1" and if any of C2, D2, or E2 read "true", then result is "positive". If not, result is "negative"
so if A1 does not equal "test 1", it doesn't matter if C2, D2 or E2 = "true", it would be "negative.
If A1 DOES equal "test 1" but C2 D2 or E2 do not have "True", it would be "negative"

I've tried toying around with this but I can't seem to get it. Please help. Thanks!

 

[6StringJazzer]

=IF(AND(A1="Test 1",OR(C2, D2, E2)),"Positive","Negative")

Please try this and tell me if it gives your expected result. This assumes that the values in C2, D2, and E2 are actually boolean values (TRUE or FALSE). If they are text then you need this instead:

=IF(AND(A1="Test 1",OR(C2="true", D2="true", E2="true")),"Positive","Negative")

 

[vw412]

You don't need OR and AND functions to solve this. Here is the formula I came up with for thr criteria specified:

=IF(A1="Test 1",IF(C2,"Positive",IF(D2,"Positive",IF(E2,"Positive","Negative"))),"Negative")

 

[bh24524]

Thank you guys, both solutions work.