Help with nested IF statements

[Jennifer]

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!

 

[Niek Otten]

Hi Jennifer,

Please don't multi-post.
Your question has been answered in another newsgroup

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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!
|

 

[Joel]

Instead of an IF statement you can use the array form of the LOOKUP function.

=LOOKUP(A1,{0,300000,2000000,10000000,200000000;"Micro","Small","Mid","Large",""})