Help with Distribution Formula

Cookie1214

New member
Joined
Jul 22, 2012
Messages
1
Reaction score
0
Points
0
Location
Los Angeles, CA
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!!!!
 

Attachments

  • Distribution List.xls
    22.5 KB · Views: 18

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
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($B4:D4))

and copy down
 
Top