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 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
Get step-by-step solutions from verified subject matter experts
