please help to find out a formula for this...

[uluk]

Pls moderator help in formula as follows:

there must be numbers between 0-100. I want to show this numbers, in different cells, with nubers between 1-5.
For example:
- if the inserted number is between 0-20, then it is shown with 1;
- if the inserted number is between 21-40, then with 2 for each inserted number;
- if the number is between 41-60, with 3 for each inserted number;
- for the numbers between 61-80, with 4 for each of them;
- for the numbers between 81-100, with 5.

Thanks for attention....

[DonkeyOte]

A few points uluk

1 - your thread title is inappropriate

2 - you have already asked this question (and been given an answer)

http://www.excelforum.com/excel-misc...ne-number.html

Please ensure you read and subsequently adhere to the forum rules before posting any further.