AND OR Nested Formula

[spycein]

Hi Everyone,

I have the following table

[TABLE="class: grid, width: 192"]
<tbody>[TR]
[TD="width: 64"]A1[/TD]
[TD="width: 64"]B1[/TD]
[TD="width: 64"]C1[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]White[/TD]
[TD]Yellow[/TD]
[/TR]
</tbody>[/TABLE]

i need a formula using "AND OR" in D1 which would return me the value as "Pass" or "Fail" according to the following condition.

If I select "Black" in cell "A1", "white" in cell "B1" and "Yellow" in Cell "C1" then Cell "D1" would return the value as pass.
If I select "Black" in cell "A1", "white" in cell "B1" and "Green" in Cell "C1" then Cell "D1" would return the value as pass.
If I select "Black" in cell "A1", "white" in cell "B1" and "Blue" in Cell "C1" then Cell "D1" would return the value as pass.

If I select "Black" in cell "A1", "white" in cell "B1" and if i select any other colour name except Yellow/Green/Blue in Cell "C1" then Cell "D1" would return the value as fail.

If I select any other colour name except "black" in cell "A1", any other colour name except "white" in cell "B1" and if i select "Blue" or "Yellow" or "Green" in "C1" then Cell "D1" would return the value as fail.

Hope i made my points clear.

Thanks

 

[pike]

Think I follow the logic
try...=IF(AND(A1="Black",B1="White",OR(C1="Yellow",C1="Green",C1="Blue")),"Pass","Fail")