Overcoming limit of nested IF functions
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,
Well as soon as I posted that an idea struck me!
I entered the formula
and this solves my problem
the 2 IF cells can now work by referencing A1 and also the results cell looks at the right IF cell.
Hmm this actually only helps me if the input test is numerical and I can use < etc.
My test is actually differing letters eg I3, I4, I5, I6, V6, V8 and so on...so I can't simply say <7 eg.
LOL OK I am just gunna keep talking to myself and I will find the answer heh heh
now I realise I can still do <=I999 or <=V999
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1