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 v...
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
HansVogelaar works like a gem!! thank you so much
