Data Validation based on other fields

[preeves]

I have a request worksheet that needs to validate whether the row contains both street address (B2:D2) and PO Box (E2). If so, it needs to stop the person as they are populating the rest of the fields. I have tested is out with a formula in another cell is always seems to work. However, when I put the validation on the PO Box (Data Validation; Custom) it is inconsistent.

Street1, Street2, Street3, PO Box

=OR(AND(B2="",C2="",D2=""),E2="")

False (Stop) = combination of Street1, 2, 3 and PO Box
True = combination of Street1, 2, 3 or PO Box

Any help is appreciated.

 

[tyija1995]

Have you un-checked the "Ignore blank" checkbox just to the right of Custom?
The formula looks correct so this may be the issue.

 

[preeves]

It is the little things that trip me up. Thanks!