ExcelBanter - IF Statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statements (https://www.excelbanter.com/excel-discussion-misc-queries/86213-if-statements.html)

Julie

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

Jerry W. Lewis

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

All times are GMT +1. The time now is 07:36 PM.