Range Formula

[aleksandr]

Hello!
I would like to know if Microsoft excel has some kind of formula to be used for this application:

I would like to split total cost 54,000 and this number will not stay the same:

the first 0-20,000 of 54,000 i want it to be multiply by 10%

the 20,001-50,000 or the 54,000 to be multiply by 7.5%

the 50,001-and higher of 54,000 will be multiply by 5%

I want excel to multiply automatically when I plug any number for total cost and be split without changing formula all the time.

See below for more information.

But the total cost will not always be above $50,000. It can be below or over $50,000.

Total Cost $55,000 $35,000 $15,000

10% overhead the first $2,000 $2,000 $1,500


$20,000.00 ($0 to $20,000)

7.5% overhead next $30,000 $2,250 $1,125 $0.00
($20,001 to $50,000)

5% overhead on Balance over $250 $0.00 $0.00
$50,000

Total with overhead $59,500 $38,125 $16,500

I input these numbers manually.

I want excel to do this automatically, doesn’t matter on the Total Cost without changing formula all the time.

see attached file

Thank you,