basic formula help

s2mcpaul

New Member
Joined
Oct 13, 2006
Messages
11
I need help with a formula. I will be greatful for assistance.

It is for tax brackets.

I have a value an income amount, and based upon the amount it will fall into a particular tax bracket.


This is a very simple example:
Consider each of the brackets (below) have a corresponding interest rate.
If the income is $1000 I would want it to skip bracket 1 and give me a calculation for the rate in bracket 2. If 2000, skip 1,2 and calculate 3.


1) $154 440
2) $440 1308
3) $1,308 2440
4) $2,440 3759
5) $3,759 6607
6) $6,607

If someone could give me the formula with a little description it would be very beneficial to me.

Thanks.
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,708
Members
410,630
Latest member
Maggie28
Top