SOLVED

Help with an IF AND formula

Copper 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. 
Capture.JPG

3 Replies
best response confirmed by aanaya6 (Copper Contributor)
Solution

@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.

1 best response

Accepted Solutions
best response confirmed by aanaya6 (Copper Contributor)
Solution

@aanaya6 , perhaps

=IF( AND(F6="Y",G6="Y"), "Complete", "Incomplete")

View solution in original post