dcollierjr
New Member
- Joined
- Jul 23, 2018
- Messages
- 4
Thank you for all of your topics. I skimmed over "some" of them looking for an answer for this sheet. I can and do have a sheet where I can make the formulas work using basic skills.
ie...(B6*12*$E$3)+(C6*$E$3)+D6 to give me the break-down of the desired sum. I want to do it in reverse of this order.
When a number is placed in A6, "2604" I want C6 to populate the solution in the box in this case it will be 5 because 5 *12 = 2400 It can't be a higher number because it would be too many papers if a complete layer was multiple of 12. So 6*12*40 would be 2880, more than the original total in A6.
then
Anything that is left out of the C6 total should populate into E6. Meaning as the total was less that 1 layer (12 bundles) So it can be 11 bundles to at least 1 bundle. In this case 5 bundles of the bundle size of 40 (A2) would populate to 200 papers or 5.
Then
G6 should be a number between 39 and 1, because it is less than the bundle size in A2.
A2 is 40.
What I am trying to do is for someone to give my night foreman a total and once she puts the data in the "Total Papers" box the rest is done, taking the human factor out of the picture. I hope I have explained the scenario well enough.
I have another spreadsheet needing some "guru" touch. As a self taught novice, I can only scratch my head until I start bleeding. I can go into greater detail on that sheet later. I even asked someone "friend of a friend" to help, but he never got back with me.
Thanks in advance.
Don
ie...(B6*12*$E$3)+(C6*$E$3)+D6 to give me the break-down of the desired sum. I want to do it in reverse of this order.
When a number is placed in A6, "2604" I want C6 to populate the solution in the box in this case it will be 5 because 5 *12 = 2400 It can't be a higher number because it would be too many papers if a complete layer was multiple of 12. So 6*12*40 would be 2880, more than the original total in A6.
then
Anything that is left out of the C6 total should populate into E6. Meaning as the total was less that 1 layer (12 bundles) So it can be 11 bundles to at least 1 bundle. In this case 5 bundles of the bundle size of 40 (A2) would populate to 200 papers or 5.
Then
G6 should be a number between 39 and 1, because it is less than the bundle size in A2.
A2 is 40.
What I am trying to do is for someone to give my night foreman a total and once she puts the data in the "Total Papers" box the rest is done, taking the human factor out of the picture. I hope I have explained the scenario well enough.
I have another spreadsheet needing some "guru" touch. As a self taught novice, I can only scratch my head until I start bleeding. I can go into greater detail on that sheet later. I even asked someone "friend of a friend" to help, but he never got back with me.
Thanks in advance.
Don
Last edited by a moderator: