excel formula to count as 1 if all 3 cells equal no

[squeakums]

I need assistance with a formula to place a "1" in a sell or yes if 3 other cells = no. Cells K2, L2, and M2,

 

[Scott Huish]

=IF(COUNTIF(K2:M2,"no")=3,"Yes",1)

or if you mean if all 3 cells equals no then 1 else 0.

=(COUNTIF(K2:M2,"no")=3)+0