whats wron with this

[klatlap]

I have used these formulas in the past with no problem but i don't know why this won't work

=IF(AND(AD5="x",$AL$4=TRUE,"LAY"),"")

all i get is #VALUE

 

[mikerickson]

I have used these formulas in the past with no problem but i don't know why this won't work

=IF(AND(AD5="x",$AL$4=TRUE,"LAY"),"")

all i get is #VALUE

The third argument of AND is "LAY", which is Text, not Logical.

 

[jindon]

try
=IF(AND(AD5="x",$AL$4=TRUE),"LAY","")

 

[klatlap]

Thankyou again