Hi,
i worked on a similar problem some time back. May be this helps. The
datain the table is something like this (Range B2:D8):
Income slab Rate
- 0%
50,000.00 10%
150,000.00 20%
320,000.00 30%
600,000.00 40%
The total taxable income i sentered in cell D10.
In cell C12, array enter the following formula (Ctrl+Shift+Enter)
=SUM(IF($D$10<B4:B8,0,IF(B5:B9-B4:B8$D$10,$D$10-B4:B8,IF(B5:B9-B4:B80,IF(B5:B9-B4:B8$D$10-B4:B8,$D$10-B4:B8,B5:B9-B4:B8),$D$10-B4:B8)))*(C4:C8))
Regards,
Ashish Mathur
"DG" wrote:
It starts out at a flat fee of $316.25 for everything from 0 to $55,000.00,
and then adds $5.75 per $1,000.00 up to a maximum of $100,000 and then
anything over $100,000 the rate drops to $5.00 per $1,000 up to 1 million.
What I am attempting to do is place a number like $250,000 in a box and have
excel do the equation and automatically place $1,325.00 in another box.
|