Rounding help

mmm23

New member
Joined
Jun 12, 2014
Messages
1
Reaction score
0
Points
0
Location
Massachusetts
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
 

Attachments

  • Example1.xlsx
    26.8 KB · Views: 18

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,199
Reaction score
16
Points
38
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.
 
Top