VLOOKUP intervals in Excel

[keybladegoddess]

This is the problem....


Federal income tax can be computed through a VLOOKUP table for an income (x) by usingFederal income tax can be computed through a VLOOKUP table for an income (x) by using theFederal income tax can be computed through a VLOOKUP table for an income (x) by using the following function:

.15x 0 ≤ x < 45,200
.275x - 5650 45,200 ≤ x < 109,250
T(x) = .305x - 8930 109,250 ≤ x < 166,500
.355x - 17250 166,500 ≤ x < 297,350
.391x - 28000 x ≥ 297,350


Assume you are working with an Excel spreadsheet as shown below:

Create an Excel spreadsheet that calculates a person’s income tax. Test your spreadsheet for incomes of $20,000, $50,000, $120,000, $170,000, and $300,000. Also check the endpoints of each interval: $45,200, 109,250, etc.


*I think i am just ridiculously floored on how to go about this. Can someone attempt to explain this?*

 

[keybladegoddess]

Nevermind problem solved

 

[stuckagain22]

I have a similar problem and I am hoping you could please indicate how you solved this one? I have normally just used a bunch of IF statements nested inside each other as I have not been able to figure out a way to do a LOOKUP on a range.

Thanks.