=MIN(A1,SUM(A2:P2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andman" wrote in message
...
I have cell A1 which equals 12000.

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.

How do I do that?

Thanks for the help!
And