Question
I have pasted the full problem and aced it up to number 6 so I need help on number 6 below. I don't know how
I have pasted the full problem and aced it up to number 6 so I need help on number 6 below. I don't know how to incorporate vlookup for multiple numbers. Please help. Thanks.
1. Open a blank worksheet in Excel. Enter the First name, Last Name, Gender, Department, and Yearly Salary (with 2 decimals) for 10 fictitious people in Columns A-E, Beginning in Row 2. Be sure to enter column headings (Row 1) and align them with the data. Adjust column widths as needed.
2. Sort the data by Last Name.
3. Insert a column before the name (new column A), and enter the Employee Number. Type only the first two numbers, then select both and copy down for autofill.
4. In Column G, type the heading Tax Withheld, and enter a formula that computes it. Assume 20% of the salary is withheld for taxes.
5. The new tax code give a Tax Break of $2,000 for all those who have more than $20,000 withheld. Use an IF statement to compute this in Column H.
6. Assume now that the Tax Break is more complex. 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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