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. ***