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.