Forum Discussion
aanaya6
Apr 01, 2019Copper Contributor
Help with an IF AND formula
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. 
- aanaya6 , perhaps - =IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete") 
3 Replies
- SergeiBaklanDiamond Contributoraanaya6 , perhaps =IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete") - aanaya6Copper ContributorThank you so much! I don't why I make things overly complicated for myself >.< - SergeiBaklanDiamond Contributoraanaya6 , yes, try to keep things simple. You are welcome.