I need some help with a Data Validation formula that is not working.
My Setting for the validation criteria in D1:D10 are:
Allow: Custom
Ignore blank: Unchecked
Formula: =AND($A1=1),OR(AND($B1<>"",$D1<=0),AND($C1<>"",$D1>=0)))
My formula needs to check:
(1) If A1 equals 1
(2) Then check B1, if it’s NOT blank
(3) Only allow a negative (or zero) number in D1
(4) If B1 is blank; check C1, if it’s NOT blank
(5) Only allow a positive (or zero) number in D1
Currently, my formula is returning an error that the value in D1 does not match restrictions for the cell. Example: A1=1, C1=25, entering a 0 or any positive number in D1 returns a validation error.
I’m sure I’m missing the obvious and I would appreciate help getting my formula to work.
Thank you
Bookmarks