Results 1 to 5 of 5

nested if optimising

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2017
    Location
    germany
    MS-Off Ver
    2010
    Posts
    23

    nested if optimising

    good day all,

    i have been trying to crack this for a while now, but i cant seem to do it the file i have is to link how often we order with the lead time and keep a safety stock of a month and a half extra depending on the RC for example if its 1 then i have to keep 1.5 months extra, but if it is 2 then i have to keep 2.5 months extra. i also have to test this against the arriving month so i have 6 categories of RC and 6 categories of Lead time and testing all possibilities resulted in a 36 nested if statements to do it. i will attach the original formula (if u have time to read it) and a small test file , i hope you can help me out since excel is not allowing me to save the formula for it is more than 8K characters i had to save it as binary file.

    your help is much appreciated
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. optimising formulas
    By Trebor777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2017, 08:54 AM
  2. Help optimising my code
    By DanielPodo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2017, 10:33 AM
  3. [SOLVED] Optimising code
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2012, 11:44 AM
  4. Optimising code
    By mpower87 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2011, 11:49 PM
  5. Optimising with Formula
    By andrewc in forum Excel General
    Replies: 0
    Last Post: 06-17-2010, 07:46 AM
  6. optimising this VBA
    By brave.inf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2009, 09:44 AM
  7. Help with optimising code
    By FrigidDigit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2005, 11:05 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