Help with an IF AND formula

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. 

3 Replies

@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