Results 1 to 2 of 2

Thread: Help with Distribution Formula

  1. #1
    Neophyte Cookie1214's Avatar
    Join Date
    Jul 2012
    Los Angeles, CA

    Help with Distribution Formula

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all!

    I am very new to excel and really need some help. I am in charge of distributing merchandise to a chain of grocery stores. I need to divide my deliveries between four days by using this formula
    30% on Monday
    30% on Wednesday
    20% on Thursday
    20% on Friday

    Currently I am having to do this by hand every day and it is extremely time consuming. I would like the formula to be able to divide odd and even numbers and if I only have 1 pallet or two pallets for the formula to be able to distinguish and distribute accordingly between columns. I have attached the sheet that I am currently working with. PLEASE HELP!!!!
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    B4: =MAX(1,ROUND(F4*30%,0))
    C4: =MIN(ROUND($F4*30%,0),$F4-SUM($B4:B4))
    D4: =MIN(ROUND($F4*20%,0),$F4-SUM($B4:C4))
    E4: =MIN(ROUND($F4*20%,0),$F4-SUM($B44))

    and copy down

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts