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: c2:c7= employee status d2:d7= years worked e2:e7= health care f2:f7= retirement g2:g7= vacationh2:h7= dental/vision i2:i7= discounts c3= full time c4= full time c5= part time c6= full time c7= part time d3=1 d4=1d5=2d6=3d7=3e3= no e4= no e5= no e6= no e7= 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 $200 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. Dental-Vision: Employees can buy their dental and vision insurance if they are already receiving Health Care benefits for a $20 payroll deduction. Either they pay out $20 or nothing. Discount: Employees who have worked more than 3 years get a 5% discount. Employees who have worked more than 5 years get a 10% discount. Employees who have worked more than 7 years get a 15% discount. Anyone who has worked less than 3 years does not get a discount.
generate forumlas i can use for each excel

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