Question: 18. In cell N2, enter a formula using the IF and OR functions to determine whether an employee will earn a bonus vacation week. A

18. In cell N2, enter a formula using the IF and OR functions to determine whether an employee will earn a bonus vacation week. A bonus vacation week is awarded to employees based on their job status (shown in Column G) or years of service (shown in column M). Use structured references and the following parameters when creating this formula: a. If the employees Job Status field value is equal to FT or an employees Years Service field value is greater than 20, the formula should return the value 1 (indicating 1 bonus week of vacation). b. If neither of those conditions are true, the formula should return the value 0 (indicating 0 bonus weeks of vacation). The formula should automatically fill into the range N2:N101. (Hint: If the formula does not fill into that range, copy the formula from cell N2 to the range N3:N101.) I can only get part of this formula correct>

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

In cell N2, enter a formula using the IF and OR functions to determine whether an employee will earn a bonus vacation week. A bonus vacation week is awarded to employees based on their job status...

In cell N2, enter a formula using a nested IF function to determine the number of bonus vacation weeks an employee will earn. Employees are awarded bonus vacation weeks based on their years of...

Theresa Pratt works in the business office at Mills College, a technical college in Council Bluffs, Iowa. She has created a workbook to store and analyze registration and employee data. The workbook...

Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a...

Project Description: You work for a dothing distributor that has locations in lowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main ernployee data set, use...

Hi, Could you help me with my accounting payroll ch 7 project. It's due tonight before 10pm. Excel Instructions using Excel 2010 or 2013: CAUTION: Read Appendix B for specific instructions relating...

Thank u guys:) This is the reference pages but the questions are the last 3 pictures . . . . Craft - Mason Wage rate VET $29.00 Hours worked 50 hours per week for 20 weeks and 40 hours per week for...

The Rent Expense account had a normal balance of $1,100. The entry to close the account would include a O A. credit to Income Summary, $1,100. O B. debit to Income Summary, $1,100. OC. debit to Rent...

The frame- welding department of a large automotive company welds car frames as they pass down the assembly line. Four computer- controlled robots make the welds on each frame simultaneously. When...

If euros sell for $ 1 . 6 4 ( U . S . ) per euro, what should dollars sell for in euros per dollar? Round your answer to four decimal places.

The article Motivational Effects of Test Scores of Elementary Students (Brown

Evaluate the impact of unions on nurses and physicians.

Describe the impact of strikes on patient care.

Evaluate long-term care insurance.