Kludgy, but try this in A3 and fill across:

=IF($A$1<=$A$2,MAX(IF(COLUMN()=1,$A$1)),IF(SUM($A$2:A2)
<$A$1,A2,IF(SUM(OFFSET($A$3,,,,COLUMN()-1))=$A$1,0,$A$1-
SUM(OFFSET($A$2,,,,COLUMN()-1)))))

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have a twist on a problem that was answered earlier by
the very intelligent
>JulieD.
>
>I want to add columns A2 through P2 until it equals the
total in cell A1
>Once the total would be met it would zero out the
remainder of the cells.
>
>For Example:
>
>Cell A1 = 30
>Cell A2 = 14
>Cell B2 = 15
>Cell C2 = 16
>Cell D2 = 17 etc. (All the way to P2 which equals 29)
>
>In the end I need:
>Cell A3 to equal 14
>Cell B3 to equal 15, But we still need to add as we have
not reached
>30.
>Cell C3 to equal 1, Because we only need 1 more to total
to 30
>Cells D3 to P3 to equal 0 as we have equaled or matched
Cell A1 which is 30
>
>I hope you can help again!
>
>Andman
>
>
>.
>