| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statements
I am really a rookie when it comes to excel. Can you have more than one IF
statement in a cell? For example, I have a drop down chart with a list of 7 people, I want one cell to list different information depending on which person is chosen from the drop-down menu. Please Help!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statements
You can have up to 7 nested functions (which can all be IF functions) in a
cell. However, a better approach might be a lookup table. See Help for VLOOKUP. Jerry "Julie" wrote: I am really a rookie when it comes to excel. Can you have more than one IF statement in a cell? For example, I have a drop down chart with a list of 7 people, I want one cell to list different information depending on which person is chosen from the drop-down menu. Please Help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| "IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Linear Mode
