Data validation does not work

Hello,

I have used the below formula for each cell to Data Validation. Although the formula itself does behave as expected, Data Validation does not. Please see row 4 in the attached spreadsheet.

Could anyone please tell me what I am doing wrong or if perhaps this is an excel bug?

DataValidation_problem_screenshot.PNG
Thanks in advance,
Michelle

It is returning false because of the last if statement.
The validation only works if column D is less than column c

Hi
You can not check the "ignore blank cells" because B5 and B6 are involved in the decision.
Else, instead of using
=IF(B3="x";IF(D3>C3,TRUE,FALSE);IF(D3<C3,TRUE, ALSE))

use
= IF(B3="x",D3>C3,D3<C3)
Regards

Thanks very much Tony and Jose. I was sure I found a but in excel

And thanks Jose, that formula is beautifully simple