Excel formula review

Occasional Contributor
I was wondering if someone could help me figure out what these 2 formulas are trying to say.


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

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

@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
 )