Forum Discussion

Teden2020

Copper Contributor

Feb 10, 2020

Solved

Help with IF this but IF that...

My columns are as below. I want it to give me a YES in column 3 if the first column is "I" and the second column is >4 and <7. Success with =IF(AND(C2="I",D2>4,D2<7),"YES","NO"). BUT some of the ...

excel

SergeiBaklan

Feb 10, 2020

Teden2020

As variant

=IF(OR(
     AND(C2="I",D2>4,D2<7),
     AND(C2="A",D2>7,D2<10)
   ),"YES","NO")

SergeiBaklan

Diamond Contributor

Feb 10, 2020

Teden2020

As variant

=IF(OR(
     AND(C2="I",D2>4,D2<7),
     AND(C2="A",D2>7,D2<10)
   ),"YES","NO")

Teden2020

Copper Contributor

Feb 10, 2020

SergeiBaklan Wow that was quick. Spot on thanks!