Dividing integers in MS Excel (exact division)

Question

I have a problem in Excel that I thought would be easy to solve, but to breaking my head is the following: I have an order grid, for example, 2,010 pairs, and the production control and the production order, is 10-10, I need to calculate how many production orders I would need to make to produce this order, and the average value in a production order is 300, 320, 330, 340 up to a maximum of 360 (otherwise it overloads the machine)

So, since the order is 2010 pairs, and I’m going to divide by 340 for example, it’s 5.91 ops, from a decimal number. What I wanted was a function or formula, in which Excel did not break, where in this example, the output value would be: 5 ops of 340 and 1 of 310, totaling the 2010 pieces. You can do it?

Answer 1

You can use the formula =ARREDONDAR.PARA.BAIXO(A2/B2;0) to calculate the whole number, and the quantity in the OP with the rest would be according to the formula =A2-B2*C2.

Thus:

Then you can play around with column B to arrive at a value you like in columns C and D.