Results 1 to 2 of 2

Thread: Help with Distribution Formula

Threaded View

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

    Help with Distribution Formula

    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

Posting Permissions

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