# Overcoming limit of nested IF functions

1. ## Overcoming limit of nested IF functions

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

Jon

2. HA!

Well as soon as I posted that an idea struck me!

I entered the formula

=IF(A\$1<=7,E\$13,IF(A\$1>=8,F\$13))

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.

Job done!

3. 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.

hmmmmm

4. 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1