Hi, I'd like to set up data validation with three criteria checks.

The scenario is -
If A1 = "W" And B1 > C1 Then "Pass" Else "Fail"
If A1 = "L" And B1 < C1 Then "Pass" Else "Fail"
If A1 = "D" And B1 = C1 Then "Pass" Else "Fail"
This is what I have so far which does not work in the data validation feature but does if I enter it in a cell and change the values in the sheet so I'm fairly sure the logic is right -

Formula: copy to clipboard
=IF(C3="W",IF(E3>F3,"Pass","Fail"),IF(C3="L",IF(E3<F3,"Pass","Fail"),IF(C3="D",IF(E3=F3,"Pass","Fail"),"Unhandled Result")))