Fractional Categorizing

[Rudi]

I hope I can ask this question clearly...

Say I have a column of numbers from 1 - 20.
I want to categorize these numbers like this:
0 = category 0
5 = category 1
10 = category 2
15 = category 3
20 = category 4

In the original spreadsheet the categories were easy...All less than 5 = 0, less than 10 = 1, less than 15 = 2, etc...
Now the problem is that the categories must be decimalized, 0.0 - 0.9, 1.0 - 1.9, etc...

So if a value is 8, then it will not be in category 1, but should be in category 1.6 (or something like that...1.6 is a guess, not the actual category).

What calculation must I use to determine a decimaled category???

TX

[Leif]

Isn't it just the number divided by 5? (e.g. 8/5 = 1.6)

[StuartR]

Rudi,

Your requirements seem to be a bit contradictory.

Firstly you say the categories are "0.0 - 0.9, 1.0 - 1.9, etc..." I took this to mean that
0.0 to 0.9 are in category 0
1.0 to 1.9 are in category 1
etc.
But then you say that there is a category 1.6, so I am rather confused.

Could you please express your requirements more clearly, giving the end points for each category

[Rudi]

Hi Stuart,

Please note that I wrote: All less than 5 = 0, less than 10 = 1, less than 15 = 2, etc...

The table I created is showing only the category numbers that are whole numbers:
5 = category 1
10 = category 2
15 = category 3
20 = category 4
so, if the value is 4, then it will be 0.8 (ie: all less than 5 = a category value of 0.?)

Sorry if you misunderstood, however Leif has provided the (VERY SIMPLE, RATHER EMBARRASSING 4 ME) solution. =Value/5

Thanks for the help all!!