Formula Not Working

[rob51852]

Hello

I have put together a formula but cannot get it to work. Can anyone see where I have gone wrong? I’ve looked at it for so long I can’t see the wood for the trees!

=IF(AND(A5=Sheet2!$B$2,$Y$5=0,$Y$6=0,$AA$5=0,$AA$6=0,$AE$5="First",$Z$5=0,$Z$6="1"),"PLAY",IF(AND(A5=Sheet2!$B$2,$Y$5=0,$Y$6=0,$AA$5=0,$AA$6=0,$AE$6="First",$Z$5=0,$Z$6=2),"PLAY"))

Thanks

 

[sadboy309]

I don't understand data of Cells. But, I see your formula lacks the False clause of the final IF function.

=IF(AND(A5=Sheet2!$B$2,$Y$5=0,$Y$6=0,$AA$5=0,$AA$6=0,$AE$5="First",$Z$5=0,$Z$6="1"),"PLAY",IF(AND(A5=Sheet2!$B$2,$Y$5=0,$Y$6=0,$AA$5=0,$AA$6=0,$AE$6="First",$Z$5=0,$Z$6=2),"PLAY","NOT PLAY"))

 

[Fluff]

How about
=IF(AND(A5=Sheet2!$B$2,$Y$5=0,$Y$6=0,$AA$5=0,$AA$6=0,$AE$5="First",$Z$5=0,OR($Z$6=1,$Z$6=2)),"PLAY","???")

 

[rob51852]

You've fixed! Thanks, really appreciate it

 

[Fluff]

Glad we could help & thanks for the feedback