Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
6.) Assume now that the Tax Break is more complex than the previous step. If you had a least $10,000 withheld, you get $500 back.
6.) Assume now that the Tax Break is more complex than the previous step. If you had a least $10,000 withheld, you get $500 back. If you had at least $15,000 withheld, you get $1,000 back. If you had $20,000 or more withheld, you get $2,000 back as before. Use a VLOOKUP statement to compute the New Tax Break in Column I. a. Using the following table: Amount withheld New tax break 0 0 10000 500 15000 1000 20000 2000
***This is what I have used. I need to use VLOOKUP for find the new tax break. ***
New Tax Break Employee Number First Name Last Name Gender 1001 Patrick Grogen M 1002 Sarah Hernadez F 1003 Michael Jameson M 1004 James Johnson M 1005 Ron Johnston M 1006 Ben Kim M 1007 April Lorenzo F 1008 Kelly Nguyen F 1009 Mark O'neil M 1010 Tisha Rose F Department Yearly Salary Tax Withheld Tax Break HR 90200 18040 0 95000 190000 IT 97000 194000 91000 182000 PR 99500 199000 PR 92000 18400 O HR 98050 19610 O PR 90000 180000 Accounting 94500 189000 100000 200000 New Tax Break Employee Number First Name Last Name Gender 1001 Patrick Grogen M 1002 Sarah Hernadez F 1003 Michael Jameson M 1004 James Johnson M 1005 Ron Johnston M 1006 Ben Kim M 1007 April Lorenzo F 1008 Kelly Nguyen F 1009 Mark O'neil M 1010 Tisha Rose F Department Yearly Salary Tax Withheld Tax Break HR 90200 18040 0 95000 190000 IT 97000 194000 91000 182000 PR 99500 199000 PR 92000 18400 O HR 98050 19610 O PR 90000 180000 Accounting 94500 189000 100000 200000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started