# Thread: I need help with a formula??

1. Registered User
Join Date
Sep 2006
Posts
4

## Unanswered: I need help with a formula??

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

2. Registered User
Join Date
Dec 2004
Posts
37

## Hope this helps

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))

3. Registered User
Join Date
Sep 2006
Posts
4

## Okay, but.....

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•