Forum Discussion

AMZI2001

Copper Contributor

Jun 19, 2022

Solved

help

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...

excel

Formulas and Functions

OliverScheurich

Jun 19, 2022

AMZI2001

=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.

OliverScheurich

Gold Contributor

Jun 19, 2022

AMZI2001

=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.

AMZI2001

Copper Contributor

Jun 19, 2022

OliverScheurich

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

OliverScheurich

Gold Contributor

Jun 19, 2022

AMZI2001

=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.