I have a problem in Excel that I thought would be easy to solve, but so breaking your head is this: I have a request grid, for example, 2,010 pairs, and the production control and production order is 10 in 10, I need to calculate how many production orders I would need to make to produce that order, with the average value in an order of production is 300, 320, 330, 340 up to 360 (because otherwise it overloads the machine)
Then, as the request is 2010 pairs, and I divide by 340 for example, gets 5.91 ops, from a decimal number. What I wanted was a function or formula, in which Excel would not break, where in this example, the output value would be: 5 ops of 340 and 1 of 310, totaling the 2010 pieces. Can you do that?