Help with nested IF statements
 

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!

Help with nested IF statements
 

Hi Jennifer,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Help with nested IF statements
 

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

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

"Jennifer" wrote:

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!