AND() OR() formulas in Excel work a little different to other languages you may have come across.
You have to specify all the conditions that need to be true for the AND() OR() formula.
So AND(L3=1,S3=1) simply means if L3=1 AND S3=1, same format applies to OR conditions OR(L3=1,S3=1) would mean if L3=1 OR S3=1
Bookmarks