Cookie1214
New member
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!!!!
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!!!!