Determinne Whether ANY Field Contains a Specific Value

[JeffreyCampos]

I've searched high and low and am simply not getting an eloquent solution to this problem, though it seems like it should be common need.

 

I have four unique fields which may contain "Yes", "No" or empty in any combination of the three states. I need a calculation that finds whether ANY one of the fields contain "Yes".

 

Thooughts?

[Fitch]

Position( (fieldA&fieldB&fieldC&fieldD) ;"Yes"; 1; 1 )

[JeffreyCampos]

Thanks!