Tieried taxes

[adaryana]

How do I setup a tieried taxes in excel ? so if column 1 has the income and my schedule is:
0-$500K - 30%
$500K - $999 - 25%
$1M - $1.5M - 30%
$1.51M - $2M - 35%
$2M + - 40%

Sorry for the earlier error!
thanks.

 

[Mark W.]

What happens between 2 and 3 million?

 

[adaryana]

Just changed its its a constant after $2M ...just a typing error sorry.

 

[Mark W.]

=VLOOKUP(ref,{0,0.3;500000,0.25;1000000,0.3;1510000,0.35;2000000,0.4},2)

 

[adaryana]

Still not clear

The answer u sent does answer the question.
If u make 1.5M... The first 1/2 is charged at 30%, the next 1/2 at 25 and the next 1/2 at 30%... how do I get a averge tax rate ?

 

[just_jon]

Something like this --

Book3
	A	B	C	D	E	F
1	0-500K	500K-999K	1M-1.5M	1.5M-2M	2M+	Amount
2	30%	25%	30%	35%	40%	$2,750,000.00
3	$150,000.00	$125,000.00	$150,000.00	$175,000.00	$300,000.00	$900,000.00
4						32.73%
Sheet1

 

[Mark W.]

Re: Still not clear

The answer u sent does answer the question.
If u make 1.5M... The first 1/2 is charged at 30%, the next 1/2 at 25 and the next 1/2 at 30%... how do I get a averge tax rate ?

You didn't pose your question in this fashion and you didn't provide any sample data/solutions. And, the word "tieried" isn't in my dictionary.