Sumerize one cell and transfer the remainder to another

[Guest]

If i summerize a line of cells, say it equals a total of 34. that cell needs
to calculate the number between 0 & 9 and the remainder should be moved to
the next cell to hte left. Please advise.

 

[RagDyeR]

Don't know if I understand exactly what you're asking.

To sum a column and return a maximum total of 9:

=MIN(SUM(D110),9)

Now, a formula *can't* "move" or "push" data to another cell, but it can
"take" or "pull" data, so enter a formula in the cell to the left to "pull"
the values in excess of 9:

=(SUM(D110)>9)*(SUM(D110)-9)

Is that what you're looking for?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


If i summerize a line of cells, say it equals a total of 34. that cell needs
to calculate the number between 0 & 9 and the remainder should be moved to
the next cell to hte left. Please advise.

 

[Roger Govier]

For the first cell to give 4
=MOD(SUM(A1:H1),10)
For the second cell to give 30
=INT(SUM(A1:H1)/10)*10