# Thread: Help with Distribution Formula

1. ## 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!!!!

2. 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
•