Forum Discussion
Which formula would I need for the nested "If" please?
Hi, What formula would I need to write in order to achieve the Status (column D) what would this give? The below screenshot shows the outcomes and the status is the required answer. ...
For example:
=IF(OR(B2="Yes",AND(B2<>"Not Completed",C2="Yes")),"Complete","Not Complete")
or
=IF(AND(B2<>"Yes",OR(B2="Not Completed",C2="No")),"Not Complete","Complete")
HansVogelaar Thank you, my requirements have changed, how i can include the below into the formulas you suggested? Partially needs to be outcomes for rows 7 and 8.
=IF(B2="Not Completed","Not Complete",IF(OR(B2:C2="Yes"),"Complete","Partial"))
