Forum Discussion

aanaya6's avatar
aanaya6
Copper Contributor
Apr 01, 2019
Solved

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 t...
excel
Formulas and Functions
if
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 01, 2019

    aanaya6 , perhaps

    =IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 01, 2019

aanaya6 , perhaps

=IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")
aanaya6's avatar
aanaya6
Copper Contributor
Apr 01, 2019

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 01, 2019

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

Resources