|Seems to work for me.|
Let me ask you 2 questions:
1 - With regards to the X2, X3, X4, which sheet are the formulae supposed to be looking at?
As written, the formulae are looking at the same sheet as where the formulae are, not at Del. Maybe that's why it didn't work for you.
2 - This has nothing to do with your question, but I'm just curious as to why you used the formula construction you did. I would have written the formula as follows:
While the results should be the same, you appear to the using the AND function just to produce a 1, not to actually compare any arguments.