what is the correct excel formula if dividing the whole number using the specific range

[jun_bajenting]

pls. anyone can help me what is the correct excel formula of the below topic?
the total qty is 74 i want to divide it using the range 15-20
the result is 19,19,18,18.

 

[Rick Rothstein]

pls. anyone can help me what is the correct excel formula of the below topic?
the total qty is 74 i want to divide it using the range 15-20
the result is 19,19,18,18.

What cell is the 74 in?

What exactly do you mean by "the range 15-20"? Assuming you meant this to be cells (you need a column designation if my assumption is correct), did you want the split out values to be placed in those cells? If so, explain why you only have 4 split out values when your range contains 5 cells?

 

[jun_bajenting]

I want a formula that will automatically compute the total quantity given and i want to divide it according to a specific range.
ex. total quantity =74 if I want it to divided by a specific range like 20 the result may be 20,20,20&14 = 74.
but if I use a range between 15 to 20 the formula can use any number from 15 to 20 that will have the same result like 19,19,18&18 = 74.

what kind of formula i need to extract to have this kind of result?
anyway thanks to your reply sir Rick.