Need help on IF & OR formla

%3CLINGO-SUB%20id%3D%22lingo-sub-2427555%22%20slang%3D%22en-US%22%3ENeed%20help%20on%20IF%20%26amp%3B%20OR%20formla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427555%22%20slang%3D%22en-US%22%3EQuery%20is%20in%20the%20image%20attached.%20Can%20someone%20please%20help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2427555%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2427609%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20on%20IF%20%26amp%3B%20OR%20formla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073919%22%20target%3D%22_blank%22%3E%40SandeepDaga%3C%2FA%3E%26nbsp%3BTry%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DOR(N(B2)%26gt%3BN(A2)%2CAND(A2%3D%22NA%22%2CB2%3D%22NA%22))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2427817%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20on%20IF%20%26amp%3B%20OR%20formla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427817%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20help%2C%20I%20am%20attaching%20my%20result.%20Refer%20row%205%20and%206%2C%20my%20desired%20result%20is%20False%20but%20using%20the%20above%20formula%20it%20is%20coming%20true%3C%2FLINGO-BODY%3E
New Contributor
Query is in the image attached. Can someone please help
4 Replies

@SandeepDaga Try this:

=OR(N(B2)>N(A2),AND(A2="NA",B2="NA"))

 

Thanks for your help, I am attaching my result. Refer row 5 and 6, my desired result is False but using the above formula it is coming true

@SandeepDaga See attached. This is what I get.

Row 2: B is not greater than A (in other words, B-A is not greater than zero) and both are not equal to NA, thus the result is FALSE

Row 3: No problem, both are NA, thus TRUE

Row 4: On what basis do you want to see a blank here? That not in your original question. "Anything else should show FALSE". Any two texts not both equal to NA will result in FALSE.

Row 5: B is not greater than A, thus FALSE

Row 6: Sames as row 4; No numbers involved here and the texts are not both NA, thus FALSE.

 

 

Thanks for your patienceand elaborate reply, but in row 2 if both are equal, then also the result should be true,

My result changed when I placed = and > sign