Change Status of a cell depends of Values of Other cells

[Mathew123]

I want to change value of one cell (Cell D) depends on the value of others (A to C).

Example:

If any cell in A to C is "NO" then D should "Open". If all cells in A to C is "YES", then D should change to "Closed". Please anyone can help?

Thank you,

A	B	C	D
YES	YES	YES	Closed
NO	YES	YES	Open
NO	NO	NO	Open

<tbody>
</tbody>

 

[JazzSP8]

Does this work for you?

=IF(COUNTIF(A1:C1,"YES")=3,"Closed",IF(COUNTIF(A1:C1,"NO")>=1,"Open",""))

 

[Mathew123]

Bravo Bro..it works...thanks a looott..