Forum Discussion

joanauhc's avatar
joanauhc
Copper Contributor
Jul 23, 2024
Solved

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...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 23, 2024

    joanauhc 

    How about:

     

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

HansVogelaar's avatar
HansVogelaar
MVP
Jul 23, 2024

joanauhc 

How about:

 

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

joanauhc's avatar
joanauhc
Copper Contributor
Jul 24, 2024

HansVogelaar works like a gem!! thank you so much

Resources