Tieried taxes

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Apr 2, 2003

• #2

What happens between 2 and 3 million?

 

Upvote 0

A

adaryana

New Member

Joined

Feb 9, 2003

Messages

28

• Apr 2, 2003

• #3

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

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Apr 2, 2003

• #4

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

 

Upvote 0

A

adaryana

New Member

Joined

Feb 9, 2003

Messages

28

• Apr 2, 2003

• #5

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 ?

 

Upvote 0

just_jon

Legend

Joined

Sep 3, 2002

Messages

10,473

• Apr 2, 2003

• #6

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

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Apr 2, 2003

• #7

Re: Still not clear

adaryana said:

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 ?

Click to expand...

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.

 

Upvote 0