SOLVED

# Data validation with mutiple criteria

Copper Contributor

# 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!

4 Replies

# Re: Data validation with mutiple criteria

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.

# Re: Data validation with mutiple criteria

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
best response confirmed by joanauhc (Copper Contributor)
Solution

# Re: Data validation with mutiple criteria

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

# Re: Data validation with mutiple criteria

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

1 best response

Accepted Solutions
best response confirmed by joanauhc (Copper Contributor)
Solution