Excel formula review

Mel4342 

The first one can be presented like this:

=IF(
    AND(
        I3=1,O3=1,
        OR(
           L3=1,S3=1,Y3=1
        )
    ),
    1,0
 )

It returns 1 of both values in I3 and O3 contain 1 AND either of L3 or S3 or Y3 contains 1. Otherwise the formula returns zero.

And the second one is actually very similar as you will see below.

=IF(
    AND(
        AA3=1,I3=1,
        OR(
          S3=1,Y3=1
        )
    ),
    1,0
 )