+ 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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    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)

Similar Threads

  1. Complicated formula help?
    By Dan.Mo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-02-2018, 12:51 AM
  2. Formula for multiple data points and references
    By stacyhoffman17 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2017, 11:27 AM
  3. Complicated SUM formula help!
    By sravani10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2016, 05:39 AM
  4. Need help with complicated IF formula
    By sparker08 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-19-2015, 03:44 PM
  5. IF formula help..little bit complicated
    By jgy6000 in forum Excel General
    Replies: 1
    Last Post: 03-02-2011, 09:13 AM
  6. [SOLVED] Complicated IF Formula
    By Luke in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2005, 10:20 AM
  7. [SOLVED] Complicated Formula
    By Stephen in forum Excel General
    Replies: 12
    Last Post: 04-17-2005, 09:06 AM

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