Under the MATCH column header enter a formula that outputs t

Under the MATCH column header, enter a formula that outputs the value 1 if all four cells to its left (in the PICK1, PICK2, PICK3, and PICK4 columns) contain 1, and outputs the value 0 if any of them contain 0.

Solution

#Excel formula

1) this formula wil give 1 if all four cells to its left (in the PICK1, PICK2, PICK3, and PICK4 columns) contain 1.

1) this formula wil give 0 if any of them contain 0.

I am using IF with AND Operator

=IF(AND(A2=1,B2=1,C2=1,D2=1),1,0)