+ Reply to Thread
Results 1 to 1 of 1

subtracting columns one at a time?

  1. #1
    Registered User
    Join Date
    09-08-2005
    Posts
    1

    subtracting columns one at a time?

    I want to subtract a number from one column of numbers and I want to see the numbers in that column decrease by the amount taken away. That is the easy part. Once all the numbers are depleted in the 1st column, or the number in the 1st column is not large enough to produce a positive number, I want to reduce the numbers in column 1 to 0 and then start subtracting numbers from the 2nd column, and again reduce the numbers in the 2nd column by the number taken away.

    This will be used as a calculator so I would like to be able to use the same formula the full length of the column.

    Example

    ACB | Current Value | Withdrawal

    4 | 5 | 2
    4 | 3 | 2
    4 | 1 | 2
    3 | 0 | 2
    1 | 0 | 2
    0 | 0 | 1

    Thank you
    Last edited by alnorman; 09-08-2005 at 01:38 PM. Reason: Here is an example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1