Hi

Try this
=IF(OR(B2="Missing",B2="Maintain"),B2,
IF(AND(A2="gv", B2="return",COUNTIF(C2:G2,"Save")>0),"save",
IF(AND(B2="return",COUNTIF(D2:E2,"save")+COUNTIF(G2,"save")>0),"save",
IF(AND(A2<>"gv",COUNTIF(B2:E2,"destroy")+COUNTIF(G2,"destroy")=5),"destroy",
IF(AND( COUNTIF(B2:E2,"")+COUNTIF(G2,"") > 0),"Pending",
IF(A2="gv",F2,"something not considered"
))))))
rylo