Results 1 to 2 of 2

Thread: Rounding help

  1. #1
    Neophyte mmm23's Avatar
    Join Date
    Jun 2014
    Location
    Massachusetts
    Posts
    1
    Articles
    0

    Rounding help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    What formula can I use to take a number and divide over 16 periods and when summed it equals the orginal number. See work book attached.

    Thanks,
    M
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    Not the even distribution of values like yours but in, say, J6:
    =ROUND((D6-SUM(Q$5:Q5))/($J$2-ROW()+5),0)
    and in K6:
    =ROUND((E6-SUM($R$5:R5))/($J$2-ROW()+5),0)

    both copied down.

Posting Permissions

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