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 H enter a formula using the IF and OR functions to determine whether the value in the Years column is greater than or equal to OR whether the value in the Avg Eval column is greater than or equal to 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 H:H if necessary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
