Large if/then statement

[squeakums]

I need your help with this large if/then statement or to see if it is possible:

If column E2 = "Draft" and column G2 = "Accept Risk" then Yes OR
If column E2 = "Draft" and column I2 = between the date range listed in column T1 (for example it would show date range 4/1/24 - 6/30/24 then yes OR
If column E2 = "Draft" and column G2 = "Risk Tolerance Review" then Yes OR
If column E2 = "Closed" and J2 = between the date range listed in column U2 (for example it would show date range 4/1/24 - 6/30/24 and column I has a date less than what's in column U2 then Yes OR
If column E2 = "Closed" and J2 = < is blank> AND I2 < V2 then Yes OR
If column E2 = "Deficiency in Progress" OR e2="Pending Validation" and J2 = <is blank> AND I2 = "Past Due" then YES
Otherwise if none of these are meet, then No

 

[felixstraube]

If you need OR(a, b, c) you can write a + b + c
Uf you need AND(a, b, c) you can write a*b*c

If you need for example AND(a, OR(b, c, d)) you can write a*(b + c + d).

A value iqual to 0 is the same as FALSE, anthing different from 0 is TRUE, even negative values.

Hope this helps

 

[Alex Blakenburg]

See if this helps at all.

=IF(AND(D2="Draft",
        OR(
           F2="Accept Risk",
           AND(H2>=$T$1,H2<=$T$2))),
    "Yes",
    IF(AND(D2="Closed",
           OR(
              F2="Risk Tolerance Review",
              AND(I2>=$T$1,I2<=$T$2,H2>=$U$1,H2<=$U$2),
              AND(H2>=$T$1,H2<=$T$2,OR(I2="",I2>$T$2)))),
       "Yes",
       IF(AND(
              OR(D2="Deficiency in Progress",D2="Pending Validation"),
              AND(I2="",H2="Past Due")),
          "Yes",
          "No")))

 

[squeakums]

For the OR code - is it using a multiple symbol? Confused what its doing there

=IF(AND(D2="Draft", OR( F2="Accept Risk", AND(H2>=$T$1,H2<=$T$2))), "Yes", IF(AND(D2="Closed", OR( F2="Risk Tolerance Review", AND(I2>=$T$1,I2<=$T$2,H2>=$U$1,H2<=$U$2), AND(H2>=$T$1,H2<=$T$2,OR(I2="",I2>$T$2)))), "Yes", IF(AND( OR(D2="Deficiency in Progress",D2="Pending Validation"), AND(I2="",H2="Past Due")), "Yes", "No")))

Yes, thank you this works!

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.