Jun 28 2021 07:28 PM
Jun 28 2021 11:36 PM
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
)