+ Reply to Thread
Results 1 to 3 of 3

Nested If formulas over 300 rows and 300 columns - file too big

  1. #1
    Registered User
    Join Date
    07-14-2018
    Location
    nairobi
    MS-Off Ver
    2010
    Posts
    2

    Nested If formulas over 300 rows and 300 columns - file too big

    Hey guys, is there any way to make this formula less complicated:

    =IF(C$1<=$B698+Assumptions!$C$17,IF(INT((C$1-$B698+1)/Assumptions!$C$40)=((C$1-$B698+1)/Assumptions!$C$40),SUM(C66:$C66),0),0)

    It is going across 300 columns and 300 rows, and there are 2 such tables, so my file is huge.

    I am not sure exactly what background to give because the file is just too huge and takes ages to open. Basically this formula is the first in the cell and I drag it across 300 columns and down 300 rows.
    Last edited by sagarxshah; 06-14-2019 at 09:27 AM.

  2. #2
    Registered User
    Join Date
    07-14-2018
    Location
    nairobi
    MS-Off Ver
    2010
    Posts
    2

    Re: Formula too complicated

    Ok, sorry no solution, but have managed to attached the file.

    I reduced the file by deleting all the formulas that are to be dragged down and across.

    Please see cell B330 which I want to drag down and across for 300 rows and 300 columns. And the same for the next table.

    It goes completely haywire!
    Attached Files Attached Files
    Last edited by sagarxshah; 06-14-2019 at 08:10 AM.

  3. #3
    Forum Moderator
    Join Date
    05-14-2009
    Location
    RDC
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    6,926

    Re: Formula too complicated

    Title much more descriptive. thanks
    Last edited by Pepe Le Mokko; 06-14-2019 at 09:39 AM.

+ 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