Question description:
This user has given permission to use the problem statement for this
blog.
Next, you need to begin determining the employeeâ??s final raise. Add the following.
In cells H6:H13, add an IF function that will award anyone with a Raise Recommend of High an extra bonus listed in cell F2. All other employees get zero bonus.
In cells I6:I13, add an IF function that will give anyone with a Raise Recommend of Low a deduction listed in cell F3. All other employees get zero deduction.
Solved by B. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/09/2018 - 09:48
Hello, Welcome to Got it Pro.
Excelchat Expert
12/09/2018 - 09:48
Please forward the working sheet so that I can help you.
Excelchat Expert
12/09/2018 - 09:49
You can also add the sample data at the right side of the screen.
User
12/09/2018 - 09:50
Next, you need to begin determining the employee’s final raise. Add the following.
In cells H6:H13, add an IF function that will award anyone with a Raise Recommend of High an extra bonus listed in cell F2. All other employees get zero bonus.
In cells I6:I13, add an IF function that will give anyone with a Raise Recommend of Low a deduction listed in cell F3. All other employees get zero deduction.
On the Payroll worksheet, in cells J6:J13, add a calculation that returns the final raise amount with the value—not just formatted—rounded to the hundreds position (-2). For example, a final raise of $1,625 rounded to the hundreds returns a value of $1,600. The final raise amount is the salary multiplied by the Standard Raise % and then adding any bonus and subtracting any deduction.
Excelchat Expert
12/09/2018 - 09:51
lemme see.
User
12/09/2018 - 09:52
Ok
Excelchat Expert
12/09/2018 - 09:55
I am done with Col H and I, sounds good?
User
12/09/2018 - 09:55
what about Col J ?
User
12/09/2018 - 09:55
please help..
Excelchat Expert
12/09/2018 - 09:56
I will help you with Col J as well in this session but let me remind you for coming sessions- as per the got it pro policy we are allowed to solve only one problem in one session.
Excelchat Expert
12/09/2018 - 09:57
Let me see what you need in col J
User
12/09/2018 - 09:57
Ok thanks!!!
User
12/09/2018 - 09:57
On the Payroll worksheet, in cells J6:J13, add a calculation that returns the final raise amount with the value—not just formatted—rounded to the hundreds position (-2). For example, a final raise of $1,625 rounded to the hundreds returns a value of $1,600. The final raise amount is the salary multiplied by the Standard Raise % and then adding any bonus and subtracting any deduction.
Excelchat Expert
12/09/2018 - 09:58
where is the final raise? is it high bonus- low deduct ?? or somewhere else?
Excelchat Expert
12/09/2018 - 09:58
ohh it is there
User
12/09/2018 - 10:00
Ok is it done?
Excelchat Expert
12/09/2018 - 10:00
Now it is done.
User
12/09/2018 - 10:00
whats about the rounddown?
Excelchat Expert
12/09/2018 - 10:00
I did that
Excelchat Expert
12/09/2018 - 10:00
You can see in col J
Excelchat Expert
12/09/2018 - 10:01
All values are rounded down
Excelchat Expert
12/09/2018 - 10:01
Does this solve your query?
User
12/09/2018 - 10:01
yes
Excelchat Expert
12/09/2018 - 10:01
Please end the session, I will appreciate a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time.
User
12/09/2018 - 10:01
thank you so much!
Excelchat Expert
12/09/2018 - 10:01
Thanks for using Got it Pro. Looking forward to help you further.
Appreciate it :)
Excelchat Expert
12/09/2018 - 10:01
Have a good day
User
12/09/2018 - 10:01
no problem!
User
12/09/2018 - 10:01
will rate u 5 star !!
User
12/09/2018 - 10:01
have a nice day
Excelchat Expert
12/09/2018 - 10:01
Do not raise multiple problems in one session next time onwards.
Excelchat Expert
12/09/2018 - 10:01
you too, thanks
Excelchat Expert
12/09/2018 - 10:02
if experts will rate you low then you wont get best experts going forward so keep in mind the policy. :)
Excelchat Expert
12/09/2018 - 10:02
Please end the session and rate a 5 star, thanks again.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.