+ Reply to Thread
Results 1 to 3 of 3

reduce levels of nesting

  1. #1
    Registered User
    Join Date
    02-10-2008
    Posts
    13

    Red face reduce levels of nesting

    {=IF(C12="","",IF(C12=$G$4,"",IF($G$5="Yes",IF(MIN(IF(ISNA(MATCH(MAX($E$9:INDEX(11:11,$G$2+4)),C$9:C11,0)),MAX($E$9:INDEX(11:11,$G$2+4))))=0,"",MIN(IF(ISNA(MATCH(MAX($E$9:INDEX(11:11,$G$2+4)),C$9:C11,0)),MAX($E$9:INDEX(11:11,$G$2+4))))),IF(MIN(IF(ISNA(MATCH(MAX($E$9:INDEX(12:12,$G$2+4)),C$9:C12,0)),MAX($E$9:INDEX(12:12,$G$2+4))))=0,"",MIN(IF(ISNA(MATCH(MAX($E$9:INDEX(12:12,$G$2+4)),C$9:C12,0)),MAX($E$9:INDEX(12:12,$G$2+4))))))))}

    Though I use 2007, I'd like to be able to save it in xls format.

    Should I just use multiple cells?

    Any advice appreciated. Thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: reduce levels of nesting

    That's just a big, unwieldy, unmaintainable formula that someone would need to reverse engineer to divine your intent.

    How about some useful background?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: reduce levels of nesting

    I can at least save you one level:

    Change: {=IF(C12="","",IF(C12=$G$4,"", to {=IF(OR(C12="",C12=$G$4),"",

    Beyond that.. I would need to get my decoder ring.

+ 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