Jun 28 2019 08:14 AM - edited Jun 28 2019 08:32 AM
I am trying to add N/A to the function so that it does the same functionality as pass would and not have "y" show up in the Next Step? column.
=IF(AND(A10<>A9,LOWER(J10)<>"pass"),
"Y",IF(K8="STEP SKIPPED","N",
IF(AND(AND(OR(ISBLANK(J10),LOWER(J10)="fail"),
NOT(LOWER(J9)<>"pass")),A9=A10),"Y","N")))
Jun 28 2019 12:28 PM
Hey,
Sorry, I'm not quite clear on what you are asking. Could you please provide an example?