I need to calculate layers within numbers (currency.) Using Excel, how can I have it return the calculations as in this example:
Three Known Values:
$956,132
$12,336
$236,000
What part of each value is </= $25,000?
What part of each value is > $25,000 and </= $100,000?
What part of each value is > $100,000 but </= $250,000?
What part of each value is > $250,000?
I'm using Excel 2003
My format should look something like:
$956,000 $25,000 $75,000 $150,000 $706,000
$12,336 $12,336 $0 $0 $0
$236,000 $25,000 $75,000 $136,000
Three Known Values:
$956,132
$12,336
$236,000
What part of each value is </= $25,000?
What part of each value is > $25,000 and </= $100,000?
What part of each value is > $100,000 but </= $250,000?
What part of each value is > $250,000?
I'm using Excel 2003
My format should look something like:
$956,000 $25,000 $75,000 $150,000 $706,000
$12,336 $12,336 $0 $0 $0
$236,000 $25,000 $75,000 $136,000
Last edited:
