Data validation with mutiple criteria

[joanauhc]

Hi everyone! I need help regarding this formula

=OR(AND(D19="Risk",P19>0.1,ISNUMBER(P19)),AND(D19="Chance",P19<-0.1,ISNUMBER(P19),AND(P19<=Q19)))

I would need the cell to go through to data validation check; 

1) If D19 = Risk, the value entered must be positive in P19

2) The value entered in P19 must be <= to Q19 else the same error message would pop up 

How do i ensure that it goes through these 2 criteria? 

Thank you!

[#2]

@joanauhc 

Going just by the description, it would be

=AND(OR(D19<>"Risk", P19>0), P19<=Q19)

but that is probably not what you want. The formula that you posted appears to check more than your description.

[#3]

Thank you! Yes, i need an additional criteria which is if the selected cell = Risk, column P has to be positive number, if selected cell = Chance, column P will be a negative number. After this, it will then check that P19<=Q19

[#4 · Accepted solution]

@joanauhc 

How about:

=AND(OR(AND(D19="Risk", P19>0), AND(D19="Chance", P19<0)), P19<Q19)

[#5]

@HansVogelaar works like a gem!! thank you so much