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