Forum Discussion

alexw94's avatar
alexw94
Copper Contributor
Jun 05, 2023

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.

 

 

Thanks

excel
Formulas and Functions

3 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jun 05, 2023

    alexw94 

    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")

    • alexw94's avatar
      alexw94
      Copper Contributor
      Jun 05, 2023

      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.

Resources