IF Statements

J

Julie

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

Jerry W. Lewis

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
 
Top