Multiple Level "and" fucntion help!

[MarvInBoise]

=IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L311/1.5=L312)

What I'm attempting to do…
If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2
and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then)
divide the payrate L2(OTP) by 1.5.

 

[Spiky]

=IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L311/1.5=L312)

What I'm attempting to do…
If the EmplID is the same on A2 and A3 and the and Pay dates are equal onI2
and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then)
divide the payrate L2(OTP) by 1.5.

Couple changes, and I threw in an instruction if False:

=IF(AND(A311=A312,I311=I312,J311="OTP",J312="REG"),L311/1.5,"")

 

[Bob Umlas]

=IF(AND(A311=A312,I311=I312,J311="OTP",J312="REG"),L311/1.5,L311)

 

[T. Valko]

Try this:

=AND(A2=A3,I2=I3,J2="OPT",J3="REG")*L2/1.5

 

[Duke Carey]

maybe

IF(AND(A311=A312,I311=I312,J311="OTP",J312="REG"),L311/1.5,result if false)

 

[Sheeloo]

Put this in L312
=IF(AND(A311=A312,I311=I312),IF(AND(J311="OTP",J312="REG"),L311/1.5,""),"")