# Excel - IF Function Problem - Expert Solution

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
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
User 12/09/2018 - 09:55
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.