Formula Question

[levanoj]

I have 3 columns (A:C) where each cell will have either a "Yes" or "No" value in it. What I'm looking for is a formula I can enter in column D that will compare each cell of the 3 columns and within the same row and if all three values are "No" then the result will say "Spare" but if any cell has a "Yes" value then the result would say "In Use". I tried using the following formula but the result always came out as "In Use":

=IF(A2=B2=C2,"Spare","In Use")

Can anyone assist or tell me what I'm doing wrong?

 

[Joe4]

=IF(AND(A2="No",B2="No",C2="No"),"Spare","In Use")

 

[levanoj]

Awesome, thanks Joe4.

 

[njimack]

=IF(COUNTIF(A2:C2,"Yes"),"In Use","Spare")