Help In cell H6, use an IF function with a nested AND function to create a function that analyzes the content of F6 and G6. Return Complete if both cells contain a Y or Incomplete if one or both cells contain an N.

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

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")

answer; by the southern association of colleges and schools commissions(institutional accreditation)