contestada

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.

Respuesta :

mahamnasir

Answer:

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

Otras preguntas