IF Statements-Can you have more than one IF statement in a cell?

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

[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

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