If the accurals are in column A and the used are in column B:
=MIN(SUM(A1:A100)-SUM(B1:B100),1234)

where 1234 is the max
--
Gary''s Student - gsnu200909


"Roberta" wrote:

I need help with getting a formula to work.

I have a spreadsheet that add time accured and subtracts time used... what I
need is for it to stop and not continue to add accured time if the max is
reached.

Thanks for any help offered.