Help with dividing Cell into Equal Amounts?

I work in manufacturing. Part of my job is to determine the number of pallets that are going to be required on each job and print sheets for these jobs to be put on the pallets in the warehouse. These are job specific labels to identify pallets in the warehouse.

I have built a spreadsheet to figure out the total number on sheets that I need to print out. I think that I have things figured out except, I cannot figure out the formulas in Columns M, N, O, P. When the column L amount is more than 250, I need to split the printed amount in an equal amount in multiple envelopes, other than in column M. It also needs to have column I added to it. (i.e. Row 4 would be 2 envelopes. Row 5 would be 3 envelopes. Row 6 would be 4 envelopes).

Any help would be appreciated!!!!

Greg


I have added roughly to the spreadsheet what I am trying to get with the splitting of the amount.

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Yes, that would do OK.

Grand.

So, I'm not entirely clear what you want... and I promise not to write in Chinese... but to get things going:

=ROUNDUP(L4/250,0)

copied down??

I'm not sure what you expected to see and where... so this is just an opening guess...

It might also help if you added some manually calculated expected answers in the cells where you want them to appear.

... this includes function names used without an indication of what you are trying to achieve.

Just FYI, this means DON'T use function names - instead, say what you are trying to do. Your improved title is just fine.