Answer:
=IF(AND(ClubInformation!$F6="Y",ClubInformation!$G6="Y"),"Complete","Incomplete")
Step-by-step explanation:
IF function here checks if both cells F6 and G6 contain a Y. To check if both have a Y AND function is used for both F6 andG6. If both cells contain a Y then Complete is returned and if one or both cells contain an N it will display Incomplete.
IF function returns a value if the condition specified in the function evaluates to true, otherwise returns the false value. This statement can be explained as:
=IF (AND F6 & G6 = "Y", "N")