Question: Still on Sheet 1 , use formulas and functions to calculate the annual leave. Full - time employees hired before 2 0 1 1 or

Still on Sheet 1, use formulas and functions to calculate the annual leave. Full-time employees hired before 2011 or domestic employees with total sales over $250,000 receive 20 days of annual leave. All others receive 10 days. Don't use the YEAR().
Result:
\table[[Annual Leave,],[,10],[,10],[,10],[,10],[,20],[,10],[,20],[,20],[,10],[,20],[,10],[,10],[,10]]
Still on Sheet 1 , use formulas and functions to

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!