Dividing integers in MS Excel (exact division)

4

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?

    
asked by anonymous 29.05.2015 / 20:14

1 answer

3

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

So:

Then you can play with column B to get a value that pleases you in columns C and D.

    
29.05.2015 / 20:23