enter a formula using the IF function that uses a structured reference to the Years column $([$@Years$])$ to determine if the value is greater than $1.$ The formula returns the text Yes if true and No if false. Fill the formula into the range G$9$: G$27,$ if necessary.

Contractors who can write reviews must have at least $2$ years of experience or an average evaluation rating from Contract Shop managers of $7$ or more. In cell $H8,$ enter a