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

solution:

the auto-correct option of the auto-correct tool enables you to add and delete words that do not follow abbreviation rules because:

it is a feature that allows outlook to correct common spelling and typing errors and to replace characters with symbols. we can also can use auto-correct as a shortcut, which means we can type a small string of characters and have those characters replaced by a longer string.