Excel formula

Occasional Contributor
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 Replies

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

Screenshot 2021-06-12 at 06.54.52.png

Entered the formula in Y1 and copied it down.


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