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,

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]Open[/TD]
[/TR]
</tbody>[/TABLE]

 

[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..