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 Contributor
aanaya6 , perhaps
=IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")
- aanaya6Copper Contributor
Thank you so much! I don't why I make things overly complicated for myself >.<
- SergeiBaklanDiamond Contributor
aanaya6 , yes, try to keep things simple. You are welcome.