Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtract Formula (Excel 2003)

    Is there an easy way to create a formula for the following example: 13,000-6,000=(total); then keep subtracting 6,000 from subsequent totals, eventually ending up with a zero total. I hope I explained this correctly. Thanks for any help!! Go Pens!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subtract Formula (Excel 2003)

    How are you going to end up with a zero total doing that? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtract Formula (Excel 2003)

    Good Question Hans - here's what we needed. We're setting up a column of numbers and want to subtract 5779.91 from each prior total - so in our first cell (A1) we have =1387177.25-5779.91, which gave us a total; then for cell A2 we have =A1-5771.91. Cell A2 is then repeated for our remaining cells (A3, A4, A5, etc.)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subtract Formula (Excel 2003)

    So your problem has been solved?

  5. #5
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtract Formula (Excel 2003)

    Yes, we are good to go! Thanks for your response.

Posting Permissions

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