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!!
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
quot;Juliequot; wrote:
gt; I am really a rookie when it comes to excel. Can you have more than one IF
gt; statement in a cell? For example, I have a drop down chart with a list of 7
gt; people, I want one cell to list different information depending on which
gt; person is chosen from the drop-down menu. Please Help!!
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!!
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
quot;Juliequot; wrote:
gt; I am really a rookie when it comes to excel. Can you have more than one IF
gt; statement in a cell? For example, I have a drop down chart with a list of 7
gt; people, I want one cell to list different information depending on which
gt; person is chosen from the drop-down menu. Please Help!!
文章標籤
全站熱搜
