We need Two Cells to Trigger a final cell location

MATRIX Architect

We need 

When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check.

I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0)

...but this is not working for me. Any help with this would be greatly appreciated!

Mike Wilday

I think you got your < symbol backwards. You want to check if its GREATER THAN > 0 

=IF(AND([Med4 Quiz]3 > 0, [Med4 E Learning]3 > 0), 1, 0)