Using Excel to Calculate Layers

[TheKB]

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

 

[TheKB]

Please help because I am a sorry user who needs to get some sleep!!