Hi Everyone,

I have a list of over 700 numbers to that I want to label as follows:
1. the largest;
2. the smallest;
3. A range between 3 million and 4 million;
4. A range between 2 million and 2.9 million;
5. A range between 1 million and 1.9 million.

Can I use a combination of IF statements and MAX, MIN, AND greater than less than, etc.
in one formula?

Thanks so much for any help you can provide to me.

Tom