Apr 01 2019 03:11 PM - edited Apr 01 2019 03:16 PM
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.
Apr 01 2019 03:16 PM
Solution@aanaya6 , perhaps
=IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")
Apr 01 2019 03:18 PM
Thank you so much! I don't why I make things overly complicated for myself >.<
Apr 01 2019 03:21 PM
@aanaya6 , yes, try to keep things simple. You are welcome.
Apr 01 2019 03:16 PM
Solution@aanaya6 , perhaps
=IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")