DIVIDING CELLS WITH A BALANCE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with data. I need to divide the total price by say 6
different sessions. The numbers do not divide evenly so there might be a 1 or
2 cent balance. I need it to be zero in the end. I need the pennies to be
added to the last session redeemed. A1=374.98(total price), B1=62.50(session
1), C1=62.50(session 2)..... at the end H1=0.00. However 374.98/6 does not
equal to 62.50*6 evenly. Please help me
 
If the total is in A1 then use:

=ROUNDDOWN(A1/6,2)

for each of the first 5 sessions. For the sixth session use:

=A1-5*ROUNDDOWN(A1/6,2)


Gary's Student
 
Back
Top