With the values in A1

=IF(A1="","",VLOOKUP(A1,{0,"Micro Caps";300000000,"Small
Caps";2000000000,"Mid Caps";10000000000,"Large Caps";200000000000,"Mega
Caps"},2))



--


Regards,


Peo Sjoblom


"Jennifer" wrote in message
...
Ok here is what i am neededing help with i have to write a nested IF
formula
that meets the following conditions, and after working on it for hours i
have
decided i need help.

Companies are categorized according to their market capitalization.
Microcaps are companies with market value below $300 million. Small caps
are
the ones between $300 mil and $2 billion, Mid caps are the ones between $2
billion and $10 billion. Large caps are the ones between $10 billion and
$200
billion, and Mega caps are the ones above $200 billion, if there is no
market cap then they are blank.

can someone please tell me the best way/formula for this equation, i know
that i need to have 4 IF statements im just confused on exactly how to do
the
ones that are one amount between another.

thanks so much for any help!