if code amendment help

Please Login or Register  to view this content.

I need the above to do this

if c62 = "pass" or "site" call , then "No Changes Made"

if c62 = "fail"then check B62 To see if the text contains "NO CALL", if it does then "No Called By Team Leader"

otherwise check A62 to see if text contains "NO CALL", If it does then "No Longer NO CALL" , "Team Leader Change Audit Call"

worked it out thanks anyways everyone