Excel formula

[Mel4342]

Hi ,
Would anyone have a formula suggestion to write the following scenarios:
If W1="1" , or X1="1" or both W1 and X1 =1 , then yes . If they do not the field equals No

[#2]

@Mel4342 See picture below. No need to test for W1 and X1 both being equal to 1. Either one will do to return "Yes".

Entered the formula in Y1 and copied it down.

[#3]

@Mel4342 

I use Excel 365 so, naturally, wanted the result as a spilt array in preference to copying formulas.