+ Reply to Thread
Results 1 to 5 of 5

Formula quest for Nested IF statements

  1. #1
    Registered User
    Join Date
    12-15-2011
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Formula quest for Nested IF statements

    Hi all!

    I m a newbie here.. I have some Excel problems which I couldn't solve, hope to get help here..

    Pls see attached excel sheets.

    Thanks guys!

    Rgds,
    CK
    Attached Files Attached Files
    Last edited by kiong234; 11-17-2012 at 04:13 AM.

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Stock Allocation

    Hi kiong234

    You will need to rename your thread title , to something a bit more meaningful.

    Have a look here: Forum Rules

  3. #3
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Stock Allocation

    Hi, kiong234

    pls mention your problem in Thread Titles.

    Regards,
    Nandkumar Satpute

  4. #4
    Registered User
    Join Date
    12-15-2011
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Formula quest for Nested IF statements

    Thanks guys! Title changed, hope to get more attention and helps..

    ^^

  5. #5
    Registered User
    Join Date
    11-17-2012
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Formula quest for Nested IF statements

    Hi,

    I have checked your file but can you be clearer. If i change the filter on dates, the formulas don't change.
    Thx. to be more exact.

  6. #6
    Registered User
    Join Date
    12-15-2011
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Formula quest for Nested IF statements

    Thanks Mase723!

    It's because, without sorting the data from oldest dates to latest dates with same product code in one group, i can't allocate by FIFO without a helpful formula..

    I still don't know how to do it now.. So, I use manual checking on dates to allocate correctly on Alloc Qty #2.. but then, this is not efficient when i have to do it for more than 4000+ lines of data..

    ^^
    Attached Files Attached Files

+ 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