IF NOT OR Problem

Occasional Visitor

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.

 

ss.PNG

 

=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")))

1 Reply

@BobExcel4 

 

Hey,

Sorry, I'm not quite clear on what you are asking. Could you please provide an example?