Jun 19 2022 01:36 AM
I need help putting the formula for the table below.
Target Start Date | Actual Completion | Result | Status |
Not started | |||
12-Jun-22 | In Progress | ||
12-Jun-22 | 15-Jun-22 | Fail | Retest |
12-Jun-22 | 17-Jun-22 | Pass | Completed |
Target Start Date<Blank> ,Actual Completion <Blank> = Not Started
Target Start Date<Blank> ,Actual Completion <Blank>, Result <Blank> = In Progress
Target Start Date<Blank> ,Actual Completion <Blank>, Result <Pass> Completed
Target Start Date<Blank> ,Actual Completion <Blank>, Result <Fail> Retest
Jun 19 2022 06:38 AM
Thank you!
I hv tried and its works.
but there were additional condition added in the formula.
help me to validate if this is correct.
=IF(AND(A3="",B3="",C3=""),"Not started",IF(AND(A3<>"",B3="",C3=""),"In progress",IF(AND(A3<>"",B3<>"",C3="Pass",E3=""),"Completed",IF(AND(A3<>"",B3<>"",C3="Fail",E3=""),"Retest",IF(AND(A3<>"",B3<>"",C3="Fail",E3="Fail"),"Retest",IF(AND(A3<>"",B3<>"",C3="Fail",E3="Pass"),"Completed",""))))))
Thank you
Jun 19 2022 06:55 AM
=IF(AND(A3="",B3="",C3=""),"Not started",IF(AND(A3<>"",B3="",C3=""),"In progress",IF(AND(A3<>"",B3<>"",C3="Pass",E3=""),"Completed",IF(AND(A3<>"",B3<>"",C3="Fail",E3=""),"Retest",IF(AND(A3<>"",B3<>"",C3="Fail",E3="Fail"),"Retest",IF(AND(A3<>"",B3<>"",C3="Fail",E3="Pass"),"Completed",""))))))
You are welcome. Your formula works in my sheet.
Jun 19 2022 02:28 AM
Solution=IF(AND(A3="",B3="",C3=""),"Not started",IF(AND(A3<>"",B3="",C3=""),"In progress",IF(AND(A3<>"",B3<>"",C3="Fail"),"Retest",IF(AND(A3<>"",B3<>"",C3="Pass"),"Completed",""))))
Maybe with this formula.