Question: In cell H 8 , enter a formula using the IF and OR functions to determine whether the value in the Years column is greater

In cell H8, enter a formula using the IF and OR functions to determine whether the value in the Years column is greater than or equal to 2 OR whether the value in the Avg Eval column is greater than or equal to 7. Use a structured reference to both columns ([@Years] and [@[Avg Eval]]). The formula returns the text Yes if a contractor meets one or both of the criteria, and it returns No if a contractor meets neither criteria. Fill the formula into the range H9:H27, if necessary.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!