Data validation with 3 value criterias
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!
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 P192) 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! Read More
