Tagameechi
New member
- Joined
- Oct 17, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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!
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!