Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 1103 points

DBF

Favorite Answers0%
Answers2

  • Ho to use the IF and OR functions in a formula?

    I am taking an online excel class and for a project I have to enter a formula using the IF and OR functions, but I have absolutely NO idea how to do that and I have looked all over my textbook. I will post the question as well in case it helps. Also I am using Excel 2007. Thank you so much if you decide to help me!

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

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

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

    1 AnswerSoftware2 years ago