# Break a number down to smaller bands

#### Chryso

##### New Member
Hi to all!
Two days now I am trying to solve this puzzle so any suggestions/ideas you may have would be greatly appreciated!!
Here is the issue:

I have a series of different numbers that I need to break down into smaller ones (bands)
For example
Numbers
2.447
3.826
4.790
6.428
Need to be broken down to:
1st band = 1.000
2nd band = 1.500
3rd band = 1.500
4th band = 1.500
5th band = 1.500

The end result looks like this:

Bands 1.000 1.500 1.500 1.500 1.500

2.447 1.000 1.447 0 0 0
3.826 1.000 1.500 1.327 0 0
4.791 1.000 1.500 1.500 791 0
6.429 1.000 1.500 1.500 1.500 929

Thanks!
Chrisso

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### Chryso

##### New Member
Thank you so much!!!!

#### konew1

##### Well-known Member
OOPs
The formula in column B will work, but it is poorly constructed.
=MIN(1,\$A5) should be =MIN(B\$3,\$A5)
Should avoid putting constants into formula, especially if they also are stated on the sheet.

#### Chryso

##### New Member
Correct, thank you

Replies
1
Views
604
Replies
6
Views
3K

1,196,010
Messages
6,012,841
Members
441,733
Latest member
MartijnB

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