Nesting OR into AND?
I'm wondering if it is possible to nest an "OR" statement into an "AND" statement. In short, Task C requires Task A be "complete" and Task B be one of two statuses.
I'd expect it to work something like this (note, I'm using status names to illustrate the point): =IF(AND(StatusA="Complete", OR(StatusB="In Progress", StatusB="Complete")), "In Progress", "Not Started")
This is throwing errors, though. Is there a trick I'm not getting, or
Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!