Put this formula in B1:

=ROUND($A1/6,2)

and copy to cells C1:F1. Put this formula in G1:

=A1-SUM(B1:F1)

I'm not sure where H1 comes into it.

Hope this helps.

Pete

NEYS wrote:
I have a worksheet with data. I need to be able to divide a number evenly
between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33
but since the numbers do not divide evenly I need G1 to read 58.32. I also
need H1 to read 0.00 or blank. Please, please, please I need help I have
been trying to figure it out on my own for the past few days!!!
Thank You,
--
NEYSA