Results 1 to 4 of 4

Spreding a number wholly and equally over a fixed number of cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    DXB
    MS-Off Ver
    MS OFFICE MAC
    Posts
    1

    Spreding a number wholly and equally over a fixed number of cells

    Hi Guys,

    I was hoping someone one can assist I'm looking to build a calculator that will split a fixed delivery quantity over 24 months to the nearest whole number and leave the remaining balance to be paid on the last month.

    I have a attached an example of what I've done so far. but as an overview.

    The problem is I can't get it to evenely spread over 24 months where the qty owed at the end of month 24 = 0

    If someone can assist or is capable of building what I'm looking for im happy to retain services. Only if you teach me at the same time
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need Help in Dividing Number Equally
    By Shakil777 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-18-2016, 08:26 AM
  2. How to add group number to equally divide number of rows
    By neualex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2015, 03:34 PM
  3. Formula to copy a number from a cell and make the number fixed
    By Brycker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2015, 01:59 PM
  4. [SOLVED] Split a number equally to multiple cells
    By zottiri in forum Excel General
    Replies: 30
    Last Post: 01-13-2015, 03:42 AM
  5. Complex query: mean with respect to time rather than fixed number of cells
    By thoabb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2014, 07:30 AM
  6. [SOLVED] Define a range of fixed number of columns, but unlimited number of rows
    By ccopac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2012, 02:23 PM
  7. Replies: 4
    Last Post: 03-10-2009, 11:42 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