# Using Excel to Calculate Layers

#### TheKB

##### New Member
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

Last edited:

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Replies
3
Views
159
Replies
1
Views
103
Replies
8
Views
189
Replies
0
Views
326
Replies
3
Views
186

1,211,457
Messages
6,101,966
Members
447,766
Latest member
cool_aikon

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back