Results 1 to 3 of 3
  1. #1
    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. #2
    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. #3
    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
  •