+ Reply to Thread
Results 1 to 4 of 4

Overcoming limit of nested IF functions

  1. #1
    Registered User
    Join Date
    05-20-2006
    Posts
    15

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

    Many thanks in advance,

    Jon

  2. #2
    Registered User
    Join Date
    05-20-2006
    Posts
    15
    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. #3
    Registered User
    Join Date
    05-20-2006
    Posts
    15
    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. #4
    Registered User
    Join Date
    05-20-2006
    Posts
    15
    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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