Range Formula
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,
|