Question: generate forumlas i can use for each excel column. columns: c 2 :c 7 = employee status d 2 :d 7 = years worked e
generate forumlas i can use for each excel column. columns: c:c employee status d:d years worked e:e health care f:f retirement g:g vacationh:h dentalvision i:i discounts c full time c full time c part time c full time c part time d dddde no e no e no e no e no Health Care: Employees who are full time AND have worked more than five years are eligible to receive health care benefits. Either Yes they are eligible or No they are not. Retirement: Only full time employees receive benefits. If they are eligible write "RET" in the cell or else leave the cell blank. Vacation: All employees who have worked more than five years, receive $ per year they have worked as a vacation credit, or else they get nothing. Be sure you calculate the full vacation credit for each employee. DentalVision: Employees can buy their dental and vision insurance if they are already receiving Health Care benefits for a $ payroll deduction. Either they pay out $ or nothing. Discount: Employees who have worked more than years get a discount. Employees who have worked more than years get a discount. Employees who have worked more than years get a discount. Anyone who has worked less than years does not get a discount.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
