Hello all,
I am basically trying to find a way to get around the fact that you can only nest up to 7 IF functions in one cell. Let's say I need 14 functions. Was wondering if I can somehow split the 14 function into two cells of 7 nested if functions. and then have a third cell which will display one or the other.
Gosh, hard to describe what I want...
I was thinking, for example, lets say i have in one column, 1,2,3,4,5,6,7 and then in another column I have 8,9,10,11,12,13,14... these will be for reference only...as I want to be able to in one single cell input 1 to 14...probably from a drop down menu.
So basically if I pick 1,2,3,4,5,6 or 7 then the first cell will be displayed in the "result" cell. and then of course if 8 thru to 14 is chosen the second cell will be displayed in the "result" cell. Do you know what I mean?
I think if I could put a formula along the lines of:
IF(A1="1,2,3,4,5,6 or 7", "cell 1", IF(A1="8,9,10,11,12,13 or 14", "cell2"))
so if A1 displays 1 to 7, the result cell will display the result of the first set of nested functions, and the same for 8 to 14.
Hope you can understand what i am trying to get over here...
Many thanks in advance,
Jon
Bookmarks