In a monthly report I have a requirement to track a certain type of day (
AE10 ) that is dependant upon two other day group conditions ( L10:P10, and
AB10 ). The answer cell ( AE10 ) should indicate either a 0 or 1.

L10:P10 ( ie. =SUM 3.8 hrs )
AB10 ( Control Check box, Linked to AI10 )
AH10 ( =IFAI10.1.0 )
AE10 ( Should be 0 or 1, depending upon L10:P10, and AB10 )

If L10:P10 has accumulated hours, and AB10 is Contrtol Box Checked (1),
then AE10 =1.
If L10:p10 has no accumulated hours, and AB10 is Control Box Checked (1),
then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is not Control Box Checked
(0), then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is Not Control Box Checked
(0), then AE10=0.

Help is appreciated! Thanks