Question: *need only formula for these steps Click cell C19, use a function to enter today's date in the cell. Click cell D5, calculate how many

 *need only formula for these steps Click cell C19, use a

*need only formula for these steps

Click cell C19, use a function to enter today's date in the cell. Click cell D5, calculate how many years this person has been working in this university based on "date hired and today's date. Remove all decimal points and only show the whole number. Click cell E5, calculate the raise based on the current salary and raise rate (in C17 and C18). Employees who have worked the specified years (C16) or longer earn a high raise; employees who have worked less than the specified years earn a low raise. Click cell G5, calculate the rating bonus based on each employee's performance rating (see bonus data). Click cell H5, calculate the new salary amount based on each employee's current salary, the raise, and the bonus. Click cell J5, calculate the taxable salary, which is the new salary after deduction (the difference between the new salary amount and the product of the number of dependents and deduction per dependent (C20)). For example, if the employee has one dependent, he/she will get $50 deduction. And so on

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