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 ([Service Years]) and the College Graduate columns ([College Graduate]). If a staff member meets one or both of those criteria, the function should return the text Yes (using “Yes” for the value_if_true argument). If a staff member meets neither of those criteria, the function should return the text No (using “No” for the value_if_false argument).
Ive tried plenty formualas and it's not accepting them on my mac. please help.
Aucun commentaire:
Enregistrer un commentaire