Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Any spreadsheet and/or math wizards out there?

September 23, 2007 11:03am

Subscribe [0]

#1 / Sep 23, 2007 11:03am
Eric Barstad
198 posts
I’ve got a math question/spreadsheet question that I can’t quite wrap my head around, and I don’t have the terminology to Google it.

Basically, I want to take a number and break it down into groups/number ranges as follows:

e.g., 250
```
1-50 | 50
 51-100 | 50
101-200 | 100
201-500 | 50
```
e.g., 129
```
1-50 | 50
 51-100 | 50
101-200 | 29
201-500 | 0
```
Does anyone know how I could do this automatically with a formula so that when I plug in a number like 250, it breaks it down into those ranges?