Hi Everyone,
I have the following table
<tbody>
A1
B1
C1
Black
White
Yellow
</tbody>
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...