In cell K2 enter a formula using the IF and OR functions, as well as structured

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 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?

Explanation / Answer

I think the problem is using [#Headers] in the formula. This is preventing the formula to calculate the result of the whole column and instead its just considering the Header row.

Try using the below formula instead:

IF(OR(CBFStaff[[#Data],[Service Years]],>3,CBFStaff[[#Data],[College Graduate]]="Yes"),"Yes","No")

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.