Nesting OR into AND?

@emipathy

Hi All,

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!

Werner Gerstacker

It looks fine to me - as long as you have your @row reference in there you should be fine:

=IF(AND(StatusA@row ="Complete", OR(StatusB@row ="In Progress", StatusB@row ="Complete")), "In Progress", "Not Started")

Paul Newcome

You're actually very close. You only need to include a row number or "@row" reference.

=IF(AND(StatusA@row="Complete", OR(StatusB@row="In Progress", StatusB@row="Complete")), "In Progress", "Not Started")