Combine IF Statements with Other Functions to List of Numbers

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

Sure. Assuming A1:A700 is your range:

B1:

=if(A1=min($A$1:$A$700),"SMALLEST",IF(A1=MAX($A$1:$A$700),"LARGEST",IF(AND(A1>=3000000,A1<=4000000),"HIGH RANGE",IF(AND(A1<3000000,A1>=2000000),"MID RANGE",IF(AND(A1>=1000000,A1<2000000),"LOW RANGE")))))

and copy down

So using AlKey's ingenius example, you could truncate my previous solution to:

=IF(A1=MIN($A$1:$A$700),"MIN",IF(A1=MAX($A$1:$A$700),"MAX",LOOKUP(A1,{1000000,2000000,3000000,4000000},{"MIN RANGE","MID RANGE","MAX RANGE"})))

Thank you both for two great solutions.

Tom