217k views
1 vote
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.

User Hazardous
by
4.2k points

1 Answer

6 votes

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

User Richard Petheram
by
4.6k points