In cell K2 enter a formula using the IF and OR functions, as well as structured references, to determine if Adam Moriarty can be a group leader. a. The IF function should first determine if the staff members Service Years is greater than 3 OR if the staff members college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns.

Question

vanderson · Accepted Answer

Solution :The value of the K2 cell is filled by IF and OR functions with structured references as :[tex]K2=IF(OR([CBF\ 	ext{Staff[ Service years]} &gt; 3, 	ext{CBF Staff[College graduate]}="Yes"),"Yes","No")[/tex]Now if the syntax of the formula is not provided, then we can use :[tex]$K2=IF(OR([[	ext{Service Years}]]&gt;3,[[	ext{College Graduate}]]="Yes"),"Yes","No")$[/tex]The staff member are required to satisfy one of the two or both the conditions so as to become a group leader. The conditions are :--- staff member should served for more than 3 years--- staff members should be college graduate

Answers

Related Questions