+ Reply to Thread
Results 1 to 2 of 2

Help with reading =MIN formula

  1. #1
    Registered User
    Join Date
    03-22-2012
    Location
    jacksonville, florida
    MS-Off Ver
    Excel 2007
    Posts
    94

    Help with reading =MIN formula

    Can someone please tell me what this formula is doing?



    =min(5-bi$10,
    if(and($x11>=bi$2,$x11<bj$2),if($af11<bj$2,$af11-$x11+1,bj$2-$x11-2),if(and($x11<=bi$2, $af11>=bj$2),5, if(and($af11>=bi$2,$af11<bj$2),$af11-bi$2+1,0)))
    +if(and($y11>=bi$2,$y11<bj$2),if($ag11<bj$2,$ag11-$y11+1,bj$2-$y11-2),if(and($y11<=bi$2, $ag11>=bj$2),5, if(and($ag11>=bi$2,$ag11<bj$2),$ag11-bi$2+1,0)))
    +if(and($z11>=bi$2,$z11<bj$2),if($ah11<bj$2,$ah11-$z11+1,bj$2-$z11-2),if(and($z11<=bi$2, $ah11>=bj$2),5, if(and($ah11>=bi$2,$ah11<bj$2),$ah11-bi$2+1,0)))
    +if(and($aa11>=bi$2,$aa11<bj$2),if($ai11<bj$2,$ai11-$aa11+1,bj$2-$aa11-2),if(and($aa11<=bi$2, $ai11>=bj$2),5, if(and($ai11>=bi$2,$ai11<bj$2),$ai11-bi$2+1,0)))
    +if(and($ab11>=bi$2,$ab11<bj$2),if($aj11<bj$2,$aj11-$ab11+1,bj$2-$ab11-2),if(and($ab11<=bi$2, $aj11>=bj$2),5, if(and($aj11>=bi$2,$aj11<bj$2),$aj11-bi$2+1,0)))
    +if(and($ac11>=bi$2,$ac11<bj$2),if($ak11<bj$2,$ak11-$ac11+1,bj$2-$ac11-2),if(and($ac11<=bi$2, $ak11>=bj$2),5, if(and($ak11>=bi$2,$ak11<bj$2),$ak11-bi$2+1,0)))
    +if(and($ae11>=bi$2,$ae11<bj$2),if($am11<bj$2,$am11-$ae11+1,bj$2-$ae11-2),if(and($ae11<=bi$2, $am11>=bk$2),5, if(and($am11>=bi$2,$am11<bj$2),$am11-bi$2+1,0))))

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Help with reading =MIN formula

    Without delving too much, it seems to be finding minimum value between 5-bi$10 and a summation of a host of different conditions that would either result in 5 (each) or ag11/ah11/ai11/aj11/ak11/al11/am11-bi$2+1,0

    perhaps the worksheet itself would provide further insight
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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