Results 1 to 7 of 7

Help with dividing Cell into Equal Amounts?

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Springville, Utah
    MS-Off Ver
    Mac version 16.16.5
    Posts
    30

    Question 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.
    Attached Files Attached Files
    Last edited by afprinter; 03-08-2022 at 02:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Make model faster: convert formulas to text and then back to formulas
    By lucassdm7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-25-2019, 06:49 AM
  2. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  3. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  4. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  5. [SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values
    By faby2203 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2013, 07:05 AM
  6. Multiple formulas in selected cell without damaging previous formulas.
    By excel5111987 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-05-2011, 06:15 AM
  7. Replies: 5
    Last Post: 05-05-2008, 02:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1