OR function Not Working with Multiple Logical Expressions



I have the following formula:

=IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete")

which always returns "not complete", i.e. true.

However, modifying the expression so that only 1 logical expression is present, the expression works correctly, showing the true and false outcomes as expected. My question is, how do I modify this formula to work correctly and evaluate both logical expressions simultaneously.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!