Forum Discussion
Data validation with mutiple criteria
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!
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.
- 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
