Good Evening All you Excel Geniuses!!
I need help!! I work in the purchasing department for a grocery store. I need a formula that can help me distribute loads into four days by a percentage each day with a remainder of zero.
I have tried "IF" functions, but I can't seem to get a remainder of zero... I NEED HELP!! This is really time consuming to do every day! Thank you in advance!
Example:
I need to distribute 5 pallets
Monday: 30% of the load
Wednesday:20% of the load
Thursday:10%
Friday:10%
Please post a sample workbook with some typical numbers for distribution.
Is it always those percentages? In your example above, you have only distributed 70% of the load. What happens to the other 30%?
The easiest way to get a zero balance is to use percentages for the first three days and then take what you've distributed from the total for the last day ... it may not be the exact percentage but I suspect you can't have both.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
10% of 5 palletes is 0.5 pallet.
How do you expect your answer to be without remainder?
You can split them 3,2,1,1 but this is not percentage.
like this one....????
distribute values.xlsx
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you for responding!!! You are correct about the math... I was just giving examples of percentages. I have attached a distribution list.
The first column is the stores I am distributing to, the following four columns are the days that I need to split my loads and the last column is the total amount of pallets I have to distribute. The simple formula I used works up until 5 pallets but anything after that gets a little tricky.
THANK YOU!! I am going to try this on my sheet! You are quick!! I am excel beginner, but I know Excel can save the world!! Well at least at work...
Thank you VLady... Your formula seems to be doing the trick!
in your sample file i think you will have a big amendment maybe instead of row() you will use column() but i have no time now to do that maybe you could atleast make your worksheet as formatted in the given sample file of mine, studying make's us learn more
and your welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks