Excel嵌套如果

Question

我需要根据3个不同列中的数据创建一个IF公式，并在满足某些条件时给出是或否的结果：

If D2 = "Achieved" and  E2 = "NO"    then J2 = "YES"
If E2 = "Expires"  and  I2 > TODAY() then J2 = "YES"
If E2 = "Expires"  and  I2 < TODAY() then J2 = "NO"
If I2 = "Never Achieved"             then J2 = "NO"

我已经尝试了IFS和和和各种组合，此时我要圆圈。任何帮助！

Answer 1

您可以使用或嵌套，如果：

=IF(OR(AND(D2 = "Achieved", E2 = "NO"),AND(E2 = "Expires", I2 > TODAY())),"YES",IF(OR(I2 = "Never Achieved",AND(E2 = "Expires",  I2 < TODAY())),"NO","NO COMBO FOUND"))