Need help with VLOOKUP.

[denigu]

Hi guys. I understood how to use VLOOKUP to get a tax rate from a table for the money range. Here is the table.
Screen Shot 2016-03-14 at 1.45.43 AM.png
I am supposed to calculate the federal tax. Federal Tax = Federal Tax Rate * Pay after deductions
I dont understand how can I use the way below to calculate it. I can only make the worksheet take one percentage according to the weekly pay after deductions value. Can anyone help me do this ?:

For a given row, the tax rate in the second column applies to the weekly pay greater than or equal
to (but less than the weekly pay in the row right below) the value in the first column. For example, if the
weekly pay after deduction is equal to $1,200; the tax would be 5% of the first $650 plus 10% of $350
(1,000 – 650) plus 15% of $200 (1,200 – 1,000).

[Keebellah]

Hi welcome to the forum.
I haven't checked it yet but if you read the quote it's a question of splitting up the pay or amount you have (1200)
1200 is split up
0-649
650-999
1000-1499 and here you only have 200 left
So you do 3 time VLOOKUP for 0, 650 and 100

[FDibbins]

This sounds a bit like a homework assignment?
How would you do this by hand?

[denigu]

Hi welcome to the forum.
I haven't checked it yet but if you read the quote it's a question of splitting up the pay or amount you have (1200)
1200 is split up
0-649
650-999
1000-1499 and here you only have 200 left
So you do 3 time VLOOKUP for 0, 650 and 100

I got it but I dont know how to seperate the value to those intervals. Any help would be appreciated

[denigu]

This sounds a bit like a homework assignment?
How would you do this by hand?

yes it is a homework assignment. one of 8+ worksheets. I got only this formula left to do

[Keebellah]

Well, homework should be your own gain, sorry.

Just think of what I told you and if this is part of your exam I expect that some logic and brain gymnastics are in place

[denigu]

Well, homework should be your own gain, sorry.

Just think of what I told you and if this is part of your exam I expect that some logic and brain gymnastics are in place

this is just an assignment I dont get why you dont help just because it is my homework. my class doesnt even have anything to do with excel

[FDibbins]

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

[Keebellah]

If you read my first answer #2

Then you might just see it.
You know that 0-649 = 0%
then just do the following
VLOOKUP 650 ? %
VLOOKUP 1000 ? %
and VLOOKUP what comes after 1000 since it's x % you need to pay over the remaining 200
So, I guess you've got enough information.
Homework is homework