SOLVED
Home

Help with an IF AND formula

%3CLINGO-SUB%20id%3D%22lingo-sub-392229%22%20slang%3D%22en-US%22%3EHelp%20with%20an%20IF%20AND%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392229%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20wording%20a%20formula%20that%20will%20bring%20up%20%22Incomplete%22%20if%20Programming%20Course%20and%20Network%20Course%20have%20even%20just%20one%20%22N%22%20and%20%22Complete%22%20if%20they%20both%20have%20%22Y%22.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20included%20a%20screenshot%20to%20show%20how%20close%20I%20got%20but%20it's%20still%20not%20the%20correct%20one.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20greatly%20appreciate%20any%20assistance.%26nbsp%3B%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100900i742FB295D598CCAF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-392229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eif%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392235%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20IF%20AND%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F312121%22%20target%3D%22_blank%22%3E%40aanaya6%3C%2FA%3E%20%2C%20yes%2C%20try%20to%20keep%20things%20simple.%20You%20are%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392234%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20IF%20AND%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392234%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much!%20I%20don't%20why%20I%20make%20things%20overly%20complicated%20for%20myself%20%26gt%3B.%26lt%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392232%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20IF%20AND%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392232%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F312121%22%20target%3D%22_blank%22%3E%40aanaya6%3C%2FA%3E%20%2C%20perhaps%3C%2FP%3E%0A%3CPRE%3E%3DIF(%20AND(F6%3D%22Y%22%2CG6%3D%22Y%22)%2C%20%22Complete%22%2C%20%22Incomplete%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
aanaya6
New Contributor

I am having trouble wording a formula that will bring up "Incomplete" if Programming Course and Network Course have even just one "N" and "Complete" if they both have "Y". 

I included a screenshot to show how close I got but it's still not the correct one. 

 

I would greatly appreciate any assistance. 
Capture.JPG

3 Replies
Solution

@aanaya6 , perhaps

=IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")

Thank you so much! I don't why I make things overly complicated for myself >.<

@aanaya6 , yes, try to keep things simple. You are welcome.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies