Forum Discussion
Excel formula
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
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.