Wednesday, 6 November 2019

.) Assume now that the Tax Break is more complex than the previous step. If you had a least

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

Contact Us For Tutoring:

Name

Email *

Message *