+ Reply to Thread
Results 1 to 2 of 2

Minimizing IF statements

  1. #1
    Registered User
    Join Date
    06-16-2008
    Location
    Arlington, VA
    MS-Off Ver
    2007
    Posts
    93

    Minimizing IF statements

    I am working with a lot of data and I am using tons of IF statements. I imagine these are eating up a lot of calculation time. What are some ways around this? I have an IF statement in nearly every formula, so a quick fix would be helpful, but I am also willing to start over...any suggestions would be great.
    I am also using a lot of VLOOKUPs which I think might be sapping a lot of calculation time.

  2. #2
    Registered User
    Join Date
    08-28-2008
    Location
    Dallas
    Posts
    16

    IF statements

    It's easy for the use of multiple IF statements to eventually involve some unneeded redundancy. It's hard to know where that might exist without seeing the example.

    Ultimately the big way to reduce calculation time (if you don't need to recalc things often - ie. if the relevant data doesn't change much) is to either:
    1) Create a macro that executes what the IF statements are designed to do, and just run it as needed
    2) Simply copy what isn't going to change and paste it 'as value' (of course saving this as a new workbook so you don't look any work).
    But again this all depends on your situation (ie. how often data involved in the IF statements are actually subject to change).

    Feel free to forward an example - [email protected]

+ 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. Case Select statements with "if" statements
    By compulsiveguile in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2008, 12:05 PM
  2. Multiple IF THEN ELSE statements not working
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2007, 08:14 PM
  3. Too many IF statements
    By shane24 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2007, 07:52 PM
  4. Combining IF Statements
    By Gambinus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2007, 11:52 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