Forum Discussion

Copper Contributor

Jun 12, 2021

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

excel

Formulas and Functions

2 Replies

PeterBartholomew1
Silver Contributor
Jun 12, 2021
Mel4342
I use Excel 365 so, naturally, wanted the result as a spilt array in preference to copying formulas.
Riny_van_Eekelen
Platinum Contributor
Jun 12, 2021
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.