mmm23
New member
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
Thanks,
M
Rounding help
- Thread starter mmm23
- Start date
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 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.
=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.