Results 1 to 18 of 18

Long but Less formulas or Short but More Formulas

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-23-2014
    Location
    United Kingdom
    MS-Off Ver
    Microsoft 365
    Posts
    149

    Long but Less formulas or Short but More Formulas

    I was wondering if anyone knew the performance difference between using shorter formulas but more cells, or longer formulas with less cells.

    I am working on a new iteration of my workbook that already contains a lot of nested formulas doing the background work. There is heavy use of IF/IFS, INDEX and MATCH, as well as AGGREGATE and SUMPRODUCT. I have avoided arrays and volatile formulas deliberately to avoid any slowdown. Some of the formulas are 100+ lines long.

    Ideally I'm trying to reduce the original workbook to as few cells as possible to help with future updating. Something I have learnt is, on balance, longer formulas and less cells are easier to work with in the long run, especially when you are dealing with so many precedents and dependencies. It can be difficult working with cells that have dependencies 100 columns away.

    I can't say for certain so far if my workbook is calculating faster.

    What is your preference?
    Last edited by Statto; 10-18-2019 at 09:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Long formulas to breakdown R1C1 style formulas in vba
    By Dahlia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2017, 11:50 AM
  2. [SOLVED] =IF and =SUMIF formulas creating long long long data processing times.
    By comp in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-26-2014, 02:59 PM
  3. Quick short cut for formulas in rows
    By ACrossley1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-16-2014, 10:17 AM
  4. Long Array Formulas Using VBA
    By jiver1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-20-2013, 03:11 PM
  5. Excel 2007 : Long IF formulas
    By Wunderkind in forum Excel General
    Replies: 11
    Last Post: 12-01-2009, 08:29 PM
  6. English formulas and short cut keys on danish Excel
    By Kjaer in forum Excel General
    Replies: 2
    Last Post: 03-11-2008, 07:56 PM
  7. Long string of IF formulas
    By changetires in forum Excel General
    Replies: 3
    Last Post: 06-21-2006, 03:59 PM

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