I need a formula that adds up to a certain number but will not go past that number. It will subtract from that number..

Examp: I want it to add (aj +8) up to 480
when the number reaches 480 it no longer will add but it will subtract....help me please

You may need to change the references, but this should do the job.

It adds up the numbers in A8,B8 and C8 and once they cross the 480 barrier it will start to count backwards.

=IF(SUM(A8:C8)<=480,SUM(A8:C8),480-(SUM(A8:C8)-480))

Is it possible that once it reaches 480 instead of having it count backwards to have 480 remain constant until the sum of another cell is subtracted from it.

I really appreciate this