Results 1 to 3 of 3

Thread: Divide X into Y whole numbers that total X

  1. #1

    Divide X into Y whole numbers that total X



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

    I'm pretty sure this should be simple but my Excel skills are just not up to it!
    Per the attached, I'm trying to divide B4 by B1 in cells B5:B8. The results must be whole numbers (or zeros) and the sum must equal B4.
    As you will see, my current solution is inelegant at best (and doesn't work if B1 < 3)!
    Appreciate any help.
    Thanks!
    Attached Files Attached Files

  2. #2
    Here is one solution
    Attached Files Attached Files

  3. #3
    Thank you!

Posting Permissions

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