Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF STATEMENT HELP
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Help with an if statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |