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!
Thanks
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!
Code:
=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
Last edited: