Results 1 to 10 of 10

Split / divide a number according to another number | ex: 750 | 250 | = 250 250 250

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    23

    Split / divide a number according to another number | ex: 750 | 250 | = 250 250 250

    Hello,

    I am trying to make a production schedule that will sort total order value into days according to max daily capacity, something like:

    capacity amount could be different for different orders

    order (piece) capaticy 01.03 02.03 03.03 04.03 05.03 06.03
    1. 650 250 250 250 150
    2. 1000 450 300 450 250
    3. 3750 2000 1750 2000


    I am asking to excel gurus how can i make a formula like this? I need to do it as i did on my excel file
    Here my excel file
    SAMPLE.xlsx
    Last edited by zottiri; 03-02-2015 at 08:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 11-26-2013, 05:21 PM
  2. [SOLVED] Divide with min number and nonzero number
    By azimuiz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-30-2013, 05:36 AM
  3. If number does not divide evenly into another number
    By EdwardC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2013, 01:09 PM
  4. How to divide an odd number
    By tarmon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2008, 12:15 PM
  5. How do I divide a number by another number when there is no divis.
    By Ursula in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-04-2005, 12:06 PM

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