Question: In cell K2 enter a formula using the IF and OR functions, as well as structured refereneces, to determine if Adam Moriarty can be a

In cell K2 enter a formula using the IF and OR functions, as well as structured refereneces, to determine if Adam Moriarty can be a group leader.

The IF function should first determine if the staff member's Service Years is greater than 3 OR if the staff member's college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns.

The function should return the text Yes if a staff member meets one or both of those criteria.

The function should return the text No if a staff member meets neither of those criteria.

Here is the syntax: =IF(OR(CBFStaff[[#Headers],[Service Years]],>3,CBFStaff[[#Headers],[College Graduate]]="Yes"),"Yes","No")

When I use this formula I get Yes all the way down K2. Where am I going wrong?

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 Databases Questions!

EX16.8a-Saved to my Mac Q- Search in ences Mailings Review View Normal years or be college graduate. In cell K2 enter a formula using the IF and OR functions, as wen as structured to determine i#...

1.Dean Hilson is the director of Camp Bright Firewood. He started planning the camp staffing assignments for next year in an Excel table, and needs your help completing the table. First, he'd like to...

6. According to camp policy, staff members need to be at least 23 years old to transport students. Dean now wants to determine how many members of his staff will be available to drive. In cell 22,...

According to camp policy, staff members need to be at least 23 years old to transport students. Dean now wants to determine how many members of his staff will be available to drive. In cell J2, enter...

Module 8 Sam project 1 b . I need help with 4, 5, 7 New Perspectives Excel 2016 T Module 8:SAM Pr In cell G2, enter a formula without a function using structured references to determine the number of...

New Perspectives Excel 2016 | M Module 8: SAM Project 1b references to determ column f The enter a formula without a function using structurth HR vear ethe number of years since Alison Simoneau...

1. To be a Group Leader, the staff member must either have more than 3 service years or be a college graduate. In cell K2 enter a formula using the IF and OR functions, as well as structured...

To be a group leader, the staff member must either have more than 3 service years or be a college graduate. In cell K2 enter a formula using the IF and OR functions, as well as structured references,...

1 To be a Group Leader, the staff member must either have more than 3 service years or be a college graduate. In cell K2 enter a formula using the IF and DR functions, as well as structured...

Julia Walters owns and operates one of the largest Mercedes-Benz auto dealerships in Washington, DC. In the past 36 months her sales of this luxury car have ranged from a low of 6 new cars to a high...

Which of the following are potential risks from investing in bonds? Select all that apply. Default risk Reinvestment risk Call risk Interest rate risk Inilation risk

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. Have the team members identify the potential sources for conflict.

2. What process will you put in place to address conflicts?

3. When I talk to team members, I can gauge their true feelings from their body language.