Home

IF NOT OR Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-728212%22%20slang%3D%22en-US%22%3EIF%20NOT%20OR%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728212%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20N%2FA%20to%20the%20function%20so%20that%20it%20does%20the%20same%20functionality%20as%20pass%20would%20and%20not%20have%20%22y%22%20show%20up%20in%20the%20Next%20Step%3F%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20281px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121599iA047B4D834F681CB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ss.PNG%22%20title%3D%22ss.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(A10%26lt%3B%26gt%3BA9%2CLOWER(J10)%26lt%3B%26gt%3B%22pass%22)%2C%3C%2FP%3E%3CP%3E%22Y%22%2CIF(K8%3D%22STEP%20SKIPPED%22%2C%22N%22%2C%3C%2FP%3E%3CP%3EIF(AND(AND(OR(ISBLANK(J10)%2CLOWER(J10)%3D%22fail%22)%2C%3C%2FP%3E%3CP%3ENOT(LOWER(J9)%26lt%3B%26gt%3B%22pass%22))%2CA9%3DA10)%2C%22Y%22%2C%22N%22)))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-728212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729043%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20NOT%20OR%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729043%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368333%22%20target%3D%22_blank%22%3E%40BobExcel4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHey%2C%3C%2FP%3E%3CP%3ESorry%2C%20I'm%20not%20quite%20clear%20on%20what%20you%20are%20asking.%20Could%20you%20please%20provide%20an%20example%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
BobExcel4
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?